I got ” failed to detect Grid Infrastructure setup due to null ” error in the Oracle during Opatchauto apply.
failed to detect Grid Infrastructure setup due to null
Details of error are as follows.
[root@msdbadm08 patch]# /u01/app/oracle/product/19.0/dbhome_1/OPatch/opatchauto apply /zfssa/msdb/msdb_scripts_c07/patch/33509923 -oh /u01/app/oracle/product/19.0/dbhome_1 OPatchauto session is initiated at Thu Feb 3 21:59:32 2022 System initialization log file is /u01/app/oracle/product/19.0/dbhome_1/cfgtoollogs/opatchautodb/systemconfig2022-02-03_09-59-37PM.log. Remote command execution failed due to Exception in thread "main" oracle.dbsysmodel.driver.sdk.productdriver.ProductDriverException: failed to detect Grid Infrastructure setup due to null at oracle.dbsysmodel.driver.sdk.productdriver.ClusterInformationLoader.detectCrsHome(ClusterInformationLoader.java:328) at oracle.dbsysmodel.driver.sdk.productdriver.ClusterInformationLoader.loadInventory(ClusterInformationLoader.java:81) at oracle.dbsysmodel.driver.sdk.productdriver.ClusterInformationLoader.getInstance(ClusterInformationLoader.java:70) at oracle.dbsysmodel.driver.sdk.productdriver.remote.HomeListCollector.executeAction(HomeListCollector.java:31) at oracle.dbsysmodel.driver.sdk.productdriver.remote.RemoteOperationHelper.main(RemoteOperationHelper.java:26) Command output: 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 Thu Feb 3 22:00:03 2022 Time taken to complete the session 0 minute, 31 seconds Topology creation failed. [root@msdbadm08 patch]# [root@msdbadm08 patch]#
This error is related with the oraInventory permission and ownership. If you apply the GI patches , then change ownership of oraInventory as grid:oinstall, If you apply the RAC home patches, then change ownership of oraInventory as oracle:oinstall as follows.
$ chown -R oracle:oinstall /u01/app/oraInventory $ chmod -R 755 /u01/app/oraInventory
If your error is not solved by changing the permission and ownership of oraInventory, then use the Manual patch method instead of OPATCHAUTO as follows.
Run prepatch.sh , then apply the local patches, after that run the postpatch.sh as follows.
/u01/patch/33509923/33529556/custom/scripts/prepatch.sh -dbhome /u01/app/oracle/product/19.0/dbhome_1 /u01/app/oracle/product/19.0/dbhome_1/OPatch/opatch apply -oh /u01/app/oracle/product/19.0/dbhome_1 -local /u01/patch/33509923/33529556 /u01/app/oracle/product/19.0/dbhome_1/OPatch/opatch apply -oh /u01/app/oracle/product/19.0/dbhome_1 -local /u01/patch/33509923/33515361 /u01/patch/33509923/33529556/custom/scripts/postpatch.sh -dbhome /u01/app/oracle/product/19.0/dbhome_1
Do you want to learn Oracle Database for Beginners, then read the following articles.
Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )