用crs_unregister命令注销crs中offline的资源,解决PRKP-1037错误

        项目上线在实施安装RAC的时候，由于操作失误，删除数据库实例之后，每个节点的1个数据库和2个实例资源还都存在，并且都是offline状态。这时重新创建数据库的时候，会报PRKP-1037错误。

查看RAC资源状态：

[oracle@racdb1 ~]$ crs_stat -t

Name           Type           Target    State     Host        

------------------------------------------------------------

ora.racdb.db   application    OFFLINE    OFFLINE          

ora....b1.inst application    OFFLINE    OFFLINE         

ora....b2.inst application    OFFLINE    OFFLINE         

ora....SM1.asm application    ONLINE    ONLINE    racdb1      

ora....B1.lsnr application    ONLINE    ONLINE    racdb1      

ora.racdb1.gsd application    ONLINE    ONLINE    racdb1      

ora.racdb1.ons application    ONLINE    ONLINE    racdb1      

ora.racdb1.vip application    ONLINE    ONLINE    racdb1      

ora....SM2.asm application    ONLINE    ONLINE    racdb2      

ora....B2.lsnr application    ONLINE    ONLINE    racdb2      

ora.racdb2.gsd application    ONLINE    ONLINE    racdb2      

ora.racdb2.ons application    ONLINE    ONLINE    racdb2      

ora.racdb2.vip application    ONLINE    ONLINE    racdb2   

查看服务名称：

[oracle@racdb1 ~]$ crs_stat

NAME=ora.racdb.db

TYPE=application

TARGET=ONLINE

STATE=ONLINE on racdb1

NAME=ora.racdb.racdb1.inst

TYPE=application

TARGET=ONLINE

STATE=ONLINE on racdb1

NAME=ora.racdb.racdb2.inst

TYPE=application

TARGET=ONLINE

STATE=ONLINE on racdb2

NAME=ora.racdb1.ASM1.asm

TYPE=application

TARGET=ONLINE

STATE=ONLINE on racdb1

NAME=ora.racdb1.LISTENER_RACDB1.lsnr

TYPE=application

TARGET=ONLINE

STATE=ONLINE on racdb1

NAME=ora.racdb1.gsd

TYPE=application

TARGET=ONLINE

STATE=ONLINE on racdb1

NAME=ora.racdb1.ons

TYPE=application

TARGET=ONLINE

STATE=ONLINE on racdb1

NAME=ora.racdb1.vip

TYPE=application

TARGET=ONLINE

STATE=ONLINE on racdb1

NAME=ora.racdb2.ASM2.asm

TYPE=application

TARGET=ONLINE

STATE=ONLINE on racdb2

NAME=ora.racdb2.LISTENER_RACDB2.lsnr

TYPE=application

TARGET=ONLINE

STATE=ONLINE on racdb2

NAME=ora.racdb2.gsd

TYPE=application

TARGET=ONLINE

STATE=ONLINE on racdb2

NAME=ora.racdb2.ons

TYPE=application

TARGET=ONLINE

STATE=ONLINE on racdb2

NAME=ora.racdb2.vip

TYPE=application

TARGET=ONLINE

STATE=ONLINE on racdb2

注销资源：

crs_unregister ora.racdb.db
crs_unregister ora.racdb.racdb1.inst

crs_unregister ora.racdb.racdb2.inst

重新安装实例成功。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/12272958/viewspace-710310/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/12272958/viewspace-710310/