My Oracle Support Banner

Unabe to Start Database With SRVCTL or SQL*Plus When Resource STATE shows 'MONITOR DISABLED' (Doc ID 2687531.1)

Last updated on NOVEMBER 15, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

Clusterware shows that the database instance  is running, but it's down, srvctl shows:

$ srvctl status database -d <DATABASE>
Instance <INSTANCE1> is running on node <NODE1>  
Instance <INSTANCE2> is running on node <NODE2>

trying to start the instance with SQL*Plus shows:

SQL> startup mount
ORA-39510: CRS error performing start on instance '<INSTANCE1> ' on '<NODE1>'
CRS-5702: Resource 'ora.<DATABASE>.db' is already running on '<NODE1>'
CRS-0223: Resource 'ora.<DATABASE>.db' has placement error.
clsr_start_resource:260 status:223
clsrapi_start_db:start_asmdbs status:223

The resource state information shows the resource in 'MONITOR DISABLED':

ora.<DATABASE>.db
     1        ONLINE  ONLINE       <NODE1>                MONITOR DISABLED,STABLE
     2        ONLINE  ONLINE       exa15<NODE2>db02       Open,HOME=<DIR>

 

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.