Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle TNS errors when 100+ users query the database

Peter Hausken
Occasional Contributor

Oracle TNS errors when 100+ users query the database

We just started production on Oracle 8.1.6 on HP-UX 11.0. All patches recomended by HP support installed. When the number of connections passes one-hundred and something we start to get the following messages from Oracle.

29-JAN-2001 14:22:13 * (CONNECT_DATA=(SID=mysid)(GLOBAL_NAME=my.world)(CID=(PROGRAM=myprog.exe)(HOST=Windows NT PC)(USER=myuser))) * (ADDRESS=(PROTOCOL=tcp)(HOST=1
0.10.10.60)(PORT=4338)) * establish * mysid * 12500

TNS-12500: TNS:listener failed to start a dedicated server process

TNS-12540: TNS:internal limit restriction exceeded

TNS-12560: TNS:protocol adapter error

TNS-00510: Internal limit restriction exceeded

HPUX Error: 12: Not enough space

This seems to be some parametre in HP-UX that is set to low. Any ideas?
3 REPLIES
Rita C Workman
Honored Contributor

Re: Oracle TNS errors when 100+ users query the database

TNS-00510 states there are too many files or sockets open simultaneously. So this may require an increase to the nfile (max # of open files) and with nfile I tend to also look at nproc and maxusers.

I have included a url to a very handy site that gives you the definition for these and Oracle error codes. Hope you find it as useful as I have...

http://www.cs.umbc.edu/help/oracle8/errmsg/A54625_01/toc.htm

/rcw
Berlene Herren
Honored Contributor

Re: Oracle TNS errors when 100+ users query the database

Increasing your swap space will prevent this error.

Berlene
http://www.mindspring.com/~bkherren/dobes/index.htm
Sree_2
Occasional Visitor

Re: Oracle TNS errors when 100+ users query the database

Did you try setting
chmod 4751 $ORACLE_HOME/bin/tnslsnr

Also make sure you started the listner as oracle s/w owner login and not as any other user