由于项目现场需求,需要修改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