"Cannot retrieve connection list" Encountered on the Discoverer 11g Connection Page (Doc ID 1317534.1)

Last updated on FEBRUARY 21, 2016

Applies to:

Oracle Discoverer - Version 11.1.1.1.0 to 11.1.1.7.0 [Release 11g]
Information in this document applies to any platform.

Symptoms

When attempting to start Discoverer Plus / Viewer 11g session the Connection page displays the below error instead of the expected defined Public and Private connections.

A connection error.
 - error while creating the session, check for other errors.
  - oracle.discoiv.connections.ConnectionStoreException: weblogic.common.resourcepool.ResourceDeadException: 0: Could not connect to 'oracle.jdbc.OracleDriver'. The returned message is: ORA-01017: invalid username/password; logon denied It is likely that the login or password is not valid. It is also possible that something else is invalid in the configuration or that the database is not available.
  - weblogic.common.resourcepool.ResourceDeadException: 0: Could not connect to 'oracle.jdbc.OracleDriver'. The returned message is: ORA-01017: invalid username/password; logon denied It is likely that the login or password is not valid. It is also possible that something else is invalid in the configuration or that the database is not available.
   - weblogic.common.resourcepool.ResourceDeadException: 0: Could not connect to 'oracle.jdbc.OracleDriver'. The returned message is: ORA-01017: invalid username/password; logon denied It is likely that the login or password is not valid. It is also possible that something else is invalid in the configuration or that the database is not available.
unable to retrieve connection list
- Cannot retrieve connection list. Check the Discoverer application log for more details.


Other issues that can cause the Discoverer connections not to be displayed:

A connection error.
 - error while creating the session, check for other errors.
  - oracle.discoiv.connections.ConnectionStoreException: weblogic.common.resourcepool.ResourceDisabledException: Pool xyz_DEV_DISCOVERER_PS is Suspended, cannot allocate resources to applications..
  - weblogic.common.resourcepool.ResourceDisabledException: Pool xyz_DEV_DISCOVERER_PS is Suspended, cannot allocate resources to applications..
   - weblogic.common.resourcepool.ResourceDisabledException: Pool xyz_DEV_DISCOVERER_PS is Suspended, cannot allocate resources to applications..
unable to retrieve connection list
- Cannot retrieve connection list. Check the Discoverer application log for more details.

Changes

The database password for the <user_prefix>_DISCOVERER_PS user was recently changed/expired, or the user is suspended.

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