Database is falsely being shown as down in the console ORA-1033
Last updated on JANUARY 13, 2018
Applies to:Enterprise Manager Base Platform - Version 10.2.0.3 to 220.127.116.11 [Release 10.2 to 11.1]
Information in this document applies to any platform.
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
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
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
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.
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