Hello everybody.
Here is the error i have trying to apply patche (Patch 23273629 - Oracle Grid Infrastructure Patch Set Update 12.1.0.2.160719 (Jul2016)) to Database Home.
[root@test-node1 ~]# export ORACLE_HOME=/u01/app/12.1.0/grid_1
[root@test-node1 ~]# export PATH=$PATH:$ORACLE_HOME/OPatch
[root@test-node1 ~]# opatchauto apply /opt/patch/23273629 -oh /u01/app/oracle/product/12.1.0/dbhome_1 -ocmrf /u01/app/grid/grid-software/grid.test-node1.rsp
opatchauto must run from one of the homes specified
opatchauto returns with error code 2
In my case GI Home and the Database Homes that are not shared and ACFS file system is not configured.
That parte related to GI Home was already successfully installed. I've created my database after i had run opatchauto so Database Home was not patched!
I'm going to patch Database Home separately but have an error.
even when i try to run with another ORACLE_HOME
[root@test-node1 OPatch]# export ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1
[root@test-node1 OPatch]# export PATH=$PATH:$ORACLE_HOME/OPatch
[root@test-node1 OPatch]# opatchauto apply /opt/patch/23273629 -oh /u01/app/oracle/product/12.1.0/dbhome_1 -ocmrf /u01/app/grid/grid-software/grid.test-node1.rsp
opatchauto must run from one of the homes specified
opatchauto returns with error code 2
[root@test-node1 ~]#logout !!!!!
[root@test-node1 OPatch]# export PATH=$PATH:$ORACLE_HOME/OPatch
[root@test-node1 OPatch]# opatchauto apply /opt/patch/23273629 -oh /u01/app/oracle/product/12.1.0/dbhome_1 -ocmrf /u01/app/grid/grid-software/grid.test-node1.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/dbhome_1
opatchauto log file: /u01/app/12.1.0/grid_1/cfgtoollogs/opatchauto/23273629/opatch_gi_2016-07-27_10-39-57_deploy.log
Parameter Validation: Successful
Configuration Validation: Successful
Patch Location: /opt/patch/23273629
Grid Infrastructure Patch(es): 21436941 23054246 23054327 23054341
DB Patch(es): 23054246 23054327
Patch Validation: Successful
User specified the following DB home(s) for this session:
/u01/app/oracle/product/12.1.0/dbhome_1
Performing prepatch operations on RAC Home (/u01/app/oracle/product/12.1.0/dbhome_1) ... Successful
Following database(s) and/or service(s) were stopped and will be restarted later during the session: erp_test
Applying patch(es) to "/u01/app/oracle/product/12.1.0/dbhome_1" ...
Command "/u01/app/oracle/product/12.1.0/dbhome_1/OPatch/opatch napply -phBaseFile /tmp/OraDB12Home1_oracle_patchList -local -invPtrLoc /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc -oh /u01/app/oracle/product/12.1.0/dbhome_1 -silent -ocmrf /u01/app/grid/grid-software/grid.test-node1.rsp" execution failed:
OPatch failed to restore OH '/u01/app/oracle/product/12.1.0/dbhome_1'. Consult OPatch document to restore the home manually before proceeding.
UtilSession failed: Re-link fails on target "isqora".
Log file Location for the failed command: /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2016-07-27_10-40-59AM_1.log
For more details, please refer to the log file "/u01/app/12.1.0/grid_1/cfgtoollogs/opatchauto/23273629/opatch_gi_2016-07-27_10-39-57_deploy.debug.log".
Apply Summary:
Following patch(es) are successfully installed:
DB Home: /u01/app/oracle/product/12.1.0/dbhome_1:
Following patch(es) failed to be installed:
DB Home: /u01/app/oracle/product/12.1.0/dbhome_1: 23054246,23054327
Command failure exception
opatchauto failed with error code 2.
[oracle@test-node1 ~]$ echo $ORACLE_HOME
/u01/app/oracle/product/12.1.0/dbhome_1
[oracle@test-node1 ~]$ opatch lsinventory
Oracle Interim Patch Installer version 12.1.0.1.10
Copyright (c) 2016, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
OPatch version : 12.1.0.1.10
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2016-07-27_10-47-58AM_1.log
Lsinventory Output file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2016-07-27_10-47-58AM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: test-node1.intime.local
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Database 12c 12.1.0.2.0
There are 1 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
Rac system comprising of multiple nodes
Local node = test-node1
Remote node = test-node2
--------------------------------------------------------------------------------
OPatch succeeded.
Please advise