TNS Error on Oracle 10G Express

Hi,
I am trying to use 10G XE and all seems to work fine for a while until it starts to give me errors and I get the following in the listener log file.:

TNS-12516    TNS:listener could not find available handler with matching protocal stack.

If I restart the machine then it works fine again for a few hours but then the errors come back.

Does anyone have any ideas for me....

Here is a snippet of the listener.log file:

11-APR-2006 16:00:04 * service_update * xe * 0
11-APR-2006 16:00:32 * (CONNECT_DATA=(SERVICE_NAME=XE)(CID=(PROGRAM=c:\windows\system32\inetsrv\w3wp.exe)(HOST=M4)(USER=smo))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.5)(PORT=2992)) * establish * XE * 12516
TNS-12516: TNS:listener could not find available handler with matching protocol stack
11-APR-2006 16:00:36 * (CONNECT_DATA=(SERVICE_NAME=XE)(CID=(PROGRAM=c:\windows\system32\inetsrv\w3wp.exe)(HOST=M4)(USER=smo))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.5)(PORT=2993)) * establish * XE * 12516
TNS-12516: TNS:listener could not find available handler with matching protocol stack
11-APR-2006 16:00:56 * (CONNECT_DATA=(SERVICE_NAME=XE)(CID=(PROGRAM=c:\windows\system32\inetsrv\w3wp.exe)(HOST=M4)(USER=smo))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.5)(PORT=2995)) * establish * XE * 12516
TNS-12516: TNS:listener could not find available handler with matching protocol stack
11-APR-2006 16:02:04 * service_update * xe * 0
11-APR-2006 16:02:07 * service_update * xe * 0
LVL 1
jlinggAsked:
Who is Participating?
 
schwertnerCommented:
Increase the value for PROCESSES parameter in the SPFILE.

SQL>alter system set processes=250 scope=both;

0
 
jlinggAuthor Commented:
I have noticed in the log that in each line the port number used seems to increase. Does this mean the the application is continously opening new connections?
0
 
jlinggAuthor Commented:
Won't this just delay the error?  
0
 
schwertnerCommented:
No. This will extend the number of opened sessions allowed.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.