sitemap

RSS地图

收藏本站

设为首页

Oracle研究中心

当前位置:Oracle研究中心 > 故障案例 >

【案例】Oracle RAC 增加ASM时报错PRKS-1000的原因和解决办法

时间:2016-10-22 22:47   来源:Oracle研究中心   作者:HTZ   点击:

天萃荷净 Oracle研究中心案例分析:运维DBA反映在操作Oracle RAC数据库时报错PRKS-1000 : ASM instance "+ASM1" already exists on node "sol1",结合MOS分析产生原因和解决办法。
下面是一次10G RAC增加ASM实例报错。
故障之前就做了一次crs_unregister ASM的操作,随后增加ASM实例就增加不上了。
欢迎大家加入ORACLE超级群:17115662 免费解决各种ORACLE问题,以后BLOG将迁移到http://www.htz.pw

1,故障现象

[oracle@oracleplus.net 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@oracleplus.net 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@oracleplus.net oracle] # crsctl start crs
Attempting to start CRS stack
The CRS stack will be started shortly


[oracle@oracleplus.net oracle] # crsctl check crs
CSS appears healthy
CRS appears healthy
EVM appears healthy
通过重启后,仍然报错现象仍然存在

2.没有办法,srvctl remove删除的时候,也找不到资源,只能手动新创一个资源。

[oracle@oracleplus.net oracle] $ crs_stat -p ora.sol2.ASM2.asm>$ORA_CRS_HOME/crs/public/ora.sol1.ASM1.asm.cap

[oracle@oracleplus.net 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@oracleplus.net oracle] $ crs_register ora.sol1.ASM1.asm
这里我们需要修改手动一个spfile的路径名
[oracle@oracleplus.net oracle] $ srvctl modify asm -n sol1 -i +ASM2 -p $ORACLE_HOME/dbs/spfile+ASM1.ora
[oracle@oracleplus.net oracle] $ srvctl start asm -n sol1

能正常启动
[oracle@oracleplus.net 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

本文固定链接: http://www.htz.pw/2014/05/11/prks-1000-asm-instance-asm1-already-exists-on-node-sol1.html | 认真就输

--------------------------------------ORACLE-DBA----------------------------------------

最权威、专业的Oracle案例资源汇总之【案例】Oracle RAC 增加ASM时报错PRKS-1000的原因和解决办法

本文由大师惜分飞原创分享,网址:http://www.oracleplus.net/arch/1035.html

Oracle研究中心

关键词:

PRKS-1000:ASM instance already exists on node

Oracle报错PRKS-1000的解决办法