Getting Oracle XE to work with SpringFramework JDBC Template

July 30th, 2009 by Trent Leave a reply »

Ever get this error when using Oracle XE with SpringFramework JDBC Template?

SORA-12519, TNS:no appropriate service handler found

You can get around it by executing the following commands:

ALTER SYSTEM SET PROCESSES=150 SCOPE=SPFILE;
ALTER SYSTEM SET SESSIONS=100 SCOPE=SPFILE;

Then stop and start database (Oracle XE service) and you’re good to go!

Remember:

  • needs to be capitals,
  • needs to have both entries
  • stop and start the database (oracle XE service)

Got this from the following two resources:

http://en.newinstance.it/2007/06/01/ora-12519-tnsno-appropriate-service-handler-found/
http://forum.springsource.org/showthread.php?p=133267

Posted in Software development

Tags:

You can follow any responses to this entry through the RSS 2.0 Feed. You can leave a response , or trackback from your own site.

Advertisement

Leave a Reply