RAC环境下删库后重新创建相同实例名的问题总结
在ORACLE RAC环境下，删除之前创建的数据库后，OCR中仍然有该实例的注册信息，状态为OFFLINE，如下：
使用crs_unregister命令注销crs中offline的资源 ，如下：
重新使用DBCA建库的时候报ORA-00119、ORA-00132、ORA-01078
此处使用图形界面下netca重建监听，之后就没有出现这个错误了；
[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
使用crs_unregister命令注销crs中offline的资源 ，如下：
重新使用DBCA建库的时候报ORA-00119、ORA-00132、ORA-01078
此处使用图形界面下netca重建监听，之后就没有出现这个错误了；
[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博客 ” ，链接：https://blog.itpub.net/14288937/viewspace-1264036/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- 缺少log_archive_config导致归档路径被禁用
- [WK-T]ORACLE RAC +ASM Backup and Recovery(四)
- [WK-T]ORACLE RAC +ASM Backup and Recovery(三)
- [WK-T]ORACLE RAC +ASM Backup and Recovery(二)
- [WK-T]ORACLE RAC +ASM Backup and Recovery(一)
- [WK-T]ORACLE 10G RAC+ASM增加controlfile
- How to copy a datafile from ASM to a file system not using RMAN
- Oracle Flashback(二)
- Oracle Flashback(一)
- ORACLE10g Stream表级复制配置
