grid修改主机名

由于项目现场需求，需要修改cDASHA两台机器的主机名（由drdb1、drdb2修改为msc1db1和msc1db2），导致has（high available service）启动失败，修复步骤如下：

1、确保grid进程在

root@msc1db2[/grid/product/19c/crs/install]# ps -ef|grep grid

grid      9922     1 13 06:52 ?        00:00:02 /grid/product/19c/bin/ohasd.bin reboot

grid     10140     1  1 06:52 ?        00:00:00 /grid/product/19c/bin/oraagent.bin

grid     10163     1  0 06:52 ?        00:00:00 /grid/product/19c/bin/evmd.bin

grid     10341 10163  0 06:52 ?        00:00:00 /grid/product/19c/bin/evmlogger.bin -o /grid/product/19c/log/[HOSTNAME]/evmd/evmlogger.info -l /grid/product/19c/log/[HOSTNAME]/evmd/evmlogger.log

2、deconfig grid的配置（root用户执行）

cd /grid/product/19c/crs/install

./roothas.sh -deconfig -force

root@msc1db2[/grid/product/19c/crs/install]# ./roothas.sh -deconfig -force

Using configuration parameter file: /grid/product/19c/crs/install/crsconfig_params

The log of current session can be found at:

 /grid/grid/crsdata/msc1db2/crsconfig/hadeconfig.log

****Unable to retrieve Oracle Clusterware home.

Start Oracle Clusterware stack and try again.

2021/02/07 06:49:34 CLSRSC-180: An error occurred while executing the command '/grid/product/19c/bin/srvctl remove asm -force'

****Unable to retrieve Oracle Clusterware home.

Start Oracle Clusterware stack and try again.

2021/02/07 06:49:34 CLSRSC-180: An error occurred while executing the command '/grid/product/19c/bin/srvctl config ons'

CRS-4047: No Oracle Clusterware components configured.

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

CRS-4047: No Oracle Clusterware components configured.

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

2021/02/07 06:49:34 CLSRSC-348: The Oracle Restart stack failed to stop

Died at /grid/product/19c/crs/install/crsdeconfig.pm line 1331.

The command '/grid/product/19c/perl/bin/perl -I/grid/product/19c/perl/lib -I/grid/product/19c/crs/install -I/grid/product/19c/xag /grid/product/19c/crs/install/roothas.pl -deconfig -force' execution failed

3、reconfig grid配置（root用户执行）

./roothas.sh

Using configuration parameter file: /grid/product/19c/crs/install/crsconfig_params

The log of current session can be found at:

 /grid/grid/crsdata/msc1db2/crsconfig/roothas_2021-02-07_06-50-30AM.log

2021/02/07 06:50:31 CLSRSC-363: User ignored prerequisites during installation

LOCAL ADD MODE  

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

Operation successful.

LOCAL ONLY MODE  

Successfully accumulated necessary OCR keys.

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

Operation successful.

CRS-4664: Node msc1db2 successfully pinned.

2021/02/07 06:50:37 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service'

msc1db2     2021/02/07 06:52:11     /grid/grid/crsdata/msc1db2/olr/backup_20210207_065211.olr     724960844      

2021/02/07 06:52:11 CLSRSC-327: Successfully configured Oracle Restart for a standalone server

4、配置asm的pfile

su - grid

cd $ORACLE_HOME/dbs

vi init+ASM.ora

+ASM.__large_pool_size=20971520

+ASM.__oracle_base='/grid/grid'#ORACLE_BASE set from in memory value

*.asm_diskgroups='CDASHA02'

*.asm_diskstring='/dev/mapper/asm*'

*.asm_power_limit=1

*.large_pool_size=12M

*.memory_max_target=5368709120

*.memory_target=5368709120

*.remote_login_passwordfile='EXCLUSIVE'

*.sga_max_size=5368709120

5、添加asm

srvctl add asm

srvctl start asm（会自动使用dbs下的init+ASM.ora）

6、重新生成spfile

srvctl start diskgroup -diskgroup CDASHA02

sqlplus / as sysasm

create spfile='+CDASHA02' from pfile;

7、重新配置asm

srvctl add listener -o '/oracle/product/19c'

srvctl modify asm -p '+CDASHA02/ASM/ASMPARAMETERFILE/REGISTRY.253.1063705531' -pwfile '+CDASHA02/ASM/PASSWORD/pwdasm.256.1063705533' -l listener

8、检查asm

[grid@msc1db2 dbs]$ srvctl config asm

ASM home: <CRS home>

Password file: +CDASHA02/ASM/PASSWORD/pwdasm.256.1063705533

Backup of Password file:  

ASM listener:  

Spfile: +CDASHA02/ASM/ASMPARAMETERFILE/REGISTRY.253.1063705531

ASM diskgroup discovery string: /dev/mapper/asm

[grid@msc1db2 dbs]$ asmcmd lsdg

State    Type    Rebal  Sector  Logical_Sector  Block       AU  Total_MB   Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name

MOUNTED  NORMAL  N         512             512   4096  4194304   3145728   3144712          1048576         1048068              0             N  CCARCH/

MOUNTED  NORMAL  N         512             512   4096  4194304  32715648  30683488         10905216         9889136              0             N  CCDATA01/

MOUNTED  NORMAL  N         512             512   4096  4194304   1843200   1383660           614400          384630              0             N  CCSYS/

MOUNTED  EXTERN  N         512             512   4096  4194304     10240     10140                0           10140              0             N  CDASHA02/

MOUNTED  NORMAL  N         512             512   4096  4194304   3686400   3686064          1228800         1228632              0             N  RBARCH/

MOUNTED  NORMAL  N         512             512   4096  4194304  25165824  23051752          8388608         7331572              0             N  RBDATA01/

MOUNTED  NORMAL  N         512             512   4096  4194304  25165824  25165356          8388608         8388374              0             N  RBDATA02/

MOUNTED  NORMAL  N         512             512   4096  4194304  25165824  25165356          8388608         8388374              0             N  RBDATA03/

MOUNTED  NORMAL  N         512             512   4096  4194304   1843200   1445048           614400          415324              0             N  RBSYS/

9、手动加数据库信息

 srvctl add database -d ccdb -o '/oracle/product/19c' -spfile '+CCDATA01/CCDB/PARAMETERFILE/spfile.265.1063707795' -instance ccdb -pwfile '+CCSYS/CCDB/orapwccdb'

srvctl add database -d rbdb -o '/oracle/product/19c' -spfile '+RBDATA01/RBDB/PARAMETERFILE/spfile.265.1063712103' -instance rbdb -pwfile '+RBSYS/RBDB/orapwrbdb'

10、检查has状态

crsctl stat res -t