OPSS - Unable Start Admin Server observing Pool opss-data-source is Suspended, cannot allocate resources to applications ORA-12505
(Doc ID 2214723.1)
Last updated on MARCH 01, 2023
Applies to:
Oracle Platform Security for Java - Version 12.1.3.0.0 and laterInformation in this document applies to any platform.
Symptoms
Unable Start Admin Server observing the next error:
Error Code: 0
Call: SELECT t1.JPS_ATTRS_ID, t1.ATTRNA..........
............
Caused by: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: weblogic.jdbc.extensions.PoolDisabledSQLException: weblogic.common.resourcepool.ResourceDisabledException: Pool opss-data-source is Suspended, cannot allocate resources to applications..
.............
<Nov 17, 2016 4:30:31 PM PST> <Notice> <Log Management> <BEA-170027> <The server has successfully established a connection with the Domain level Diagnostic Service.>
<Nov 18, 2016 4:20:54 PM PST> <Error> <JDBC> <BEA-001112> <Test "SELECT 1 FROM DUAL" set up for pool "opss-audit-DBDS" failed with exception: "java.sql.SQLRecoverableException: No more data to read from socket".>
<Nov 18, 2016 4:20:54 PM PST> <Warning> <JDBC> <BEA-001129> <Received exception while creating connection for pool "opss-audit-DBDS": Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
.>
...............
<Nov 18, 2016 4:21:19 PM PST> <Error> <JDBC> <BEA-001112> <Test "SELECT 1 FROM DUAL" set up for pool "opss-audit-viewDS" failed with exception: "java.sql.SQLRecoverableException: No more data to read from socket".>
<Nov 18, 2016 4:21:19 PM PST> <Warning> <JDBC> <BEA-001129> <Received exception while creating connection for pool "opss-audit-viewDS": Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
.>
............
<Nov 18, 2016 4:21:39 PM PST> <Error> <JDBC> <BEA-001112> <Test "SELECT 1 FROM DUAL" set up for pool "opss-data-source" failed with exception: "java.sql.SQLRecoverableException: No more data to read from socket".>
<Nov 18, 2016 4:21:39 PM PST> <Warning> <JDBC> <BEA-001129> <Received exception while creating connection for pool "opss-data-source": Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
.>
Call: SELECT t1.JPS_ATTRS_ID, t1.ATTRNA..........
............
Caused by: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: weblogic.jdbc.extensions.PoolDisabledSQLException: weblogic.common.resourcepool.ResourceDisabledException: Pool opss-data-source is Suspended, cannot allocate resources to applications..
.............
<Nov 17, 2016 4:30:31 PM PST> <Notice> <Log Management> <BEA-170027> <The server has successfully established a connection with the Domain level Diagnostic Service.>
<Nov 18, 2016 4:20:54 PM PST> <Error> <JDBC> <BEA-001112> <Test "SELECT 1 FROM DUAL" set up for pool "opss-audit-DBDS" failed with exception: "java.sql.SQLRecoverableException: No more data to read from socket".>
<Nov 18, 2016 4:20:54 PM PST> <Warning> <JDBC> <BEA-001129> <Received exception while creating connection for pool "opss-audit-DBDS": Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
.>
...............
<Nov 18, 2016 4:21:19 PM PST> <Error> <JDBC> <BEA-001112> <Test "SELECT 1 FROM DUAL" set up for pool "opss-audit-viewDS" failed with exception: "java.sql.SQLRecoverableException: No more data to read from socket".>
<Nov 18, 2016 4:21:19 PM PST> <Warning> <JDBC> <BEA-001129> <Received exception while creating connection for pool "opss-audit-viewDS": Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
.>
............
<Nov 18, 2016 4:21:39 PM PST> <Error> <JDBC> <BEA-001112> <Test "SELECT 1 FROM DUAL" set up for pool "opss-data-source" failed with exception: "java.sql.SQLRecoverableException: No more data to read from socket".>
<Nov 18, 2016 4:21:39 PM PST> <Warning> <JDBC> <BEA-001129> <Received exception while creating connection for pool "opss-data-source": Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
.>
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 |
| Cause |
| Solution |