• Feed RSS


I was setting up a virtual machine with:
- Oracle database 10g Express Edition
- Oracle Oc4J (Oracle Containers for J2EE)
- Enterprise Application on OC4J accessing the local database

When I was testing the application, it started to throw errors on the init of the application (the application loads some highly-accessed information from DB to Cache on the init phase):

ORA-12519, TNS:no appropriate service handler found

As I was able to access the database both remotely and locally (through SQL*PLUS), after some research I found that the problem was due to a bug on Oracle DB Express Edition (XE)on how the connections are monitored.

  1. Change a system parameter: ALTER SYSTEM SET PROCESSES=150 SCOPE=SPFILE
  2. Restart database


Post a Comment