Along with existing RMAN backups we do Exports - of our DB using and OS User and Oracle Wallet.
Of the DB's we have upgraded the Data Pump Directory
Select * from dba_directories; (there are other commands to get this info as well).
I captured screens from the DBUA upgrades, but did not see an option to change this information.
Is there a way to feed this information to the install moving forward. IE, ./DBUA -silent ?
Also, anyone tracked the percentage of storage increase from 10.2/11.1 to 11.2.
All the ones we did grew, so be aware.
Thanks in advance!
I guess since there has been no response, the answer is this cannot be set or maintained during the upgrade.
I guess the workaround is to add to checklist before to verify and after to change back.
This should be included in some best practice information somewhere (if not already).
Thanks for confirming/re-inforcing this!
Are you stating that the upgrade process is changing or resetting data in DBA_DIRECTORIES ? It should not - if you have documented this experience, pl report it to Support - it may be a known bug or a new one.
The increase in size of the database should only be restricted to SYSTEM and SYSAUX tablespaces (and possibly TEMP and UNDO), but user tablespaces should see no increase.