Datasource state shows as RUNNING even if corresponding Database server is down (Doc ID 1307696.1)

Last updated on FEBRUARY 13, 2023

Applies to:

Symptoms

If a datasource is targeted to a managed server and the following operations are performed (in the same sequence):

1. Shutdown managed server.
2. Shutdown the database server (DB server).
3. Startup managed server.
4. DB server is still down.

The result will be :

• Managed server is started in RUNNING mode.
• Data source is accessible in the admin console (deployed).
• From administration console, data source shows  "State: RUNNING" and "Enabled: true" => this makes us think monitoring is broken.
• You will see following error in the corresponding server's log:
  

Even if a connection test (Data Source/Monitoring/Testing) is triggered, the test fails as expected with ORA-12521, but the monitoring still shows "State: RUNNING" and "Enabled: true" for this Data Source. This is not same as when DB server fails while WebLogic server is running (in which case the pool state is automatically changed to "Disabled").

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.