Thursday, August 9, 2018

rootupgrade.sh failed 18c

 sh rootupgrade.sh
Performing root user operation.

The following environment variables are set as:
    ORACLE_OWNER= grid
    ORACLE_HOME=  /u01/app/18.0.0

Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The file "oraenv" already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]: y
   Copying oraenv to /usr/local/bin ...
The file "coraenv" already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]: y
   Copying coraenv to /usr/local/bin ...

Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
y
Relinking oracle with rac_on option
Using configuration parameter file: /u01/app/18.0.0/crs/install/crsconfig_params
The log of current session can be found at:
  /u01/app/grid/crsdata/vm33/crsconfig/rootcrs_vm33_2018-08-08_05-26-12PM.log
2018/08/08 17:27:55 CLSRSC-595: Executing upgrade step 1 of 19: 'UpgradeTFA'.
2018/08/08 17:27:55 CLSRSC-4015: Performing install or upgrade action for Oracle Trace File Analyzer (TFA) Collector.
2018/08/08 17:29:04 CLSRSC-4003: Successfully patched Oracle Trace File Analyzer (TFA) Collector.
2018/08/08 17:29:04 CLSRSC-595: Executing upgrade step 2 of 19: 'ValidateEnv'.
2018/08/08 17:29:20 CLSRSC-595: Executing upgrade step 3 of 19: 'GetOldConfig'.
2018/08/08 17:29:20 CLSRSC-464: Starting retrieval of the cluster configuration data
2018/08/08 17:29:33 CLSRSC-692: Checking whether CRS entities are ready for upgrade. This operation may take a few minutes.
2018/08/08 17:32:53 CLSRSC-693: CRS entities validation completed successfully.
2018/08/08 17:33:02 CLSRSC-515: Starting OCR manual backup.
2018/08/08 17:33:22 CLSRSC-516: OCR manual backup successful.
2018/08/08 17:33:34 CLSRSC-486:
 At this stage of upgrade, the OCR has changed.
 Any attempt to downgrade the cluster after this point will require a complete cluster outage to restore the OCR.
2018/08/08 17:33:34 CLSRSC-541:
 To downgrade the cluster:
 1. All nodes that have been upgraded must be downgraded.
2018/08/08 17:33:34 CLSRSC-542:
 2. Before downgrading the last node, the Grid Infrastructure stack on all other cluster nodes must be down.
2018/08/08 17:33:34 CLSRSC-615:
 3. The last node to downgrade cannot be a Leaf node.
2018/08/08 17:33:49 CLSRSC-465: Retrieval of the cluster configuration data has successfully completed.
2018/08/08 17:33:49 CLSRSC-595: Executing upgrade step 4 of 19: 'GenSiteGUIDs'.
2018/08/08 17:33:53 CLSRSC-595: Executing upgrade step 5 of 19: 'UpgPrechecks'.
2018/08/08 17:34:00 CLSRSC-363: User ignored prerequisites during installation
2018/08/08 17:34:19 CLSRSC-595: Executing upgrade step 6 of 19: 'SaveParamFile'.
2018/08/08 17:34:36 CLSRSC-595: Executing upgrade step 7 of 19: 'SetupOSD'.
2018/08/08 17:34:36 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



2018/08/08 17:34:44 CLSRSC-180: An error occurred while executing the command '/u01/app/12.2.0/grid/bin/chactl query model'
Died at /u01/app/18.0.0/crs/install/orachm.pm line 1036.


Soltuon:
=========

srvctl stop cha
srvctl remove cha

re-run rootupgrade.sh