Thanks for the question, Truc.
Asked: September 19, 2016 - 6:22 pm UTC
Last updated: September 20, 2016 - 5:33 pm UTC
Version: Oracle 12.1.0.1.0
Viewed 1000+ times
You Asked
Hello Chris, Conner and Tom,
I am building two Apache/jBoss servers. These servers are connected to an Oracle database server version 12.1.0.1.0 on Windows 2012.
1. Web server one:
The website is up and connected to the database. However, the server log shows these errors every day:
2016-09-19 00:00:26,554 WARN JCA PoolFiller [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] [:] Unable to fill pool
org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Listener refused the connection with the following error:
ORA-12519, TNS:no appropriate service handler found
)
at org.jboss.resource.adapter.jdbc.xa.XAManagedConnectionFactory.getXAManagedConnection(XAManagedConnectionFactory.java:465)
at org.jboss.resource.adapter.jdbc.xa.XAManagedConnectionFactory.createManagedConnection(XAManagedConnectionFactory.java:409)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:633)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.fillToMin(InternalManagedConnectionPool.java:541)
at org.jboss.resource.connectionmanager.PoolFiller.run(PoolFiller.java:74)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12519, TNS:no appropriate service handler found
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:412)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:531)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:221)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:503)
at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:280)
at oracle.jdbc.xa.client.OracleXADataSource.getPooledConnection(OracleXADataSource.java:466)
at oracle.jdbc.xa.client.OracleXADataSource.getXAConnection(OracleXADataSource.java:154)
at oracle.jdbc.xa.client.OracleXADataSource.getXAConnection(OracleXADataSource.java:128)
at org.jboss.resource.adapter.jdbc.xa.XAManagedConnectionFactory.getXAManagedConnection(XAManagedConnectionFactory.java:449)
... 5 more
2. Web server two:
The website is not up and has the same error descriptions.
3. Listener.ora
The bottom three parameters were entered automatically:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\Oracle\ora121)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\Oracle\ora121\bin\oraclr12.dll")
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = "Oracle Server Name")(PORT = 1521))
)
)
LISTENER_INSTANCE_NAME1 =
(ADDRESS = (PROTOCOL = TCP)(HOST = Oracle Server Name)(PORT = 1521))
)
)
LISTENER_INSTANCE_NAME2 =
(ADDRESS = (PROTOCOL = TCP)(HOST = Oracle Server Name)(PORT = 1521))
)
)
LISTENER_INSTANCE_NAME3 =
(ADDRESS = (PROTOCOL = TCP)(HOST = Oracle Server Name)(PORT = 1521))
)
)
4. TNSNames.ora
These parameters were entered automatically:
LISTENER_INSTANCE_NAME1 =
(ADDRESS = (PROTOCOL = TCP)(HOST = Oracle Server Name)(PORT = 1521))
LISTENER_INSTANCE_NAME2 =
(ADDRESS = (PROTOCOL = TCP)(HOST = Oracle Server Name)(PORT = 1521))
LISTENER_INSTANCE_NAME3 =
(ADDRESS = (PROTOCOL = TCP)(HOST = Oracle Server Name)(PORT = 1521))
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
I tested the connection to the database both locally and remotely via SQL Plus/SQL Developer, they were just fine.
I don't see these errors on Oracle 11g but on 12c. I am not sure if these errors are caused by Java/Apache/jBoss servers.
Can you please help?
Thank you.
Truc
and Connor said...
Check your database alert logs as well. This error can be caused if you have exhausted all the sessions/processes on your database server.
v$resource_limit will tell you how close you are running to the limits
Is this answer out of date? If it is, please let us know via a Comment