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 DECEMBER 19, 2016

Applies to:

Oracle Platform Security for Java - Version 12.1.3.0.0 and later
Information 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
.>

 

 

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