问题描述
下面是一次10G RAC增加ASM实例报错。
故障之前就做了一次crs_unregister ASM的操作,随后增加ASM实例就增加不上了。
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
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。