The upgrade of Grid Infrastructure (GI) Fails While Running 'chactl query model' In Step 8 'PreUpgrade' (Doc ID 2514854.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

18c GI rootupgrade.sh is failing in Step 8 'PreUpgrade'


2019/03/06 17:40:20 CLSRSC-595: Executing upgrade step 8 of 19: 'PreUpgrade'.
CLSCH-2005 : Oracle Cluster Health Analysis Service (OCHAD) failed due to a Grid Infrastructure Management Repository error.

Unable to start the Universal Connection Pool: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLRecoverableException: Listener refused the connection with the following error:

ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
 
From rootcrs log :

2019-03-06 17:40:31: Executing cmd: /u01/app/18.1.0.0/grid/bin/clsecho -p has -f clsrsc -m 180 '/u01/app/12.2.0.1/grid/bin/chactl query model'
2019-03-06 17:40:31: Executing cmd: /u01/app/18.1.0.0/grid/bin/clsecho -p has -f clsrsc -m 180 '/u01/app/12.2.0.1/grid/bin/chactl query model'
2019-03-06 17:40:31: Command output:
>  CLSRSC-180: An error occurred while executing the command '/u01/app/12.2.0.1/grid/bin/chactl query model'
>End Command output
2019-03-06 17:40:31: CLSRSC-180: An error occurred while executing the command '/u01/app/12.2.0.1/grid/bin/chactl query model'
2019-03-06 17:40:31: ###### Begin DIE Stack Trace ######
2019-03-06 17:40:31:     Package         File                 Line Calling  
2019-03-06 17:40:31:     --------------- -------------------- ---- ----------
2019-03-06 17:40:31:  1: main            rootcrs.pl            326 crsutils::dietrap
2019-03-06 17:40:31:  2: oraClusterwareComp::orachm orachm.pm            1070 main::__ANON__
2019-03-06 17:40:31:  3: crsupgrade      crsupgrade.pm        3714 oraClusterwareComp::orachm::exportCHAUserModels
2019-03-06 17:40:31:  4: crsupgrade      crsupgrade.pm         766 crsupgrade::perform_crs_pre_upgrade
2019-03-06 17:40:31:  5: crsupgrade      crsupgrade.pm         983 crsupgrade::preupgrade_actions
2019-03-06 17:40:31:  6: crsupgrade      crsupgrade.pm         572 crsupgrade::CRSUpgrade
2019-03-06 17:40:31:  7: main            rootcrs.pl            335 crsupgrade::new
2019-03-06 17:40:31: ####### End DIE Stack Trace #######

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.