aspose file tools*
The moose likes JDBC and the fly likes JDBC connection issue with RAC database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC connection issue with RAC database" Watch "JDBC connection issue with RAC database" New topic
Author

JDBC connection issue with RAC database

Santhosh ayiappan
Ranch Hand

Joined: Jan 30, 2007
Posts: 80

Hi All,

We have 11gR2 RAC database and using the SCAN name. When I try to connect using the SQL plus, it works fine for me. But When i try to connect to the database from the java code, getting the below exception.

java.sql.SQLException: Listener refused the connection with the following error:
ORA-12519, TNS:no appropriate service handler found

at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:199)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:480)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:413)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:508)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:203)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:510)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at oracleConnection.main(oracleConnection.java:19)
Caused by: oracle.net.ns.NetException: Listener refused the connection with the following error:
ORA-12519, TNS:no appropriate service handler found

at oracle.net.ns.NSProtocol.connect(NSProtocol.java:361)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:966)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:292)
... 7 more


This might sound like a issue at the Database side, but not able to convince the DBA since it is working properly through SQLPLUS.

any help would be greatly appreciated.
Juanjo Cuadrado
Greenhorn

Joined: Jun 27, 2011
Posts: 18


Hi,

did you just tried this?

http://www.atpeaz.com/index.php/2010/fixing-the-ora-12519-tnsno-appropriate-service-handler-found-error/

P.D.
Courtesy of Google ORA-12519
Santhosh ayiappan
Ranch Hand

Joined: Jan 30, 2007
Posts: 80

Still getting the same issue. No luck
Juanjo Cuadrado
Greenhorn

Joined: Jun 27, 2011
Posts: 18

No luck? What was the problem?
Santhosh ayiappan
Ranch Hand

Joined: Jan 30, 2007
Posts: 80

Still getting the same exception . Raised a SR with Oracle . Hoping to get the resolution quickly because it blocks the application from going live.

~Santhosh
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBC connection issue with RAC database