Oracle11gR2grid單機(jī)使用asm存儲(chǔ)修改主機(jī)名后導(dǎo)致的故障怎么辦

這篇文章將為大家詳細(xì)講解有關(guān)Oracle11gR2 grid單機(jī)使用asm存儲(chǔ)修改主機(jī)名后導(dǎo)致的故障怎么辦，小編覺得挺實(shí)用的，因此分享給大家做個(gè)參考，希望大家閱讀完這篇文章后可以有所收獲。

讓客戶滿意是我們工作的目標(biāo)，不斷超越客戶的期望值來自于我們對(duì)這個(gè)行業(yè)的熱愛。我們立志把好的技術(shù)通過有效、簡(jiǎn)單的方式提供給客戶，將通過不懈努力成為客戶在信息化領(lǐng)域值得信任、有價(jià)值的長(zhǎng)期合作伙伴，公司提供的服務(wù)項(xiàng)目有：國際域名空間、雅安服務(wù)器托管、營銷軟件、網(wǎng)站建設(shè)、遂溪網(wǎng)站維護(hù)、網(wǎng)站推廣。

環(huán)境：
系統(tǒng)：Aix 7.1
數(shù)據(jù)庫版本：11.2.0.3.11

一. 問題描述：
AIX 7.1操作系統(tǒng)修改了主機(jī)名后重啟服務(wù)器后就css和ohasd服務(wù)無法啟動(dòng)原因分析：
grid不能改主機(jī)名
standalone改了就得重配 restart
cluster的話改主機(jī)名只能使用增刪節(jié)點(diǎn)的方式
本文檔是關(guān)于重新配置Oracle重啟。如果服務(wù)器(主機(jī))被重命名，那么這種操作的一個(gè)原因可能是。
如果這是caseand服務(wù)器重新啟動(dòng)，那么ASM啟動(dòng)將會(huì)失敗，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: scrsearch2
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
itpuxcss檢查：
[root@itpux grid]# crsctl check css
CRS-4639: Could not contact Oracle HighAvailability Services
CRS-4000: Command Check failed, orcompleted with errors.

啟動(dòng)+asm實(shí)例報(bào)錯(cuò)：
[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)實(shí)施步驟：
1. 刪除Oracle 重啟配置，這個(gè)步驟應(yīng)該用特權(quán)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: scrsearch2
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 Restartstack2. 重新配置Oracle 重啟組件，這步驟也因該用特權(quán)root用戶執(zhí)行。
[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 Server3. 添加ASM到Oracle重啟配置中，這個(gè)步驟使用網(wǎng)格設(shè)施所有者grid用戶操作。
[grid@itpux~]$ srvctl add asm4. 啟動(dòng)ASM實(shí)例，這步驟需要grid用戶。
[grid@itpux~]$ srvctl start asm5. 重新創(chuàng)建ASM服務(wù)器參數(shù)文件，使用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 enabledSQL> create spfile='+DATA' from pfile='/tmp/init+ASM.ora';
File created.SQL> show parameter pfile
NAME                                        TYPE       VALUE
----------------------------------------------- ------------------------------
spfile                                          stringSQL> shutdown immediate
ASM diskgroups volume disabled
ASM diskgroups dismounted
ASM instance shutdownSQL> 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 enabled6. 重啟has服務(wù)
[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重啟配置
如果你有數(shù)據(jù)庫、監(jiān)聽和其它組件，請(qǐng)將它們添加到Oracle重啟配置中7.1. 添加數(shù)據(jù)庫組件需要oracle用戶執(zhí)行。
[oracle@itpux ~]$ srvctl add database -dorcl -o /u01/app/oracle/product/11.2.0/dbhome_17.2. 添加監(jiān)聽組件這步驟需要grid用戶。
[grid@itpux ~]$ srvctl add listener8. 最后啟動(dòng)數(shù)據(jù)庫
[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.

關(guān)于“Oracle11gR2 grid單機(jī)使用asm存儲(chǔ)修改主機(jī)名后導(dǎo)致的故障怎么辦”這篇文章就分享到這里了，希望以上內(nèi)容可以對(duì)大家有一定的幫助，使各位可以學(xué)到更多知識(shí)，如果覺得文章不錯(cuò)，請(qǐng)把它分享出去讓更多的人看到。

網(wǎng)頁名稱：Oracle11gR2grid單機(jī)使用asm存儲(chǔ)修改主機(jī)名后導(dǎo)致的故障怎么辦
URL地址：http://muchs.cn/article0/pidpio.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供域名注冊(cè)、網(wǎng)頁設(shè)計(jì)公司、微信公眾號(hào)、商城網(wǎng)站、云服務(wù)器、移動(dòng)網(wǎng)站建設(shè)

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來源： 創(chuàng)新互聯(lián)