[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1463
  • Last Modified:

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
0
jlingg
Asked:
jlingg
  • 2
  • 2
1 Solution
 
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
 
schwertnerCommented:
Increase the value for PROCESSES parameter in the SPFILE.

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

0
 
jlinggAuthor Commented:
Won't this just delay the error?  
0
 
schwertnerCommented:
No. This will extend the number of opened sessions allowed.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now