Re: Checking if a RAC database has one or more node down
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Thu, 16 May 2019 17:06:00 -0400
Message-ID: <929ee488-c780-3ac5-8142-34160167aca2_at_gmail.com>
Date: Thu, 16 May 2019 17:06:00 -0400
Message-ID: <929ee488-c780-3ac5-8142-34160167aca2_at_gmail.com>
You should do select inst_id,status from gv$instance. This is the result:
SQL> select inst_id,status from gv$instance;
INST_ID STATUS
---------- ------------
1 OPEN
[oracle_at_rac1 ~]$ srvctl status db -d rac12
Instance rac121 is running on node rac1
Instance rac122 is not running on node rac2
[oracle_at_rac1 ~]$
Oracle is correctly showing only one instance.
On 5/16/19 4:51 PM, Luis Santos wrote:
> Is there a way, using just SQL when connected to a RAC Oracle database
> (whatever the version), to check if all nodes are up and runing?
>
> /--/
> /Att/
> /Luis Santos
>
> /
> /
> /
-- Mladen Gogala Database Consultant Tel: (347) 321-1217 -- http://www.freelists.org/webpage/oracle-lReceived on Thu May 16 2019 - 23:06:00 CEST