My Oracle Support Banner

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

Last updated on NOVEMBER 09, 2018

Applies to:

Oracle Weblogic Server - Version: 10.3.1 to 10.3.4
Information in this document applies to any platform.


If you have some datasource targeted to some managed server and if  you perform following operations (in same sequence):
  1. Shutdown managed server.
  2. Shutdown the database server (DB server).
  3. Startup managed server.
  4. DB server is still down.

Result will be :
####<Feb 21, 2011 11:17:46 PM IST> <Warning> <JDBC> <Test> <TestServer1><[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <> <1298310466219> <BEA-001129> <Received exception while creating connection for pool "DS1": Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor >

Even if we trigger a connection test (Data Source/Monitoring/Testing), 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 pool state is automatically changed to "Disabled").


To view full details, sign in with your My Oracle Support account.

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

In this Document

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