Databases
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