ITPub博客

首页 > 数据库 > Oracle > ORA-00304: requested INSTANCE_NUMBER is busy

ORA-00304: requested INSTANCE_NUMBER is busy

原创 Oracle 作者:哎呀我的天呐 时间:2015-05-21 18:08:19 0 删除 编辑

grid用户
sqlplus / as sysasm报如标题错
查看都起来了啊

保点击( 此处 )折叠或打开

  1. [ grid@rac2 ohasd ] $ crsctl stat res - t

  2. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

  3. NAME TARGET  STATE        SERVER                   STATE_DETAILS

  4. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

  5. Local Resources

  6. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

  7. ora . DATA_EXTERNAL . dg

  8.                ONLINE  ONLINE       rac1

  9.                ONLINE  ONLINE       rac2

  10. ora . DATA_MORMAL . dg

  11.                ONLINE  ONLINE       rac1

  12.                ONLINE  ONLINE       rac2

  13. ora . LISTENER . lsnr

  14.                ONLINE  ONLINE       rac1

  15.                ONLINE  ONLINE       rac2

  16. ora . OCR . dg

  17.                ONLINE  ONLINE       rac1

  18.                ONLINE  ONLINE       rac2

  19. ora . asm

  20.                ONLINE  ONLINE       rac1                     Started

  21.                ONLINE  ONLINE       rac2                     Started

  22. ora . gsd

  23.                OFFLINE OFFLINE      rac1

  24.                OFFLINE OFFLINE      rac2

  25. ora . net1 . network

  26.                ONLINE  ONLINE       rac1

  27.                ONLINE  ONLINE       rac2

  28. ora . ons

  29.                ONLINE  ONLINE       rac1

  30.                ONLINE  ONLINE       rac2

  31. ora . registry . acfs

  32.                ONLINE  ONLINE       rac1

  33.                ONLINE  ONLINE       rac2

  34. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

  35. Cluster Resources

  36. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

  37. ora . LISTENER_SCAN1 . lsnr

  38.       1        ONLINE  ONLINE       rac2

  39. ora . cvu

  40.       1        ONLINE  ONLINE       rac2

  41. ora . oc4j

  42.       1        ONLINE  ONLINE       rac2

  43. ora . prod . db

  44.       1        ONLINE  ONLINE       rac1                     Open

  45.       2        ONLINE  ONLINE       rac2                     Open

  46. ora . rac1 . vip

  47.       1        ONLINE  ONLINE       rac1

  48. ora . rac2 . vip

  49.       1        ONLINE  ONLINE       rac2

  50. ora . scan1 . vip

  51.       1        ONLINE  ONLINE       rac2

Oracle Restart

点击( 此处 )折叠或打开

  1. [ root@rac1 ~ ] # crsctl stop has

  2. CRS - 2791 : Starting shutdown of Oracle High Availability Services - managed resources on 'rac1'

  3. CRS - 2673 : Attempting to stop 'ora.crsd' on 'rac1'

  4. CRS - 2790 : Starting shutdown of Cluster Ready Services - managed resources on 'rac1'

  5. CRS - 2673 : Attempting to stop 'ora.cvu' on 'rac1'

  6. CRS - 2673 : Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'rac1'


点击( 此处 )折叠或打开

  1. [ root@rac1 ~ ] # crsctl start has

  2. CRS - 4123 : Oracle High Availability Services has been started .

  3. [ root@rac1 ~ ] # crsctl check has

  4. CRS - 4638 : Oracle High Availability Services is online

查看2节点 环境变量我日,ORACLE_SID=ASM1


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

上一篇: over (partition by)
请登录后发表评论 登录
全部评论
https://cloud.tencent.com/developer/inventory/14362

注册时间:2014-10-30

  • 博文量
    403
  • 访问量
    2528725