Hello All,
I am having an issue applying patch number 23615308 on one of my 3 RAC node clusters. I have successfully applied both the GI home and Oracle home on node one. I can also apply the GI home patch on nodes 2 and 3, but I am unable to apply the patch on the Oracle home. I am doing step 2.3 opatchauto for GI.
Opatch Version
[root@xdatadb2 OPatch]# opatch version
OPatch Version: 12.1.0.1.10
OPatch succeeded.
Banner
--------------------------------------------------------------------------------
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
PL/SQL Release 12.1.0.2.0 - Production
CORE 12.1.0.2.0 Production
TNS for Linux: Version 12.1.0.2.0 - Production
NLSRTL Version 12.1.0.2.0 - Production
Oracle home patching attempt
[root@xdatadb2 ~]# cd /u01/app/oracle/product/12.1.0.2/db_1/OPatch/
[root@xdatadb2 OPatch]# ./opatchauto apply /u01/oracleinstall/23615308 -oh /u01/app/oracle/product/12.1.0.2/db_1 -ocmrf /tmp/ocm.rsp
OPatch Automation Tool
Copyright (c)2014, Oracle Corporation. All rights reserved.
OPatchauto Version : 12.1.0.1.10
OUI Version : 12.1.0.2.0
Running from : /u01/app/oracle/product/12.1.0.2/db_1
opatchauto log file: /u01/app/grid/12.1.0.2/cfgtoollogs/opatchauto/23615308/opatch_gi_2016-11-16_07-09-01_deploy.log
Parameter Validation: Successful
Failed:
Verifying shared storage accessibility <------
WARNING:
User equivalence is not set for nodes:
xdatadb1
Verification will proceed with nodes:
xdatadb3,xdatadb2
Checking shared storage accessibility...
"/u01/app/oracle/product/12.1.0.2/db_1" is not shared
Shared storage check failed on nodes "xdatadb2,xdatadb3" <------
Verification of shared storage accessibility was unsuccessful on all the specified nodes.
NODE_STATUS::xdatadb3:VFAIL
NODE_STATUS::xdatadb2:VFAIL
NODE_STATUS::xdatadb1:EFAIL
The result of cluvfy command contain EFAIL NODE_STATUS::xdatadb1:EFAIL
System Configuration Collection failed: oracle.osysmodel.driver.sdk.productdriver.ProductDriverException: Unable to determine if "/u01/app/oracle/product/12.1.0.2/db_1" is a shared oracle home.
Failed:
Verifying shared storage accessibility
WARNING:
User equivalence is not set for nodes:
xdatadb1
Verification will proceed with nodes:
xdatadb3,xdatadb2
Checking shared storage accessibility...
"/u01/app/oracle/product/12.1.0.2/db_1" is not shared
Shared storage check failed on nodes "xdatadb2,xdatadb3" <------
Verification of shared storage accessibility was unsuccessful on all the specified nodes.
NODE_STATUS::xdatadb3:VFAIL
NODE_STATUS::xdatadb2:VFAIL
NODE_STATUS::xdatadb1:EFAIL
The result of cluvfy command contain EFAIL NODE_STATUS::xdatadb1:EFAIL
Exception in thread "main" java.lang.RuntimeException: java.io.IOException: Stream closed
at oracle.opatchauto.gi.GILogger.writeWithoutTimeStamp(GILogger.java:432)
at oracle.opatchauto.gi.GILogger.printStackTrace(GILogger.java:447)
at oracle.opatchauto.gi.OPatchauto.main(OPatchauto.java:97)
Caused by: java.io.IOException: Stream closed
at java.io.BufferedWriter.ensureOpen(BufferedWriter.java:98)
at java.io.BufferedWriter.write(BufferedWriter.java:203)
at java.io.Writer.write(Writer.java:140)
at oracle.opatchauto.gi.GILogger.writeWithoutTimeStamp(GILogger.java:426)
... 2 more
opatchauto failed with error code 1.
-------------------------------------------------------------------------------------------------------
Known hosts
So, I thought this could be an issue with perhaps the rsa keys or the known hosts so I checked it on all nodes by connecting to all nodes (ssh) in the cluster and I never got the message "The authenticity of host 'xdatadb2 (10.10.172.63)' can't be established."
[grid@xdatadb2 ~]$ cd ~/.ssh
[grid@xdatadb2 .ssh]$ cat known_hosts | wc -l
12
[ORACLE/-xdatadb_1]/home/oracle> srvctl status database -d clrt
Instance clrt_1 is running on node xdatadb1
Instance clrt_2 is running on node xdatadb2
Instance clrt_3 is running on node xdatadb3
CLRT_1> select host_name, status from gv$instance;
HOST_NAME STATUS
---------------------------------------------------------------- ------------
xdatadb1.web.com OPEN
xdatadb3.web.com OPEN
xdatadb2.web.com OPEN
I was able to apply the January patches earlier this year, but I am not sure why I am having this issue with this patch. Any help on this would be appreciated.
Thanks!