This discussion is archived
3 Replies Latest reply: May 17, 2013 4:57 AM by muba_zak RSS

11g Rac Cluster Status

muba_zak Newbie
Currently Being Moderated
Daer All,

we have 2 node 11g Rac with ASM, please see the status, proddb2 ASM & DATABASE running but here it not showing, ora.asm should show STARTED, ora.proddb.db should show OPEN, please let me know how to troubleshoot.


-bash-3.00$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE proddb1
ONLINE ONLINE proddb2
ora.DATAOV.dg
ONLINE ONLINE proddb1
ONLINE ONLINE proddb2
ora.FLASH.dg
ONLINE ONLINE proddb1
ONLINE ONLINE proddb2
ora.LISTENER.lsnr
ONLINE ONLINE proddb1
ONLINE ONLINE proddb2
ora.asm
ONLINE ONLINE proddb1 Started
ONLINE ONLINE proddb2
ora.eons
ONLINE ONLINE proddb1
ONLINE ONLINE proddb2
ora.gsd
OFFLINE OFFLINE proddb1
OFFLINE OFFLINE proddb2
ora.net1.network
ONLINE ONLINE proddb1
ONLINE ONLINE proddb2
ora.ons
ONLINE ONLINE proddb1
ONLINE ONLINE proddb2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE proddb1
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE proddb2
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE proddb2
ora.oc4j
1 OFFLINE OFFLINE
ora.proddb.db
1 ONLINE ONLINE proddb1 Open
2 ONLINE ONLINE proddb2 Instance Shutdown
ora.proddb1.vip
1 ONLINE ONLINE proddb1
ora.proddb2.vip
1 ONLINE ONLINE proddb2
ora.scan1.vip
1 ONLINE ONLINE proddb1
ora.scan2.vip
1 ONLINE ONLINE proddb2
ora.scan3.vip
1 ONLINE ONLINE proddb2
-bash-3.00$

Thanks.
  • 1. Re: 11g Rac Cluster Status
    986120 Explorer
    Currently Being Moderated
    Hi,

    Shutdown and Start database using srvctl utility.

    --
    Bala:)
  • 2. Re: 11g Rac Cluster Status
    J.A. Explorer
    Currently Being Moderated
    Check the DB alert, ASM alert, CRS alert, ...etc

    Restart the DB instance in both nodes:

    ./srvctl stop database -d NAME

    or

    Restart everything on each node:

    ./crsctl stop crs

    I hoppe it helps

    After restart, check status : ./crs_stat -t


    J.A.
  • 3. Re: 11g Rac Cluster Status
    muba_zak Newbie
    Currently Being Moderated
    Dear All

    Thanks
    As you suggested i restarted cluster services database instance and both servers , now status is

    ora.proddb.db
    1 ONLINE ONLINE proddb1 Open
    2 ONLINE ONLINE proddb2 Open

    but

    ora.asm

    1 ONLINE ONLINE proddb1
    2 ONLINE ONLINE proddb2 started

    after restarted the ora.asm started switched from proddb1 to proddb2, why its not showing STARTED for both.


    but bot asm instances started, both instances are working fine. when i connect OEM the asm agents unavailable

    please advise me

    Thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points