When applying 12.2.0.1 GI RU( 12.2.0.1.180116 ), there are a couple of issues resolved by :
- Detach ORACLE_HOME which have no instances running against.
- Remove databases which are non required , but still in OCR.
- Use latest opatch for “wallet” issue.
Finally get another issue when running opatchauto:
# /u01/app/12.2.0.1/grid/OPatch/opatchauto apply
/PATCHES/12.2.0.1/27100009 -oh /u01/app/12.2.0.1/grid
OPatchauto session is initiated at Thu Jan 18 11:56:18 2018
System initialization log file is /u01/app/12.2.0.1/grid/cfgtoollogs/
opatchautodb/systemconfig2018-01-18_11-56-29AM.log.
Session log file is /u01/app/12.2.0.1/grid/cfgtoollogs/opatchauto/
opatchauto2018-01-18_11-57-03AM.log
The id for this session is AJ8A
oracle.dbsysmodel.driver.sdk.productdriver.ProductDriverException:
Execution failed for host rachost2 due to : com.oracle.cie.remote.RemoteConnectionException:
Command execution of [/u01/app/12.2.0.1/grid//perl/bin/perl
/u01/app/12.2.0.1/grid/OPatch/auto/database/bin/RemoteHostExecutor.pl
-GRID_HOME=/u01/app/12.2.0.1/grid -OBJECTLOC=/u01/app/12.2.0.1/grid/
/cfgtoollogs/opatchautodb/hostdata.obj -CRS_ACTION=check
-CLUSTERNODES=rachost1,rachost2 -JVM_HANDLER=oracle/dbsysmodel/driver
/sdk/productdriver/remote/RemoteDataCollector ] failed due to exit status 2.
OPatchAuto failed.
OPatchauto session completed at Thu Jan 18 11:57:11 2018
Time taken to complete the session 0 minute, 54 seconds
opatchauto failed with error code 42
The below command caused errors :
/u01/app/12.2.0.1/grid//perl/bin/perl /u01/app/12.2.0.1/grid/OPatch/auto/database/bin/RemoteHostExecutor.pl -GRID_HOME=/u01/app/12.2.0.1/grid -OBJECTLOC=/u01/app/12.2.0.1/grid/ /cfgtoollogs/opatchautodb/hostdata.obj -CRS_ACTION=check -CLUSTERNODES=rachost1,rachost2 -JVM_HANDLER=oracle/dbsysmodel/driver /sdk/productdriver/remote/RemoteDataCollector
Found “/u01/app/12.2.0.1/grid/OPatch/auto/database/bin/RemoteHostExecutor.pl” file does not exist on racnode2, because the OPatch on this node is still old version 12.2.0.1.6. But on racnode1 OPatch version is latest 12.2.0.1.11.
Copy the latest OPatch from node1 onto node2, then run the opatchauto successfully.
ALWAYS get latest OPATCH on all RAC nodes first before applying patches.