1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

RAC: Check Health of Nodes and offline nodes

Discussion in 'Server Administration and Options' started by StryderKC, Feb 10, 2009.

  1. StryderKC

    StryderKC Active Member

    Likes Received:
    Trophy Points:
    I have tried a number of ways to do this and have met a brick wall with each method I've tried. Here's what I'm trying to do:

    We have a monitoring tool from which we can run scripts. I ultimately want to know there are X, Y, and Z servers configured to support a given service, and right now X, and Y are up (or Z is down).

    I can get all of the nodes running a service with the following:
    Code (Text):

    select a.host_name
    from gv$instance a, gv$active_services s
    where a.inst_id = s.inst_id
    and s.name = '{service_name}';
    ... but this does not tell me if there are nodes offline.

    The solution can be shell, SQL, or a combination of both - but if I had my preference it would be pure SQL.

    Any ideas or has anyone else solved this?
  2. tyro

    tyro Forum Genius

    Likes Received:
    Trophy Points:
    try the command
    Code (Text):
    crs_stat -t
    This prints a list of available services per host with the status showing ONLINE/OFFLINE status. You can then use the output of this in your application.