下面是一次10G RAC增加ASM实例报错。
故障之前就做了一次crs_unregister ASM的操作，随后增加ASM实例就增加不上了。
欢迎大家加入ORACLE超级群：17115662 免费解决各种ORACLE问题,以后BLOG将迁移到http://www.htz.pw
1，故障现象
| [oracle@www.htz.pw oracle] $ srvctl add asm -n sol1 -i +ASM1 -o $ORACLE_HOME -p $ORACLE_HOME/dbs/spfile+ASM1.ora PRKS-1000 : ASM instance "+ASM1" already exists on node "sol1" |
网上有人说通过重启crs可以解决问题
| [oracle@www.htz.pw oracle] # crsctl stop crs Stopping resources. This could take several minutes. Successfully stopped CRS resources. Stopping CSSD. Shutting down CSS daemon. Shutdown request successfully issued. [oracle@www.htz.pw oracle] # crsctl start crs Attempting to start CRS stack The CRS stack will be started shortly
[oracle@www.htz.pw oracle] # crsctl check crs CSS appears healthy CRS appears healthy EVM appears healthy |
通过重启后，仍然报错现象仍然存在
没有办法，srvctl remove删除的时候，也找不到资源，只能手动新创一个资源。
| [oracle@www.htz.pw oracle] $ crs_stat -p ora.sol2.ASM2.asm>$ORA_CRS_HOME/crs/public/ora.sol1.ASM1.asm.cap
[oracle@www.htz.pw oracle] $ vi $ORA_CRS_HOME/crs/public/ora.sol1.ASM1.asm.cap "/oracle/app/oracle/product/10.2.0/crs_1/crs/public/ora.sol1.ASM1.asm.cap" 39 lines, 814 characters NAME=ora.sol1.ASM1.asm TYPE=application ACTION_SCRIPT=/oracle/app/oracle/product/10.2.0/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=sol1 OPTIONAL_RESOURCES= PLACEMENT=restricted REQUIRED_RESOURCES= 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@www.htz.pw oracle] $ crs_register ora.sol1.ASM1.asm 这里我们需要修改手动一个spfile的路径名 [oracle@www.htz.pw oracle] $ srvctl modify asm -n sol1 -i +ASM2 -p $ORACLE_HOME/dbs/spfile+ASM1.ora [oracle@www.htz.pw oracle] $ srvctl start asm -n sol1
能正常启动 [oracle@www.htz.pw oracle] $ crs_stat -t Name Type Target State Host ------------------------------------------------------------ ora....SM1.asm application ONLINE ONLINE sol1 ora....L1.lsnr application ONLINE ONLINE sol1 ora.sol1.gsd application ONLINE ONLINE sol1 ora.sol1.ons application ONLINE ONLINE sol1 ora.sol1.vip application ONLINE ONLINE sol1 ora.sol10g.db application ONLINE ONLINE sol2 ora....g2.inst application ONLINE ONLINE sol2 ora....SM2.asm application ONLINE ONLINE sol2 ora....L2.lsnr application ONLINE ONLINE sol2 ora.sol2.gsd application ONLINE ONLINE sol2 ora.sol2.ons application ONLINE ONLINE sol2 ora.sol2.vip application ONLINE ONLINE sol2
|
