This discussion is archived
9 Replies Latest reply: Oct 18, 2012 3:32 AM by 864103 RSS

status of rac

864103 Newbie
Currently Being Moderated
hi all ,
can you please provide me some command to check the status of each node in oracle rac 11g
and status of clusterware and asm .

thanks
  • 1. Re: status of rac
    phaeus Pro
    Currently Being Moderated
    Hello,
    to check all resources you can use
    crs_stat -t
    or
    crsctl status res -t

    Depending on which 11g version you have, you find this commands in CRS_HOME/bin or in GRID_HOME/bin.

    You should see the status of all nodes and resource in your cluster.
  • 2. Re: status of rac
    damorgan Oracle ACE Director
    Currently Being Moderated
    What you are asking us to do is read the docs for you, distill it down to code samples, and then send them to you. And all that without knowing whether you have 9.2.0.1 or 11.2.0.3 or something else? And ...

    As opposed to you reading the docs?
    Or purchasing and reading a book?
    Or attending a conference?
    Or using google?

    So rather than just say "No" here is a link that may help:
    http://www.morganslibrary.org/reference/rac.html

    but I urge you to do what everyone else that is successful does ... put some effort into it.
  • 3. Re: status of rac
    phaeus Pro
    Currently Being Moderated
    status of each node in oracle rac 11g ....

    ???? 11g maybe 11gr2
  • 4. Re: status of rac
    864103 Newbie
    Currently Being Moderated
    thanks ,yes it's 11g.2
  • 5. Re: status of rac
    damorgan Oracle ACE Director
    Currently Being Moderated
    "Status" is a very small word that has absolutely no meaning whatsoever.

    Status of ASM? Do you mean is it online? Do you mean I/O performance? do you mean how full are the diskgroups?
    Status of CRM? Do you mean are the nodeapps up? Something else?
    Status of the cache fusion interconnect? Do you mean interconnect latency? Bytes per time period? Status of the bonding? Something else?
    Status of the database? Do you mean are the instances up? Has anything shot itself in the head lately? Remastering? Something else?
    Perhaps you would like to know whether the listeners are up and communicating? Or whether load balancing is working?

    Edited by: damorgan on Oct 16, 2012 11:56 AM
  • 6. Re: status of rac
    phaeus Pro
    Currently Being Moderated
    Hello,
    this should help you.
    http://askdba.org/weblog/2008/05/crsctl-cheatsheet-2/

    regards
    Peter
  • 7. Re: status of rac
    864103 Newbie
    Currently Being Moderated
    if you want really to help me , can you please provide me the answer of whole these question.thanks in advance.
  • 8. Re: status of rac
    damorgan Oracle ACE Director
    Currently Being Moderated
    The whole question has no meaning. It is roughly equivalent to "Please help me start my car."

    And we are asking you what kind of car and whether there is a specific issue like, perhaps, the battery is dead.

    There is no such thing as the status of a RAC node. Period. Exclamation mark. Your question, lacking context, has no meaning. I have no idea what RAC NODE STATUS means and I've personally built more than 500 clusters up to 24 nodes.

    If you define your terms we would be happy to help you. But the fact that something looks like a question does not make it answerable. For example:
    why does a mouse when it spins?
  • 9. Re: status of rac
    864103 Newbie
    Currently Being Moderated
    so can you tell me what's the target of each of the below command


    crsctl check cluster -all
    crs_stat -t
    crsctl status res -t

    or if you good link i will appreciate that .thanks in advance.

Legend

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