在ORACLE RAC环境下,删除之前创建的数据库后,OCR中仍然有该实例的注册信息,状态为OFFLINE,如下:
![](//img.blog.itpub.net/blog/attachment/201408/26/29634949_1409049642v3VR.png?x-oss-process=style/bb)
使用crs_unregister命令注销crs中offline的资源 ,如下:
![](//img.blog.itpub.net/blog/attachment/201408/26/29634949_1409049794yBkY.png?x-oss-process=style/bb)
重新使用DBCA建库的时候报ORA-00119、ORA-00132、ORA-01078
![](//img.blog.itpub.net/blog/attachment/201408/26/29634949_14090523669lau.png?x-oss-process=style/bb)
此处使用图形界面下netca重建监听,之后就没有出现这个错误了;
![](//img.blog.itpub.net/blog/attachment/201408/26/29634949_1409053358i9IF.png?x-oss-process=style/bb)
[oracle@rac1 admin]$ 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.HHPEN1.db application 0/1 0/1 ONLINE ONLINE rac1
ora.orcl.db application 0/1 0/1 ONLINE ONLINE rac1
ora....l1.inst application 0/5 0/0 ONLINE ONLINE rac1
ora....l2.inst application 0/5 0/0 ONLINE ONLINE rac2
ora...._TAF.cs application 0/0 0/1 ONLINE ONLINE rac1
ora....cl1.srv application 0/0 0/0 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....SM2.asm application 0/5 0/0 ONLINE ONLINE rac2
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
![](http://img.blog.itpub.net/blog/attachment/201408/26/29634949_1409049642v3VR.png?x-oss-process=style/bb)
使用crs_unregister命令注销crs中offline的资源 ,如下:
![](http://img.blog.itpub.net/blog/attachment/201408/26/29634949_1409049794yBkY.png?x-oss-process=style/bb)
重新使用DBCA建库的时候报ORA-00119、ORA-00132、ORA-01078
![](http://img.blog.itpub.net/blog/attachment/201408/26/29634949_14090523669lau.png?x-oss-process=style/bb)
此处使用图形界面下netca重建监听,之后就没有出现这个错误了;
![](http://img.blog.itpub.net/blog/attachment/201408/26/29634949_1409053358i9IF.png?x-oss-process=style/bb)
[oracle@rac1 admin]$ 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.HHPEN1.db application 0/1 0/1 ONLINE ONLINE rac1
ora.orcl.db application 0/1 0/1 ONLINE ONLINE rac1
ora....l1.inst application 0/5 0/0 ONLINE ONLINE rac1
ora....l2.inst application 0/5 0/0 ONLINE ONLINE rac2
ora...._TAF.cs application 0/0 0/1 ONLINE ONLINE rac1
ora....cl1.srv application 0/0 0/0 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....SM2.asm application 0/5 0/0 ONLINE ONLINE rac2
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
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29634949/viewspace-1258364/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29634949/viewspace-1258364/