Re: Checking if a RAC database has one or more node down

I don’t think there is a way of doing that if you don’t have your databases registered in OEM. If you do have then you could query the OEM database. Other option You can use is rac-status.sh script from Fred Denis, but it is bash made and runs with Clusterware tools: https://github.com/freddenis/oracle-scripts/blob/master/rac-status.sh We use it a lot here at Pythian.

Regards,

Franky

On Thu, 16 May 2019 at 4:52 PM Luis Santos <lsantos_at_pobox.com> 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*
>
> --

*Kind regards / Cordialmente / Saludos cordiales / Sincères amitiés / Mit freundlichen Grüßen / Cordiali saluti,*

*Franky Weber Faust*
Oracle ACE ♠︎
<https://apex.oracle.com/pls/apex/f?p=19297:4:::NO:4:P4_ID:17002> Oracle Database SQL Certified Expert
Oracle Database 11g Administrator Certified Associate Oracle Database 12c Administrator Certified Professional Oracle Real Application Clusters 12c Certified Implementation Specialist Oracle Real Application Clusters 12c Sales Specialist Oracle Real Application Clusters 12c PreSales Specialist Oracle Linux 6 Certified Implementation Specialist Oracle Linux 6 Sales Specialist
Oracle Linux 6 PreSales Specialist

*Cel: +55 47 99125-2714*
*Skype: franky.faust*
*www.loredata.com.br <http://www.loredata.com.br/>*

--
http://www.freelists.org/webpage/oracle-l