Database is falsely being shown as down in the console ORA-1033 (Doc ID 794195.1)

Last updated on JULY 07, 2016

Applies to:

Enterprise Manager Base Platform - Version 10.2.0.3 to 11.1.0.1 [Release 10.2 to 11.1]
Information in this document applies to any platform.
***Checked for relevance on 02-Apr-2012***
Checked for relevance on 05-Sep-2013

Symptoms

A 3 Node RAC database of 10.2.0.4 version on a Redhat 4 system is being monitored via the Grid Console.
This database also has a standby/DR setup in 10.2.0.4 database again on a Redhat 4
system

The names of the 3 RAC instances in the primary are : ABC1, ABC2, ABC3
Database Name : ABC

The names of the RAC instances in the standby are : ABC1
Database Name : STDB

In the grid console, there is an alert raised every few minutes that the ABC1 instance on the primary setup is down.
The availability details show that the agent connection to the instance is failing with

ORA-1033 :ORACLE initialization or shutdown in progress (DBD ERROR: OCISessionBegin)

But the instance is actually up and running and there are no problems connecting to it from sqlplus, as the user specified in the monitoring credentials for this database.
There are also no errors in the database alert.log file, which can indicate that this instance has
any problems.

The problem occurs intermittently and the alert gets automatically cleared after sometime.
But the alert raised is false and if notifications are enabled for this database availability state, then a corresponding notification will be sent as well.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms