OraFAQ Forum: Networking and Gateways » how to increase the processes in oracle10 (merged)

Home » RDBMS Server » Networking and Gateways » how to increase the processes in oracle10 (merged)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to increase the processes in oracle10 (merged) [message #407286]

Tue, 09 June 2009 07:48

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.

Report message to a moderator

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: 68641
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

Report message to a moderator

Re: how to increase the processes in oracle10 [message #407468 is a reply to message #407286]

Wed, 10 June 2009 05:24

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.

Report message to a moderator

how to increase the processes in oracle10 [message #407478 is a reply to message #407286]

Wed, 10 June 2009 05:30

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.

Report message to a moderator

Re: how to increase the processes in oracle10 [message #407479 is a reply to message #407478]

Wed, 10 June 2009 05:34

Michel Cadot
Messages: 68641
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

Report message to a moderator

Re: how to increase the processes in oracle10 [message #407610 is a reply to message #407479]

Wed, 10 June 2009 12:08

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

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

Then fix first.

Babu

Report message to a moderator

Previous Topic:	filter for listener
Next Topic:	Problem in Remote Connection

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 20 04:15:26 CDT 2024