|
| Re: how to increase the processes in oracle10 [message #407288 is a reply to message #407286] |
Tue, 09 June 2009 07:54   |
Michel Cadot
Messages: 28991
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
ORA-12519: TNS:no appropriate service handler found
*Cause: The listener could not find any available service handlers that
are appropriate for the client connection.
*Action: Run "lsnrctl services" to ensure that the instance(s) have
registered with the listener, and are accepting connections.
Regards
Michel
|
|
|
| Re: how to increase the processes in oracle10 [message #407468 is a reply to message #407286] |
Wed, 10 June 2009 05:24 |
shajat
Messages: 18
Registered: October 2008
Location: INDIA |
Junior Member |
|
|
Yes, I have already run "lsnrctl services". Then also I am getting the error. My v$resource_limit table contains
resource_name Processes
current_utilization 138
max_utilization 150
initial_allocation 150
limit_value 150
So, I want to increase the processes limit. Pl help me how to increase the processes.
|
|
|
| how to increase the processes in oracle10 [message #407478 is a reply to message #407286] |
Wed, 10 June 2009 05:30 |
shajat
Messages: 18
Registered: October 2008
Location: INDIA |
Junior Member |
|
|
Some times few of the clients are not connecting to oracle and we are getting error 12519.
I think, when processes utlization is reached to maximum utilization, I am getting the problem. If then how to increase the processes limit.
pl help me.
|
|
|
|
|
] 
Members
Search
Help
Register
Login
Home
