ORA-00304: requested INSTANCE_NUMBER is busy

最新推荐文章于 2024-07-06 19:37:51 发布

不再疯要傻

最新推荐文章于 2024-07-06 19:37:51 发布

阅读量9.1k

点赞数 2

分类专栏： ORACLE问题解决

本文链接：https://blog.csdn.net/bzfys/article/details/48733207

版权

这篇博客记录了解决ASM连接错误ORA-00304的问题。作者首先尝试启动ASM实例失败，发现CRS状态正常但ASM进程存在。通过检查环境变量$ORACLE_SID发现配置错误，将其更正为正确的实例名后，问题得到解决，能够成功连接到ASM实例。

摘要由CSDN通过智能技术生成

今天发现asmcmd的时候是连接了空实例

[grid@RAC01 ~]$ asmcmd

Connected to an idle instance.
ASMCMD> ls
ASMCMD-8102: no connection to ASM; command requires ASM to run

ASMCMD> exit

想当然的进到asm实例中进行启动

[grid@RAC01 ~]$ sqlplus / as sysasm

SQL*Plus: Release 11.2.0.3.0 Production on Wed Sep 23 22:38:57 2015

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup
ORA-00304: requested INSTANCE_NUMBER is busy
SQL> exit

通过查看发现crs_stat发现asm正常

[grid@RAC01 ~]$ crs_stat -t -v

Name Type R/RA F/FT Target State Host
----------------------------------------------------------------------
ora.ARCH.dg ora....up.type 0/5 0/ ONLINE ONLINE rac01
ora....VOTE.dg ora....up.type 0/5 0/ ONLINE ONLINE rac01
ora.DATA.dg ora....up.type 0/5 0/ ONLINE ONLINE rac01
ora....ER.lsnr ora....er.type 0/5 0/ ONLINE ONLINE rac01
ora....N1.lsnr ora....er.type 0/5 0/0 ONLINE ONLINE rac02
ora.REDO.dg ora....up.type 0/5 0/ ONLINE ONLINE rac01
ora.asm ora.asm.type 0/5 0/ ONLINE ONLINE rac01
ora.cvu ora.cvu.type 0/5 0/0 ONLINE ONLINE rac02
ora.gsd ora.gsd.type 0/5 0/ OFFLINE OFFLINE    <