topic Oracle TNS errors when 100+ users query the database in Operating System - HP-UX

Oracle TNS errors when 100+ users query the database

Peter Hausken — Mon, 29 Jan 2001 17:08:20 GMT

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?

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

Rita C Workman — Mon, 29 Jan 2001 17:18:15 GMT

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

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

Berlene Herren — Mon, 29 Jan 2001 17:19:06 GMT

Increasing your swap space will prevent this error.

Berlene

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

Sree_2 — Thu, 08 Feb 2001 16:43:55 GMT

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