Well, you see, this is most likely my special DBMS_OPTIM_BUNDLE week. And since I receive quite a number of questions, it may be good to discuss here about DBMS_OPTIM_BUNDLE and Out-Of-Place Patching?
Out-of-place Patching
When you patch out-of-place with a new home – which is clearly our recommendation – you may see another tiny pitfall with DBMS_OPTIM_BUNDLE.
When you check DBA_DIRECTORIES, you will find two directories being related to DBMS_OPTIM_BUNDLE.
SQL> select directory_name, directory_path from dba_directories where directory_name like '%OPTIM%' DIRECTORY_NAME DIRECTORY_PATH -------------------- -------------------------------------------------- DBMS_OPTIM_LOGDIR /u01/app/oracle/product/19/cfgtoollogs DBMS_OPTIM_ADMINDIR /u01/app/oracle/product/19/rdbms/admin
You see the “19” in the …
Continue reading...
