Oracle Database Express Edition (XE)

Dear All,

I hope this mail finds you and yours in cheer and in good spirit.

We are using following resources for a web-based application

Data Base: Oracle 10g Express Edition

Web Server: Tomcat 5.0

Programming Language: Java

This application running well for some time after that we are getting the following error
Listener refused the connection with the following error:
ORA-12519, TNS:no appropriate service handler found
The Connection descriptor used by the client was:
127.0.0.1:1521:XE

This problem disappears if I restart the tomcat but application is running into the same problem after sometime.

We have tried the following solutions

· Increasing the Session and Process in Oracle’s “init.ora” file

· Open and close the connection as the need arises

· Creating one connection per session

· Using Connection Pooling

But None of them did not solve the problem .

Could you please help us to identify the problem and solving it?




Thanks a lot for reading my query and advance thanks for your reply

With THanks and Regards

G P P