I got ” OPATCHAUTO-72050: System instance creation failed | Failed while retrieving system information. ” error in the Oracle database.
OPATCHAUTO-72050: System instance creation failed | Failed while retrieving system information.
Details of error are as follows.
[root@msdbadm01 patch]# opatchauto apply 32545008/ OPatchauto session is initiated at Tue Sep 14 22:09:59 2021 - System initialization log file is /u01/app/19.0.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2021-09-14_10-17-09PM.log. OPATCHAUTO-72050: System instance creation failed. OPATCHAUTO-72050: Failed while retrieving system information. OPATCHAUTO-72050: Please check log file for more details. OPatchauto session completed at Tue Sep 14 22:17:49 2021 Time taken to complete the session 7 minutes, 50 seconds Topology creation failed. [root@msdbadm01 patch]#
The ownership of oraInst.loc inside <grid home> was different on both Nodes-
[oracrs@msdbadm01 ~]$ ll $GRID_HOME/oraInst.loc -rw-r----- 1 root root 55 Jul 7 2016 $GRID_HOME/oraInst.loc [oracrs@msdbadm02 ~]$ ll $GRID_HOME/oraInst.loc -rw-r----- 1 oracle oinstall 127 Jun 21 2016 $GRID_HOME/oraInst.loc
opatchauto looks up the ownership of <GRID HOME>/oraInst.loc to determine the owner of <GRID_HOME>, in order to run cluvfy.
Since, oraInst.loc was owned by root, it assumed the owner of <GRID_HOME> to be root and the mentioned message was displayed
Ensure the ownership of <GRID HOME>/oraInst.loc is proper across each Node.
If incorrect, then change the Ownership to Grid User & re-run opatchauto.
OR Change file permission of Patch location as follows.
chmod -R 775 <unzipped patch location> chmod -R 775 /u01/patch/32545008
Do you want to learn Oracle Database for Beginners, then read the following articles.
Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )
In my case
i have to set following temp variables
export TMP=/grid/stage/temp
export TMPDIR=/grid/stage/temp
export TEMP=/grid/stage/temp