Oracle RAC 12c R2再インストール時の対応

Oracle RAC 12c R2の構築中にファーストノードでインストールが失敗。
中途半端に処理が進んでいたため再インストールで対応した際の対応を書いていきます。
アンインストールももちろん、正常には終了しないので、その対応も書いていきます。
バージョンは最新のOracle 12c R2。

インストール時にroot.shの実行で失敗

root.shでクラスタリソースの停止に失敗している。

~
CRS-2799: Failed to shut down resource 'ora.asm' on 'node01'
CRS-2799: Failed to shut down resource 'ora.cluster_interconnect.haip' on 'node01'
CRS-2799: Failed to shut down resource 'ora.cssd' on 'node01'
CRS-2799: Failed to shut down resource 'ora.cssdmonitor' on 'node01'
CRS-2799: Failed to shut down resource 'ora.driver.afd' on 'node01'
CRS-2799: Failed to shut down resource 'ora.gipcd' on 'node01'
CRS-2795: Shutdown of Oracle High Availability Services-managed resources on 'node01' has failed
CRS-4687: Shutdown command has completed with errors.
CRS-4000: Command Stop failed, or completed with errors.
2017/09/28 16:37:36 CLSRSC-349: The Oracle Clusterware stack failed to stop
Died at /u01/app/12.2.0/grid/crs/install/crsinstall.pm line 649.
The command '/u01/app/12.2.0/grid/perl/bin/perl -I/u01/app/12.2.0/grid/perl/lib -I/u01/app/12.2.0/grid/crs/install /u01/app/12.2.0/grid/crs/install/rootcrs.pl -auto -lang=C' execution failed

deinstallを実行

実行後のスクリプト実行画面でも失敗するため、以下のディレクトリを削除

[root@node01 diag]# rm -rf /u01/app/grid/*
[root@node01 diag]# rm -rf /var/tmp/.oracle/*

gridSetup.shから再度root.shを実行

原因は不明ですが、再インストールは成功。おそらく、12cR2からメモリ要件が8Gになっているため、メモリ不足だった可能性があり。(4Gで構築中でした)

[root@node01 diag]# /u01/app/12.2.0/grid/root.sh
Performing root user operation.

The following environment variables are set as:
ORACLE_OWNER= grid
ORACLE_HOME= /u01/app/12.2.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.
Relinking oracle with rac_on option
Using configuration parameter file: /u01/app/12.2.0/grid/crs/install/crsconfig_params
The log of current session can be found at:
/u01/app/grid/crsdata/node01/crsconfig/rootcrs_node01_2017-09-29_10-57-30AM.log
2017/09/29 10:57:38 CLSRSC-594: Executing installation step 1 of 19: 'SetupTFA'.
2017/09/29 10:57:38 CLSRSC-4001: Installing Oracle Trace File Analyzer (TFA) Collector.
2017/09/29 10:57:41 CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector.
2017/09/29 10:57:41 CLSRSC-594: Executing installation step 2 of 19: 'ValidateEnv'.
2017/09/29 10:57:47 CLSRSC-363: User ignored prerequisites during installation
2017/09/29 10:57:47 CLSRSC-594: Executing installation step 3 of 19: 'CheckFirstNode'.
2017/09/29 10:57:49 CLSRSC-594: Executing installation step 4 of 19: 'GenSiteGUIDs'.
2017/09/29 10:57:50 CLSRSC-594: Executing installation step 5 of 19: 'SaveParamFile'.
2017/09/29 10:57:58 CLSRSC-594: Executing installation step 6 of 19: 'SetupOSD'.
2017/09/29 10:57:59 CLSRSC-594: Executing installation step 7 of 19: 'CheckCRSConfig'.
2017/09/29 10:57:59 CLSRSC-594: Executing installation step 8 of 19: 'SetupLocalGPNP'.
2017/09/29 10:58:29 CLSRSC-594: Executing installation step 9 of 19: 'ConfigOLR'.
2017/09/29 10:58:38 CLSRSC-594: Executing installation step 10 of 19: 'ConfigCHMOS'.
2017/09/29 10:58:38 CLSRSC-594: Executing installation step 11 of 19: 'CreateOHASD'.
2017/09/29 10:58:43 CLSRSC-594: Executing installation step 12 of 19: 'ConfigOHASD'.
2017/09/29 10:58:58 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service'
2017/09/29 10:59:19 CLSRSC-594: Executing installation step 13 of 19: 'InstallAFD'.
2017/09/29 10:59:23 CLSRSC-594: Executing installation step 14 of 19: 'InstallACFS'.
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'node01'
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'node01' has completed
CRS-4133: Oracle High Availability Services has been stopped.
CRS-4123: Oracle High Availability Services has been started.
2017/09/29 10:59:43 CLSRSC-594: Executing installation step 15 of 19: 'InstallKA'.
2017/09/29 10:59:48 CLSRSC-594: Executing installation step 16 of 19: 'InitConfig'.
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'node01'
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'node01' has completed
CRS-4133: Oracle High Availability Services has been stopped.
CRS-4123: Oracle High Availability Services has been started.
CRS-2672: Attempting to start 'ora.evmd' on 'node01'
CRS-2672: Attempting to start 'ora.mdnsd' on 'node01'
CRS-2676: Start of 'ora.evmd' on 'node01' succeeded
CRS-2676: Start of 'ora.mdnsd' on 'node01' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'node01'
CRS-2676: Start of 'ora.gpnpd' on 'node01' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'node01'
CRS-2672: Attempting to start 'ora.gipcd' on 'node01'
CRS-2676: Start of 'ora.cssdmonitor' on 'node01' succeeded
CRS-2676: Start of 'ora.gipcd' on 'node01' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'node01'
CRS-2672: Attempting to start 'ora.diskmon' on 'node01'
CRS-2676: Start of 'ora.diskmon' on 'node01' succeeded
CRS-2676: Start of 'ora.cssd' on 'node01' succeeded

