ORACLE RAC環境下某節點的+ASM註冊到CRS資源中
環境配置:
OS版本:Enterprise Linux Enterprise Linux Server release 5.4 (Carthage)
DB版本:Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
出現節點rac2的ASM不能註冊到CRS資源中,啟動RAC庫的時候就無法自動啟動+ASM2,導致例項2就不能啟動,只能通過手動先啟動+ASM2,然後手動啟動例項2解決。現在將+ASM2註冊到CRS中,如下
1.檢視CRS資源註冊資訊
[oracle@rac1 ~]$ crs_stat -t -v
Name Type R/RA F/FT Target State Host
----------------------------------------------------------------------
ora....11.inst application 0/5 0/0 ONLINE ONLINE rac1
ora....12.inst application 0/5 0/0 ONLINE ONLINE rac2
ora....N11.srv application 0/0 0/0 ONLINE ONLINE rac1
ora...._TAF.cs application 0/0 0/1 ONLINE ONLINE rac1
ora.HHPEN1.db application 0/0 0/1 ONLINE ONLINE rac2
ora....SM1.asm application 0/5 0/0 ONLINE ONLINE rac1
ora....C1.lsnr application 0/5 0/0 ONLINE ONLINE rac1
ora.rac1.gsd application 0/5 0/0 ONLINE ONLINE rac1
ora.rac1.ons application 0/3 0/0 ONLINE ONLINE rac1
ora.rac1.vip application 0/0 0/0 ONLINE ONLINE rac1
ora....C2.lsnr application 0/5 0/0 ONLINE ONLINE rac2
ora.rac2.gsd application 0/5 0/0 ONLINE ONLINE rac2
ora.rac2.ons application 0/3 0/0 ONLINE ONLINE rac2
ora.rac2.vip application 0/0 0/0 ONLINE ONLINE rac2
CRS-0181: Cannot access the resource profile '/u01/app/oracle/crs/crs/public/ora.rac2.ASM2.asm.cap'.
OS版本:Enterprise Linux Enterprise Linux Server release 5.4 (Carthage)
DB版本:Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
出現節點rac2的ASM不能註冊到CRS資源中,啟動RAC庫的時候就無法自動啟動+ASM2,導致例項2就不能啟動,只能通過手動先啟動+ASM2,然後手動啟動例項2解決。現在將+ASM2註冊到CRS中,如下
1.檢視CRS資源註冊資訊
[oracle@rac1 ~]$ crs_stat -t -v
Name Type R/RA F/FT Target State Host
----------------------------------------------------------------------
ora....11.inst application 0/5 0/0 ONLINE ONLINE rac1
ora....12.inst application 0/5 0/0 ONLINE ONLINE rac2
ora....N11.srv application 0/0 0/0 ONLINE ONLINE rac1
ora...._TAF.cs application 0/0 0/1 ONLINE ONLINE rac1
ora.HHPEN1.db application 0/0 0/1 ONLINE ONLINE rac2
ora....SM1.asm application 0/5 0/0 ONLINE ONLINE rac1
ora....C1.lsnr application 0/5 0/0 ONLINE ONLINE rac1
ora.rac1.gsd application 0/5 0/0 ONLINE ONLINE rac1
ora.rac1.ons application 0/3 0/0 ONLINE ONLINE rac1
ora.rac1.vip application 0/0 0/0 ONLINE ONLINE rac1
ora....C2.lsnr application 0/5 0/0 ONLINE ONLINE rac2
ora.rac2.gsd application 0/5 0/0 ONLINE ONLINE rac2
ora.rac2.ons application 0/3 0/0 ONLINE ONLINE rac2
ora.rac2.vip application 0/0 0/0 ONLINE ONLINE rac2
2.使用crs_register進行註冊
[oracle@rac1 ~]$ crs_register ora.rac2.ASM2.asmCRS-0181: Cannot access the resource profile '/u01/app/oracle/crs/crs/public/ora.rac2.ASM2.asm.cap'.
[oracle@rac1 ~]$ cd /u01/app/oracle/crs/crs/public
[oracle@rac1 public]$ ls
action_scr.scr ora.bak ora.rac1.ASM1.asm.cap
[oracle@rac1 public]$ cp ora.rac1.ASM1.asm.cap ora.rac2.ASM2.asm.cap
[oracle@rac1 public]$ ls
action_scr.scr ora.bak ora.rac1.ASM1.asm.cap ora.rac2.ASM2.asm.cap
[oracle@rac1 public]$ ls
action_scr.scr ora.bak ora.rac1.ASM1.asm.cap
[oracle@rac1 public]$ cp ora.rac1.ASM1.asm.cap ora.rac2.ASM2.asm.cap
[oracle@rac1 public]$ ls
action_scr.scr ora.bak ora.rac1.ASM1.asm.cap ora.rac2.ASM2.asm.cap
[oracle@rac1 public]$ cat ora.rac2.ASM2.asm.cap --修改其中的配置如下
NAME=ora.rac2.ASM2.asm
TYPE=application
ACTION_SCRIPT=/u01/app/oracle/db_1/bin/racgwrap
ACTIVE_PLACEMENT=0
AUTO_START=1
CHECK_INTERVAL=600
DESCRIPTION=CRS application for ASM instance
FAILOVER_DELAY=0
FAILURE_INTERVAL=0
FAILURE_THRESHOLD=0
HOSTING_MEMBERS=rac2
OPTIONAL_RESOURCES=
PLACEMENT=restricted
REQUIRED_RESOURCES=ora.rac2.vip
RESTART_ATTEMPTS=5
SCRIPT_TIMEOUT=600
START_TIMEOUT=0
STOP_TIMEOUT=0
UPTIME_THRESHOLD=7d
USR_ORA_ALERT_NAME=
USR_ORA_CHECK_TIMEOUT=0
USR_ORA_CONNECT_STR=/ as sysdba
USR_ORA_DEBUG=0
USR_ORA_DISCONNECT=false
USR_ORA_FLAGS=
USR_ORA_IF=
USR_ORA_INST_NOT_SHUTDOWN=
USR_ORA_LANG=
USR_ORA_NETMASK=
USR_ORA_OPEN_MODE=mount
USR_ORA_OPI=false
USR_ORA_PFILE=
USR_ORA_PRECONNECT=none
USR_ORA_SRV=
USR_ORA_START_TIMEOUT=0
USR_ORA_STOP_MODE=immediate
USR_ORA_STOP_TIMEOUT=0
USR_ORA_VIP=
NAME=ora.rac2.ASM2.asm
TYPE=application
ACTION_SCRIPT=/u01/app/oracle/db_1/bin/racgwrap
ACTIVE_PLACEMENT=0
AUTO_START=1
CHECK_INTERVAL=600
DESCRIPTION=CRS application for ASM instance
FAILOVER_DELAY=0
FAILURE_INTERVAL=0
FAILURE_THRESHOLD=0
HOSTING_MEMBERS=rac2
OPTIONAL_RESOURCES=
PLACEMENT=restricted
REQUIRED_RESOURCES=ora.rac2.vip
RESTART_ATTEMPTS=5
SCRIPT_TIMEOUT=600
START_TIMEOUT=0
STOP_TIMEOUT=0
UPTIME_THRESHOLD=7d
USR_ORA_ALERT_NAME=
USR_ORA_CHECK_TIMEOUT=0
USR_ORA_CONNECT_STR=/ as sysdba
USR_ORA_DEBUG=0
USR_ORA_DISCONNECT=false
USR_ORA_FLAGS=
USR_ORA_IF=
USR_ORA_INST_NOT_SHUTDOWN=
USR_ORA_LANG=
USR_ORA_NETMASK=
USR_ORA_OPEN_MODE=mount
USR_ORA_OPI=false
USR_ORA_PFILE=
USR_ORA_PRECONNECT=none
USR_ORA_SRV=
USR_ORA_START_TIMEOUT=0
USR_ORA_STOP_MODE=immediate
USR_ORA_STOP_TIMEOUT=0
USR_ORA_VIP=
[oracle@rac1 public]$ crs_register ora.rac2.ASM2.asm --重新註冊
批註:也許每個人的RAC環境不一樣,我的這種情況是之前一個節點的磁碟壞了,然後將其剔除叢集環境,新增加了一個節點放入叢集環境,但是後來新
新增的節點+ASM2並沒有註冊到CRS資源中,以至於crs_stat -t -v不顯示+ASM2的資訊,本篇文章是基於這種情況下的解決辦法。
基於我之前總結的重建ASM的後續問題解決:http://blog.itpub.net/29634949/viewspace-1280908/
-- END --
3.檢視是否註冊資源成功
批註:也許每個人的RAC環境不一樣,我的這種情況是之前一個節點的磁碟壞了,然後將其剔除叢集環境,新增加了一個節點放入叢集環境,但是後來新
新增的節點+ASM2並沒有註冊到CRS資源中,以至於crs_stat -t -v不顯示+ASM2的資訊,本篇文章是基於這種情況下的解決辦法。
基於我之前總結的重建ASM的後續問題解決:http://blog.itpub.net/29634949/viewspace-1280908/
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29634949/viewspace-1298048/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORACLE RAC環境下刪除節點Oracle
- Oracle RAC環境下ASM磁碟組擴容OracleASM
- (轉)Oracle rac環境下清除asm例項OracleASM
- linux下rac環境下刪除節點Linux
- Solaris下修改RAC環境節點IP地址
- oracle兩節點RAC,由於gipc導致某節點crs無法啟動問題分析Oracle
- 虛擬機器環境下RAC加入節點虛擬機
- RAC和ASM環境下打patchASM
- ORACLE RAC環境下節點自動重啟問題總結Oracle
- (轉)windows環境下rac節點時間同步方法Windows
- Oracle10g RAC ASM 環境日常管理OracleASM
- ORACLE RAC 環境下修改IPOracle
- 虛擬機器環境下RAC刪除節點(Final)虛擬機
- Oracle10203RAC環境刪除節點(三)Oracle
- Oracle10203RAC環境刪除節點(二)Oracle
- Oracle10203RAC環境刪除節點(一)Oracle
- Oracle10203RAC環境新增新節點(一)Oracle
- Oracle10203RAC環境新增新節點(六)Oracle
- Oracle10203RAC環境新增新節點(五)Oracle
- Oracle10203RAC環境新增新節點(四)Oracle
- Oracle10203RAC環境新增新節點(三)Oracle
- Oracle10203RAC環境新增新節點(二)Oracle
- Oracle RAC 環境下的連線管理Oracle
- 刪除Linux非rac環境下的ASM例項LinuxASM
- [zt]ORACLE 10gR2 RAC環境增加及刪除節點Oracle 10g
- 【RAC】刪除RAC資料庫節點(二)——刪除ASM資料庫ASM
- Oracle 10.2的單機(非RAC)環境中建立ASM的實驗記錄OracleASM
- 刪除Linux非rac環境下的ASM例項(轉)LinuxASM
- rman 可否克隆rac資料庫到另外一個rac環境的資料庫中?資料庫
- Oracle RAC解除安裝後的重灌重點環節Oracle
- oracle rac 中 映象 控制檔案 更新雙節點spfile for ASM 2013修改OracleASM
- ORACLE 10gR2 RAC環境增加及刪除節點-(1)初始化第3臺節點Oracle 10g
- Oracle 11.2.0.4 rac for aix acfs異常環境的克隆環境ASM磁碟組掛載緩慢OracleAIASM
- Oracle RAC新增節點Oracle
- Oracle RAC 新增節點Oracle
- RAC環境下dataguard的搭建
- 查詢RAC環境中例項間資源分配情況
- Linux環境下CRS升級到10.2.0.4.2 Database升級到10.2.0.4.3LinuxDatabase