Topic : Cloning and Migration

When you moved oracle binary files from one ORACLE_HOME server to another server then which oracle utility will be used to make this new ORACLE_HOME usable?


Answer :

Relink all.

Show Answer Discuss

In which months oracle release CPU patches?


Answer :

JAN; APR; JUL; OCT.

Show Answer Discuss

When we applying single Patch; can you use opatch utility?


Answer :

Yes; you can use Opatch incase of single patch. The only type of patch that cannot be used with OPatch is a patchset.

Show Answer Discuss

Is it possible to apply OPATCH without downtime?


Answer :

As you know for apply patch your database and listener must be down. When you apply OPTACH it will update your current ORACLE_HOME. Thus coming to your question to the point in fact it is not possible without or zero downtime in case of single instance but in RAC you can Apply Opatch without downtime as there will be more separate ORACLE_HOME and more separate instances (running once instance on each ORACLE_HOME).

Show Answer Discuss

You have collection of patch (nearly 100 patches) or patchset. How can you apply only one patch from it?


Answer :

With Napply itself (by providing patch location and specific patch id) you can apply only one patch from a collection of extracted patch. For more information check the opatch util NApply ?help. It will give you clear picture.
For Example:
opatch util napply -id 9 -skip_subset -skip_duplicate
This will apply only the patch id 9 from the patch location and will skip duplicate and subset of patch installed in your ORACLE_HOME.

Show Answer Discuss