JBoss node throws oracle ORA-12520 error

Solution Unverified - Updated -

Environment

  • Red Hat JBoss Enterprise Application Platform (EAP)
    • 5.2
  • Red Hat JBoss SOA Platform (SOA-P)
    • 5.3.1

Issue

  • Below error message is reported in the server.log of JBoss EAP :
WARN  [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] (main) Throwable while attempting to get a new connection: null
org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Listener refused the connection with the following error:
ORA-12520, TNS:listener could not find available handler for requested type of server)
at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:225)
at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:195)
...
...
Caused by: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12520, TNS:listener could not find available handler for requested type of server
...
...
DEPLOYMENTS IN ERROR:
  Deployment "jboss:service=KeyGeneratorFactory,type=HiLo" is in error due to the following reason(s): oracle.net.ns.NetException: Listener refused the connection with the following error:
ORA-12520, TNS:listener could not find available handler for requested type of server

Resolution

Firstly one should be using the supported and certified DB version and its corresponding driver.
Check with the Database administrator if there has been any changes made to the TNS settings at the DB end.
One might also try increasing the number of processes on the DB to allow more concurrent connections from application deployed on JBoss.
An understanding of what processes are in Oracle DB are mentioned in link [1] .

[1] http://docs.oracle.com/cd/B19306_01/server.102/b14237/initparams169.htm

This solution is part of Red Hat’s fast-track publication program, providing a huge library of solutions that Red Hat engineers have created while supporting our customers. To give you the knowledge you need the instant it becomes available, these articles may be presented in a raw and unedited form.