Examine this command executed on the first node of a four-node cluster:
$ <DATABASE_ORACLE_HOME>/0Patch/opatch apply 18031528
What does this command do?
A.
It applies a patch to one ORACLE_HOME only on the first cluster node.
B.
It applies a patch to all database ORACLE_HOMEs with the same release only on the first cluster node.
C.
It applies a patch to one ORACLE_HOME on all cluster nodes.
D.
It applies a patch to all database ORACLE_HOMEs with the same release on all cluster nodes.
E.
It applies a patch to all database ORACLE_HOMEs with the same release on the first cluster node.
Correct: D
I think A is correct. This is for opatch, not opatchauto.
A
i think D
https://www.pythian.com/blog/rdbms-online-patching/
I think C. To install the patch on one node you can use -local
Correct: A
It says the command is executed on the first node of the cluster.
Correct: A
I applied this patch
It will be D, take a look:
NODE1:/u01/PSU2016APR_GRID_OJVM/22674709>$ORACLE_HOME/OPatch/opatch apply
Oracle Interim Patch Installer version 12.1.0.1.10
…
This node is part of an Oracle Real Application Cluster.
Remote nodes: ‘NODE2’
Local node: ‘NODE1’
Please shut down Oracle instances running out of this ORACLE_HOME on all the nodes.
(Oracle Home = ‘/u01/app/oracle/product/12.1.0.2/dbhome_1’)
Are all the nodes ready for patching? [y|n]
y
User Responded with: Y
…
Patching in all-node mode.
…
Updating nodes ‘NODE2’
…
All nodes have been patched. You may start Oracle instances on the local system and nodes ‘NODE2’
Patch 22674709 successfully applied.
… and if you use option
-local
then OPatch will communicate
You selected -local option, hence OPatch will patch the local system only.
so definitely D.
in my opinion the right answer is C. The test conducted by you only shows that if you will not specify the mode (local , all_nodes) it’ll go for all nodes. But if you have 3 different OH installed on each of you cluster nodes (they can be same release) the command will not apply the patch to all 3 but to the one you have specified as your current one (ORACLE_HOME variable). That’s the whole idea of keeping few different homes on a server to be able to apply a patch only to one of them and not all.
I am sure that is A