Skip to Main Content
  • Questions
  • Listener Error Related on Web Server

Breadcrumb

May 4th

Question and Answer

Connor McDonald

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