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!!!!
