AHF - Autonomous Health Framework (TFA - ORACHK) (MOSC)

MOSC Banner

RDBMS showing as down, but is up

Environment:

RHEL 6

RDBMS Version: 11.2.0.4

CRS Version 11.2.0.4

OraCHK Version 12.2.0.1.1

 

Situation:

 

This is a single instance Active Data Guard Standby that was recently built, it uses ASM.  Setting RAT_DBNAMES, RAT_DB, RAT_ORACLE_HOME and RAT_INV_LOC does not resolve the issue.

 

Host Name  CRS Installed  ASM HOME       RDBMS Installed  CRS UP    ASM UP    RDBMS UP  DB Instance Name

-------------------------------------------------------------------------------------------------------

<redacted>    No              Yes             Yes             No         Yes      No

 

 

hostname[db]: ps -ef|grep pmon

oracle   18098     1  0 Jul25 ?        00:12:03 asm_pmon_+ASM

oracle   41121     1  0 Sep23 ?        00:04:48 ora_pmon_db

 

SQL:SYS@db> select open_mode,controlfile_type from v$database;

 

 

OPEN_MODE            CONTROL

-------------------- -------

READ ONLY WITH APPLY STANDBY

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center