System intermittenly can access

[Fauziah Mahdan]

currently we have a new HP Itanium server running on 11.23 and oracle10g. This server is connected to our HP UX server (11.11) running on Oracle9i, to integrate data between the one in 10g db and 9i db. but, server of oracle9i is having problem, intermittently inaccessible when user from 11.23 accessing it. when check in the listener.log,

the error appear as follows:



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: 11: Resource temporarily unavailable

17-APR-2007 10:37:19 * (CONNECT_DATA=(SID=devp)(CID=(PROGRAM=oraclePROD6)(HOST=cgcdb6)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.1.1.16)(PORT=61064)) * establish * devp * 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: 11: Resource temporarily unavailable

17-APR-2007 10:37:25 * (CONNECT_DATA=(SID=devp)(CID=(PROGRAM=oraclePROD6)(HOST=cgcdb6)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.1.1.16)(PORT=61065)) * establish * devp * 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: 11: Resource temporarily unavailable

17-APR-2007 10:37:25 * (CONNECT_DATA=(SID=devp)(CID=(PROGRAM=oraclePROD6)(HOST=cgcdb6)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.1.1.16)(PORT=61066)) * establish * devp * 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: 11: Resource temporarily unavailable



what should we do to solve this problem?

[SANTOSH S. MHASKAR]

Hi,

Look following o/p of oerr

----------------------------------
[oracle@wfms1] $oerr tns 12500
12500, 00000, "TNS:listener failed to start a dedicated server process"
// *Cause: The process of starting up a dedicated server process failed.
// The executable could not be found or the environment may be set up
// incorrectly.
// *Action: Turn on tracing at the ADMIN level and reexecute the operation.
// Verify that the ORACLE Server executable is present and has execute
// permissions enabled. Ensure that the ORACLE environment is specified
// correctly in LISTENER.ORA. The Oracle Protocol Adapter that is being
// called may not be installed on the local hard drive. Please check that
// the correct Protocol Adapter are successfully linked.
// If error persists, contact Oracle Customer Support.


[oracle@wfms1] $oerr tns 12540
12540, 00000, "TNS:internal limit restriction exceeded"
// *Cause: Too many TNS connections open simultaneously.
// *Action: Wait for connections to close and re-try.


[oracle@wfms1] $oerr tns 12560
12560, 00000, "TNS:protocol adapter error"
// *Cause: A generic protocol adapter error occurred.
// *Action: Check addresses used for proper protocol specification. Before
// reporting this error, look at the error stack and check for lower level
// transport errors. For further details, turn on tracing and reexecute the
// operation. Turn off tracing when the operation is complete.


[oracle@wfms1] $oerr tns 510
00510, 00000, "Internal limit restriction exceeded"
// *Cause: Too many files or sockets open simultaneously (or some other
// resource has been depleted).
// *Action: For further details, trace the operation for protocol
// details.
---------------------------------------


If u see 1st error (TNS-12500), u just check
the oracle env of oracle in listener.ora for
that particular SID/Service in 9i server

Also increase process and sessions parameter of database.
-Santosh

[Yogeeraj_1]

hi,

The main cause of the problem is an insufficient OPEN FILES setting (the current value can be viewed with ulimit -a).

To implement the solution, execute the following steps:

1. Increase OPEN FILES, for example:

ulimit -n 4096

hope this helps!

kind regards
yogeeraj

[Rasheed Tamton]

I would suggest to check these kernel variables alsso

nproc
maxuprc


Rgds.