【Oracle】11gR2 grid單機使用asm儲存修改主機名後導致的故障處理
環境:
系統: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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle 11gR2 oracle restart 單機使用asm儲存 主機名發生更改處理過程OracleRESTASM
- Oracle 11gR2 restart 單機使用asm儲存 主機名發生更改處理過程 (文件 ID 986740.1)OracleRESTASM
- 【故障處理】修改主機名導致oracle例項無法啟動暨如何修改hostnameOracle
- 改主機名後Oracle OEM無法使用處理方法Oracle
- Linux主機名修改後導致mysql重啟失敗LinuxMySql
- 【故障處理】【LISTENER】主機名修改為IP地址後LISTENER無法監聽到例項
- 在IBM 7133儲存上安裝oracle rac+asm時修改主機名出現的問題IBMOracleASM
- 修改計算機名後導致Oracle無法訪問的問題修復計算機Oracle
- 更改主機名後,導致db2啟動不了DB2
- 簡單修改Linux主機名Linux
- ORA-01034,修改主機名導致的資料庫問題資料庫
- Linux修改主機名(靜態主機名、臨時主機名)Linux
- MAC修改主機名、計算機名Mac計算機
- oracle 11.2.0.3 單機 asm 儲存打psu 10補丁OracleASM
- linux主機名的修改Linux
- 修改主機名後DB2的設定方法DB2
- Ubuntu Server修改主機名UbuntuServer
- Linux 修改主機名Linux
- 修改linux主機名Linux
- Linux修改主機名Linux
- ubuntu修改主機名稱Ubuntu
- 儲存崩潰導致資料丟失如何處理
- solaris 主機修改主機名 ip地址 步驟
- linux修改主機名的方法Linux
- 如何修改mac 下主機名、電腦名、區域網主機名Mac
- 11gR2修改使用者後導致系統HANG住
- Linux 修改主機名(hostname)Linux
- Solaris - 修改IP和主機名
- redhat5修改主機名Redhat
- Linux7修改主機IP及主機名Linux
- centOS修改主機名,重啟後無效解決CentOS
- 儲存多路徑故障導致資料庫死掉案例資料庫
- 修改linux主機名的步驟Linux
- WAS修改了主機名的設定方法
- 記一次儲存問題導致的rac故障案例
- Oracle修改主機名問題解決案例一則Oracle
- AIX 主機 — 設定以使用 iSCSI 儲存AI
- 不停機處理oracle超過最大processes數故障Oracle