Re: DataPatch Query wit Cloned ORACLE_HOME

Posted by ErmanArslansOracleBlog on
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/DataPatch-Query-wit-Cloned-ORACLE-HOME-tp4319p4333.html

Yes, you can use that Oracle Home..
Clone it. CLean the unnecessary things(old spfile, tns files etc.) on it and use it.
So, steps 1,2,3 using the method above.
Then continue with 4,5 and 6 one by one.

Info: Datapatch determines the requisite apply/rollback actions by matching an internal repository with the patch inventory.

So, it gets the patches from the $ORACLE_HOME/sqlpatch directory.
the results of the these sqlpatch things can be queried from dba_registry_sqlpatch.

For ex:
SELECT patch_id, version, status, bundle_id, bundle_series FROM dba_registry_sqlpatch;

so, as long as your patches will be in sqlpatch directory of the related Oracle Home, datapatch will apply their sqls to the database..