【Oracle】11gR2 grid單機使用asm儲存修改主機名後導致的故障處理

dmcatding發表於2017-08-23

環境:
系統:Aix 7.1
資料庫版本:11.2.0.3.11

一. 問題描述:
AIX 7.1作業系統修改了主機名後重啟伺服器後就css和ohasd服務無法啟動


原因分析:
grid不能改主機名
standalone改了就得重配 restart
cluster的話改主機名只能使用增刪節點的方式
本文件是關於重新配置Oracle重啟。如果伺服器(主機)被重新命名,那麼這種操作的一個原因可能是。
如果這是caseand伺服器重新啟動,那麼ASM啟動將會失敗,ora-29701。
解決方案是重新配置Oracle重啟。


has檢查:
[root@itpux grid]# crsctl start has
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-4000: Command Start failed, orcompleted with errors.


[root@itpux grid]# hostname
itpux


css檢查:
[root@itpux grid]# crsctl check css
CRS-4639: Could not contact Oracle HighAvailability Services
CRS-4000: Command Check failed, orcompleted with errors.




啟動+asm例項報錯:
[grid@itpux grid]$ sqlplus / as asmdba
SQL*Plus: Release 11.2.0.4.0 Production onSun Sep 28 13:12:11 2015
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Connected to an idle instance.
SQL> startup
ORA-01078: failure in processing systemparameters
ORA-29701: unable to connect to Cluster Synchronization Service
SQL>




二. 解決方案參考文件:
How to Reconfigure Oracle Restart (文件 ID 986740.1)


實施步驟:
1. 刪除Oracle 重啟配置,這個步驟應該用特權root使用者操作。
[root@itpux grid]#$ORACLE_HOME/crs/install/roothas.pl -deconfig -force
Using configuration parameter file:/u01/app/11.2.0/grid/crs/install/crsconfig_params
CRS-4639: Could not contact Oracle HighAvailability Services
CRS-4000: Command Stop failed, or completedwith errors.
CRS-4639: Could not contact Oracle HighAvailability Services
CRS-4000: Command Delete failed, orcompleted 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-4544: Unable to connect to OHAS
CRS-4000: Command Stop failed, or completedwith errors.
Successfully deconfigured Oracle Restartstack


2. 重新配置Oracle 重啟元件,這步驟也因該用特權root使用者執行。
[root@node1bak grid]# $ORACLE_HOME/crs/install/roothas.pl
Using configuration parameter file:/u01/app/11.2.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 node1bak successfully pinned.
Adding Clusterware entries to inittab
node1bak     2016/09/1811:20:40     /u01/app/11.2.0/grid/cdata/node1bak/backup_20160918_112040.olr
Successfully configured Oracle Grid Infrastructure for aStandalone Server


3. 新增ASM到Oracle重啟配置中,這個步驟使用網格設施所有者grid使用者操作。
[grid@itpux~]$ srvctl add asm


4. 啟動ASM例項,這步驟需要grid使用者。
[grid@itpux~]$ srvctl start asm


5. 重新建立ASM伺服器引數檔案,使用grid使用者。
vi /tmp/init+ASM.ora
asm_diskgroups='DATA','RECO'
instance_type='asm'
large_pool_size=12M
remote_login_passwordfile='EXCLUSIVE'
asm_diskstring='/dev/sdb*'
Mount the disk group where the new server parameter file (SPFILE) will reside (e.g. DATA) and create SPFILE:


$ sqlplus / as sysasm
SQL> startup pfile='/tmp/init+ASM.ora';
ASM instance started
Total System Global Area 1135747072 bytes
Fixed Size              2260728 bytes
Variable Size              1108320520 bytes
ASM Cache                   25165824 bytes
ASM diskgroups mounted
ASM diskgroups volume enabled


SQL> create spfile='+DATA' from pfile='/tmp/init+ASM.ora';
File created.


SQL> show parameter pfile
NAME                                        TYPE       VALUE
----------------------------------------------- ------------------------------
spfile                                          string


SQL> shutdown immediate
ASM diskgroups volume disabled
ASM diskgroups dismounted
ASM instance shutdown


SQL> startup
ASM instance started
Total System Global Area 1135747072 bytes
Fixed Size              2260728 bytes
Variable Size              1108320520 bytes
ASM Cache                   25165824 bytes
ASM diskgroups mounted
ASM diskgroups volume enabled


6. 重啟has服務
[root@itpux grid]# crsctl stop has
CRS-2791: Starting shutdown of Oracle HighAvailability Services-managed resources on 'node1bak'
CRS-2673: Attempting to stop 'ora.DATA.dg'on 'node1bak'
CRS-2677: Stop of 'ora.DATA.dg' on'node1bak' succeeded
CRS-2679: Attempting to clean 'ora.DATA.dg'on 'node1bak'
CRS-2681: Clean of 'ora.DATA.dg' on'node1bak' succeeded
CRS-2673: Attempting to stop 'ora.asm' on'node1bak'
CRS-2677: Stop of 'ora.asm' on 'node1bak'succeeded
CRS-2673: Attempting to stop 'ora.cssd' on'node1bak'
CRS-2677: Stop of 'ora.cssd' on 'node1bak'succeeded
CRS-2673: Attempting to stop 'ora.evmd' on'node1bak'
CRS-2677: Stop of 'ora.evmd' on 'node1bak'succeeded
CRS-2793: Shutdown of Oracle HighAvailability Services-managed resources on 'node1bak' has completed
CRS-4133: Oracle High Availability Serviceshas been stopped.


[root@itpux grid]# crsctl start has
CRS-4123: Oracle High Availability Serviceshas been started.


7. 將元件新增回Oracle重啟配置
如果你有資料庫、監聽和其它元件,請將它們新增到Oracle重啟配置中


7.1. 新增資料庫元件需要oracle使用者執行。
[oracle@itpux ~]$ srvctl add database -dorcl -o /u01/app/oracle/product/11.2.0/dbhome_1


7.2. 新增監聽元件這步驟需要grid使用者。
[grid@itpux ~]$ srvctl add listener


8. 最後啟動資料庫
[oracle@itpux ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production onSun Sep 28 14:12:11 2015
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Connected to an idle instance.


SQL> startup
ORACLE instance started.
Total System Global Area 1235959808 bytes
Fixed Size              2252784 bytes
Variable Size                738197520 bytes
Database Buffers      486539264 bytes
Redo Buffers                 8970240 bytes
Database mounted.
Database opened.

至此完成,OK。

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/30327022/viewspace-2144021/,如需轉載,請註明出處,否則將追究法律責任。

相關文章