"Cannot retrieve connection list" Encountered on the Discoverer 11g Connection Page
(Doc ID 1317534.1)
Last updated on DECEMBER 03, 2019
Applies to:
Oracle Discoverer - Version 11.1.1.2.0 to 11.1.1.7.0 [Release 11g]Information in this document applies to any platform.
***Checked for relevance on 23-Oct-2017***
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.
- 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.
- 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
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |