Home » RDBMS Server » Networking and Gateways » how to increase the processes in oracle10 (merged)
how to increase the processes in oracle10 (merged) [message #407286] Tue, 09 June 2009 07:48 Go to next message
shajat
Messages: 25
Registered: October 2008
Location: INDIA
Junior Member
Some times few of the clients are not connecting to oracle and we are getting error 12519


pls give the solution.
Re: how to increase the processes in oracle10 [message #407288 is a reply to message #407286] Tue, 09 June 2009 07:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
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 Go to previous messageGo to next message
shajat
Messages: 25
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 Go to previous messageGo to next message
shajat
Messages: 25
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.
Re: how to increase the processes in oracle10 [message #407479 is a reply to message #407478] Wed, 10 June 2009 05:34 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is useless and counter-productive to cross-post and repeat your questions.

Regards
Michel
Re: how to increase the processes in oracle10 [message #407610 is a reply to message #407479] Wed, 10 June 2009 12:08 Go to previous message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

>>I have already run "lsnrctl services". Then also I am getting the error

Then fix first.

Babu
Previous Topic: filter for listener
Next Topic: Problem in Remote Connection
Goto Forum:
  


Current Time: Fri Dec 09 21:35:38 CST 2016

Total time taken to generate the page: 0.16162 seconds