ディスク・グループは正常に作成されました。詳細は、/u01/app/grid/cfgtoollogs/asmca/asmca-170929午前110026.logを参照してください。



2017/09/29 11:01:29 CLSRSC-482: Running command: '/u01/app/12.2.0/grid/bin/ocrconfig -upgrade grid oinstall'
CRS-2672: Attempting to start 'ora.crf' on 'node01'
CRS-2672: Attempting to start 'ora.storage' on 'node01'
CRS-2676: Start of 'ora.storage' on 'node01' succeeded
CRS-2676: Start of 'ora.crf' on 'node01' succeeded
CRS-2672: Attempting to start 'ora.crsd' on 'node01'
CRS-2676: Start of 'ora.crsd' on 'node01' succeeded
CRS-4256: Updating the profile
Successful addition of voting disk c1b6073bb1334f62bf280d86c0e829f4.
Successful addition of voting disk 964e4702f6c04faabf785db7bb2530e4.
Successful addition of voting disk 7006b4560a484ffebf2763a50f79fd46.
Successfully replaced voting disk group with +DATA.
CRS-4256: Updating the profile
CRS-4266: Voting file(s) successfully replaced
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE c1b6073bb1334f62bf280d86c0e829f4 (/dev/sdd1) [DATA]
2. ONLINE 964e4702f6c04faabf785db7bb2530e4 (/dev/sdb1) [DATA]
3. ONLINE 7006b4560a484ffebf2763a50f79fd46 (/dev/sdc1) [DATA]
Located 3 voting disk(s).
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'node01'
CRS-2673: Attempting to stop 'ora.crsd' on 'node01'
CRS-2677: Stop of 'ora.crsd' on 'node01' succeeded
CRS-2673: Attempting to stop 'ora.storage' on 'node01'
CRS-2673: Attempting to stop 'ora.crf' on 'node01'
CRS-2673: Attempting to stop 'ora.gpnpd' on 'node01'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'node01'
CRS-2677: Stop of 'ora.crf' on 'node01' succeeded
CRS-2677: Stop of 'ora.gpnpd' on 'node01' succeeded
CRS-2677: Stop of 'ora.storage' on 'node01' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'node01'
CRS-2677: Stop of 'ora.mdnsd' on 'node01' succeeded
CRS-2677: Stop of 'ora.asm' on 'node01' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'node01'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'node01' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'node01'
CRS-2673: Attempting to stop 'ora.evmd' on 'node01'
CRS-2677: Stop of 'ora.evmd' on 'node01' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'node01' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'node01'
CRS-2677: Stop of 'ora.cssd' on 'node01' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'node01'
CRS-2677: Stop of 'ora.gipcd' on 'node01' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'node01' has completed
CRS-4133: Oracle High Availability Services has been stopped.
2017/09/29 11:03:08 CLSRSC-594: Executing installation step 17 of 19: 'StartCluster'.
ACRS-4123: Starting Oracle High Availability Services-managed resources
CRS-2672: Attempting to start 'ora.mdnsd' on 'node01'
CRS-2672: Attempting to start 'ora.evmd' on 'node01'
CRS-2676: Start of 'ora.mdnsd' on 'node01' succeeded
CRS-2676: Start of 'ora.evmd' on 'node01' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'node01'
CRS-2676: Start of 'ora.gpnpd' on 'node01' succeeded
CRS-2672: Attempting to start 'ora.gipcd' on 'node01'
CRS-2676: Start of 'ora.gipcd' on 'node01' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'node01'
CRS-2676: Start of 'ora.cssdmonitor' on 'node01' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'node01'
CRS-2672: Attempting to start 'ora.diskmon' on 'node01'
CRS-2676: Start of 'ora.diskmon' on 'node01' succeeded
CRS-2676: Start of 'ora.cssd' on 'node01' succeeded
CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'node01'
CRS-2672: Attempting to start 'ora.ctssd' on 'node01'
CRS-2676: Start of 'ora.ctssd' on 'node01' succeeded
CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'node01' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'node01'
CRS-2676: Start of 'ora.asm' on 'node01' succeeded
CRS-2672: Attempting to start 'ora.storage' on 'node01'
CRS-2676: Start of 'ora.storage' on 'node01' succeeded
CRS-2672: Attempting to start 'ora.crf' on 'node01'
CRS-2676: Start of 'ora.crf' on 'node01' succeeded
CRS-2672: Attempting to start 'ora.crsd' on 'node01'
CRS-2676: Start of 'ora.crsd' on 'node01' succeeded
CRS-6023: Starting Oracle Cluster Ready Services-managed resources
CRS-6017: Processing resource auto-start for servers: node01
CRS-6016: Resource auto-start has completed for server node01
CRS-6024: Completed start of Oracle Cluster Ready Services-managed resources
CRS-4123: Oracle High Availability Services has been started.
2017/09/29 11:06:03 CLSRSC-343: Successfully started Oracle Clusterware stack
2017/09/29 11:06:03 CLSRSC-594: Executing installation step 18 of 19: 'ConfigNode'.
Oracle Clusterware infrastructure error in CRSCTL (OS PID 3276): CLSD/ADR initialization failed with return value -1
1: clskec:has:CLSU:910 4 args[clsdAdrInit_CLSK_err][mod=clsdadr.c][loc=(:CLSD00281:)][msg=clsdAdrInit: Additional diagnostic data returned by the ADR component for dbgc_init_all failure:
DIA-49802: missing read, write, or execute permission on specified ADR home directory [/u01/app/grid/diag/crs/node01/crs/log]
DIA-49801: actual permissions [rwxrwxr-x], expected minimum permissions [rwxrwxrwx] for effective user [grid]
DIA-48188: user missing read, write, or exec permission on specified directory
Linux-x86_64 Error: 13: Permission denied
Additional information: 2
Additional information: 511
Additional information: 16893
([all diagnostic data retrieved from ADR])]
2: clskec:has:CLSU:910 4 args[clsdAdrInit_CLSK_err][mod=clsdadr.c][loc=(:CLSD00050:)][msg=clsdAdrInit: call to dbgc_init_all failed. facility:[CRS] product:[CRS] line number:[1422] return code: [ORA-49802] Oracle Base: [/u01/app/grid] Product Type: [CRS] Host Name: [node01] Instance ID: [crs] User Name: [grid]]

CRS-2672: Attempting to start 'ora.ASMNET1LSNR_ASM.lsnr' on 'node01'
CRS-2676: Start of 'ora.ASMNET1LSNR_ASM.lsnr' on 'node01' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'node01'
CRS-2676: Start of 'ora.asm' on 'node01' succeeded
CRS-2672: Attempting to start 'ora.DATA.dg' on 'node01'
CRS-2676: Start of 'ora.DATA.dg' on 'node01' succeeded
2017/09/29 11:09:25 CLSRSC-594: Executing installation step 19 of 19: 'PostConfig'.
2017/09/29 11:10:54 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded
スポンサーリンク

フォローする

合わせて読んでみる

良ければ他の記事もどうぞ!



スポンサーリンク
コメントの入力は終了しました。