Examine this command executed on the first node of a four-node cluster: $ < DATABASE_ORACLE_HOME >/OPatch/opatch apply 33575673 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 one database ORACLE_HOME on alll cluster nodes.
C.
It applies a patch to all database ORACLE_HOMEs with the same release only on the first cluster node.
D.
It applies a patch to all ORACLE_HOMEs with the same release only on the first cluster node.
E.
It applies a patch to all database ORACLE_HOMEs with the same release on all cluster nodes.
A. It applies a patch to one ORACLE_HOME only on the first cluster node. -oh
The oracle home to work on. This takes precedence over
the environment variable ORACLE_HOME
B as explain in this oracle note: Doc ID 244241.1
"The algorithm used to decide which method is going to be used is the following:
If (users specify minimize_downtime)
patching mechanism = Min. Downtime
else if (patch is a rolling patch)
patching mechanism = Rolling
else
patching mechanism = All-Node "
we need to consider the typical behavior of OPatch in a clustered environment:
Cluster-aware Execution (RAC Mode): The patch can be applied to all nodes in the cluster if executed with the appropriate cluster-aware options or configurations
A is incorrect because it does not mention whether the execution is in a cluster-aware mode or not, and typically, in the default mode, OPatch will apply the patch only to the local node, but it will be for the specified ORACLE_HOME.
B is the correct answer, as it states that the patch is applied to one database ORACLE_HOME on all cluster nodes, which aligns with the behavior of OPatch when it is cluster-aware.
E could also be correct depending on the OPatch configuration and usage of the -all_nodes flag, but typically opatch apply without additional parameters doesn't cover all ORACLE_HOMEs across all nodes by default.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
jackhsu0704
3 months, 1 week agojackhsu0704
3 months, 1 week ago217972f
4 months, 4 weeks agoTest_1
5 months, 2 weeks agolcoleandro
5 months, 3 weeks agoTest_1
5 months, 2 weeks ago