Problem Description:

In the grid environment, if the host name is modified, the following error will appear when starting the grid:

[[email protected] ~]$ sqlplus / as sysasm



SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 15 20:42:27 2020



Copyright (c) 1982, 2014, Oracle. All rights reserved.



Connected to an idle instance.



SQL> startup

ORA-01078: failure in processing system parameters

ORA-29701: unable to connect to Cluster Synchronization Service

Check the CSS service:

[[email protected] ~]$ crsctl check css

CRS-4639: Could not contact Oracle High Availability Services

CRS-4000: Command Check failed, or completed with errors.

Start the has service:

[[email protected] ~]$ crsctl start has

CLSU-00105: operating system interface has reported an internal failure

CLSU-00103: error location: scrcreate5

CLSU-00104: additional error information: need ha priv

CRS-4000: Command Start failed, or completed with errors.

Solution:

1) Remove configuration information related to old host name

[[email protected] ~]# cd /u01/app/grid/product/12.1.0/grid/crs/install/

[[email protected] install]# perl roothas.sh -deconfig -force

Using configuration parameter file: /u01/app/grid/product/12.1.0/grid/crs/install/crsconfig_params

CRS-4639: Could not contact Oracle High Availability Services

CRS-4000: Command Stop failed, or completed with errors.

CRS-4639: Could not contact Oracle High Availability Services

CRS-4000: Command Delete failed, or completed with errors.

CLSU-00100: operating system function: opendir failed with error data: 2

CLSU-00101: operating system error message: No such file or directory

CLSU-00103: error location: scrsearch1

CLSU-00104: additional error information: cant open scr home dir scls_scr_getval

CRS-4639: Could not contact Oracle High Availability Services

CRS-4000: Command Stop failed, or completed with errors.

2020/04/15 20:46:44 CLSRSC-337: Successfully deconfigured Oracle Restart stack

2) Run the root script to reconfigure the CSS service

[[email protected] install]# cd /u01/app/grid/product/12.1.0/grid/

[[email protected] grid]# ./root.sh

Performing root user operation.



The following environment variables are set as:

ORACLE_OWNER= grid

ORACLE_HOME= /u01/app/grid/product/12.1.0/grid



Enter the full pathname of the local bin directory: [/usr/local/bin]:

The contents of "dbhome" have not changed. No need to overwrite.

The contents of "oraenv" have not changed. No need to overwrite.

The contents of "coraenv" have not changed. No need to overwrite.



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.

Using configuration parameter file: /u01/app/grid/product/12.1.0/grid/crs/install/crsconfig_params

LOCAL ADD MODE

Creating OCR keys for user 'grid', privgrp 'oinstall'..

Operation successful.

LOCAL ONLY MODE

Successfully accumulated necessary OCR keys.

Creating OCR keys for user 'root', privgrp 'root'..

Operation successful.

CRS-4664: Node sztest successfully pinned.

2020/04/15 20:48:49 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.conf'





sztest 2020/04/15 20:49:20 /u01/app/grid/product/12.1.0/grid/cdata/sztest/backup_20200415_204920.olr 0

CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'sztest'

CRS-2673: Attempting to stop 'ora.evmd' on 'sztest'

CRS-2677: Stop of 'ora.evmd' on 'sztest' succeeded

CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'sztest' has completed

CRS-4133: Oracle High Availability Services has been stopped.

CRS-4123: Oracle High Availability Services has been started.

2020/04/15 20:49:37 CLSRSC-327: Successfully configured Oracle Restart for a standalone server

3) Configure ASM, database, listener and other component information

[[email protected] ~]$ srvctl add asm

[[email protected] ~]$ srvctl start asm



[[email protected] ~]$ srvctl add database -db orcl -oraclehome /u01/app/oracle/product/12.1.0/dbhome_1 -diskgroup "DATA,FRA"

From 12.1.0.2, roothas.sh Script replaced roothas.pl script.