Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
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.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
cancel
Showing results for 
Search instead for 
Did you mean: 

System intermittenly can access

Fauziah Mahdan
Super Advisor

System intermittenly can access

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?
3 REPLIES
SANTOSH S. MHASKAR
Trusted Contributor

Re: System intermittenly can access

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
Honored Contributor

Re: System intermittenly can access

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Rasheed Tamton
Honored Contributor

Re: System intermittenly can access

I would suggest to check these kernel variables alsso

nproc
maxuprc


Rgds.