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@rac1 ~]$ srvctl status db -d rac12
Instance rac121 is running on node rac1
Instance rac122 is not running on node rac2
[oracle@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
/
/
/