[Solved] ORA-12519, TNS:no appropriate service handler found

You might have come across this Oracle error while working with you database app connected to a Oracle 10g XE database.

ORA-12519, TNS:no appropriate service handler found

java.sql.SQLException: Listener refused the connection with the following error:

ORA-12519, TNS:no appropriate service handler found

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113)

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:263)

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:389)

at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:454)

at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)

at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)

at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:802)

 

 

This is how to get rid of it. Open the sqlplus command line and set the processes and scope values as below. (and restart Oracle)

 

ALTER SYSTEM SET PROCESSES=150 SCOPE=SPFILE;

That's it!!!!