Oracle Database Discussions

Dear All,

I am facing a strange problem since yesterday and it happened for 4 times now.

My database is 10gR2 and Linux is the operating system.

There is not much load on DB but some users while connecting to DB get this error:

ORA-12519 TNS : No appropriate service handler found.

Howe ever there existing sessions remain open and they are fine. Problem is only faced when the new connection if in process.

I think that maybe some procedure is opening up connection in loop and not closing it at the end, but how to find this procedure.

This is the output of my processes parameter:

SQL> show parameter PROCESSES;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 0
db_writer_processes integer 1
gcs_server_processes integer 0
job_queue_processes integer 10
log_archive_max_processes integer 2
processes integer 150


Kindly help.

Regards, Imran Baig