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

From: Franky Weber Faust <>
Date: Thu, 16 May 2019 16:59:11 -0400
Message-ID: <>

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 script from Fred Denis, but it is bash made and runs with Clusterware tools: We use it a lot here at Pythian.



On Thu, 16 May 2019 at 4:52 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*
> --

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

*Franky Weber Faust*
Oracle ACE ♠︎
<> 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*
* <>*

Received on Thu May 16 2019 - 22:59:11 CEST

Original text of this message