DataPatch Query wit Cloned ORACLE_HOME

[Susmit]

Hi Erman,

We are upgrading our Oracle Database 11.2.0.4 to 12.1.0.2. The broad steps we followed in previous iteration are,

1. Install 12c S/W
2. Install Database Example CD
3. Apply Recommended OPatches(Not PSUs) which has some post patching steps to be executed later.
4. Do the Upgrade Task
5. Post Upgrade Run DataPatch to complete OPatch SQL steps pending from 3.
6. Finish Upgrade.


Now in the next iteration to cut down time we are planning to merge 1,2,3 in a Single Step that's is,

1. Clone the ORACLE_HOME from previous iteration to the new Server using ORACLE_HOME cloning method(this will include 12c S/W, Example CD and OPatch applied).
2. Do the Upgrade Task
3. Now, Post upgrade if we run DataPatch from this home, will it be able to identify all the pending post patching steps and apply them in this newly upgraded database???


Also, is this post of yours telling that it will be able to do it?
http://ermanarslan.blogspot.in/2016/08/exadata-cloning-oracle-home-and.html

[ErmanArslansOracleBlog]

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..

[Susmit]

Hi Erman,

Thanks. To my surprise, I don't even have to do this,

3. Now, Post upgrade if we run DataPatch from this home, will it be able to identify all the pending post patching steps and apply them in this newly upgraded database.

catctl.pl upgrade scripts does it automatically. I just confirmed from dba_registry_sqlpatch.

[ErmanArslansOracleBlog]

Good Susmit.
Update me with the outcome.