The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle listener problem

Highlighted
Leep
Regular Collector

Oracle listener problem

Hi!
Does anyone have any ideas about this? At that time the performance is very bad. We restart services on the application then the problem is solved.
----------------------------------------------
17-OCT-2006 08:41:50 * (CONNECT_DATA=(SID=p1)(CID=(PROGRAM=)(HOST=__jdbc__)(USER
=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.240.42.140)(PORT=61361)) * establis
h * p1 * 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-OCT-2006 08:41:50 * (CONNECT_DATA=(SID=p1)(CID=(PROGRAM=)(HOST=__jdbc__)(USER
=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.240.42.140)(PORT=61362)) * establis
h * p1 * 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
--------------------------------------------

Many thanks,
Lee
1 REPLY
Tim Schmitt_4
Frequent Visitor

Re: Oracle listener problem

Below is the info & corrective actions that can be taken about this error:

TNS-12540/ORA-12540: TNS:internal limit restriction exceeded and TNS-00510: Internal limit restriction exceeded
Cause: An internal limit has been exceeded. Possible limits include:
Number of open connection that Oracle Net can process simultaneously

Number of memory buffers which can be used simultaneously

Number of processes a particular database instance is allowed

The first two are examples of hard limits. The third is an example of a limit which can be increased by setting PROCESSES parameter in the database initialization file to a larger value. In this case, a TNS-12500/ORA-12500 error is also returned. In some cases, these errors can be caused by the same conditions which cause TNS-12549/ORA-12549 and TNS-00519 errors.

Action: Perform these steps:
Wait for the open connections to close and retry. If the error persists, then check the sqlnet.log or listener.log file for detailed error stack information.
//Add this to "OnDomLoad" event