19C GI修改名主机名后,无法正常启动GI ,CLSU-00107

发布时间:2021-08-18 00:00:00

19CGI修改名主机名后,无法正常启动GI ,CLSU-00107

[root@dbserver2 ~]# /u01/app/19.10.0/grid/bin/crsctl start has
CLSU-00107: operating system function: opendir; failed with error data: 2; at location: scrsearch1
CLSU-00101: operating system error message: No such file or directory
CLSU-00104: additional error information: cant open scr home dir scls_scr_getval
CRS-4000: Command Start failed, or completed with errors.

解决办法:

1)移除旧主机名相关的配置信息

cd /u01/app/19.10.0/grid/crs/install

[root@dbserver2 install]# perl roothas.sh -deconfig -force
Using configuration parameter file: /u01/app/19.10.0/grid/crs/install/crsconfig_params
The log of current session can be found at:
  /u01/app/grid/crsdata/dbserver2/crsconfig/hadeconfig.log
PRCR-1070 : Failed to check if resource ora.asm is registered
CRS-5168 : unable to communicate with ohasd
2021/02/24 18:30:09 CLSRSC-180: An error occurred while executing the command '/u01/app/19.10.0/grid/bin/srvctl remove asm -force'
PRCR-1070 : Failed to check if resource ora.ons is registered
CRS-5168 : unable to communicate with ohasd
2021/02/24 18:30:09 CLSRSC-180: An error occurred while executing the command '/u01/app/19.10.0/grid/bin/srvctl config ons'
CLSU-00107: operating system function: opendir; failed with error data: 2; at location: scrsearch1
CLSU-00101: operating system error message: No such file or directory
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.
Redirecting to /bin/systemctl restart rsyslog.service
2021/02/24 18:30:11 CLSRSC-337: Successfully deconfigured Oracle Restart stack

2)运行root脚本重新配置css服务
[root@dbserver2 install]# cd /u01/app/19.10.0/grid
[root@dbserver2 grid]# ./root.sh

Performing root user operation.

The following environment variables are set as:
    ORACLE_OWNER= grid
    ORACLE_HOME=  /u01/app/19.10.0/grid
   Copying dbhome to /usr/local/bin ...
   Copying oraenv to /usr/local/bin ...
   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.
Using configuration parameter file: /u01/app/19.10.0/grid/crs/install/crsconfig_params
The log of current session can be found at:
  /u01/app/grid/crsdata/dbserver2/crsconfig/roothas_2021-02-24_06-31-25PM.log
Redirecting to /bin/systemctl restart rsyslog.service
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 dbserver2 successfully pinned.
2021/02/24 18:31:33 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service'

dbserver2     2021/02/24 18:32:18     /u01/app/grid/crsdata/dbserver2/olr/backup_20210224_183218.olr     363229741     
2021/02/24 18:32:18 CLSRSC-327: Successfully configured Oracle Restart for a standalone server

[grid@dbserver2 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details      
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ons
               OFFLINE OFFLINE      dbserver2                STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
      1        ONLINE  ONLINE       dbserver2                STABLE
ora.diskmon
      1        OFFLINE OFFLINE                               STABLE
ora.evmd
      1        ONLINE  ONLINE       dbserver2                STABLE
--------------------------------------------------------------------------------

少了ASM,磁盘组,监听,数据库等

3)配置asm、database、listener等组件信息

[grid@sztest ~]$ srvctl add asm
[grid@sztest ~]$ srvctl start asm
[oracle@sztest ~]$ srvctl add database -db orcl -oraclehome /u01/app/oracle/product/12.1.0/dbhome_1 -diskgroup "DATA,FRA"

[grid@dbserver2 ~]$ srvctl add listener
[grid@dbserver2 ~]$ srvctl add asm

[grid@dbserver2 ~]$ cat /tmp/initasm.ora
asm_diskgroups='DATA','FRA'
instance_type='asm'
large_pool_size=12M
remote_login_passwordfile='EXCLUSIVE'

SQL> create spfile='+data' from pfile='/tmp/initasm.ora';

SQL> shutdown immediate
ASM diskgroups dismounted
ASM instance shutdown
SQL> startup


--增加数据库
srvctl add database -db orcl -oraclehome /u01/app/oracle/product/19.10.0/db_1 -diskgroup "data,fra" -spfile "+data/orcl/parameterfile/spfile.266.1065368977"



/u01/app/19.10.0/grid/bin/crsctl stop has
/u01/app/19.10.0/grid/bin/crsctl start has

[root@dbserver2 grid]# /u01/app/19.10.0/grid/bin/crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details      
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
               ONLINE  ONLINE       dbserver2                STABLE
ora.FRA.dg
               ONLINE  ONLINE       dbserver2                STABLE
ora.LISTENER.lsnr
               ONLINE  ONLINE       dbserver2                STABLE
ora.asm
               ONLINE  ONLINE       dbserver2                Started,STABLE
ora.ons
               OFFLINE OFFLINE      dbserver2                STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
      1        ONLINE  ONLINE       dbserver2                STABLE
ora.diskmon
      1        OFFLINE OFFLINE                               STABLE
ora.evmd
      1        ONLINE  ONLINE       dbserver2                STABLE
ora.orcl.db
      1        ONLINE  ONLINE       dbserver2                Open,HOME=/u01/app/o
                                                             racle/product/19.10.
                                                             0/db_1,STABLE
--------------------------------------------------------------------------------
[root@dbserver2 grid]#

从12.1.0.2开始,roothas.sh脚本替代了roothas.pl脚本。

重庆思庄oracle认证培训


<<