Home » RDBMS Server » Networking and Gateways » Re: listener could not find available handler for requested type of server (oracle 10g lunix)  () 1 Vote
Re: listener could not find available handler for requested type of server [message #467672] Mon, 26 July 2010 10:12 Go to next message
bnrk1212
Messages: 12
Registered: May 2010
Location: Kigali/RWANDA
Junior Member

hi Guys

i have a problem with LSNS can some one help me on this issue

[oracle@tdevrhel ~]$ rman catalog rman/rman@catalog target sys/dbpw@target

Recovery Manager: Release 10.2.0.1.0 - Production on Mon Jul 26 07:40:58 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-12520: TNS:listener could not find available handler for requested type of server
[oracle@tdevrhel ~]$


thx
Re: Re: listener could not find available handler for requested type of server [message #467673 is a reply to message #467672] Mon, 26 July 2010 10:24 Go to previous messageGo to next message
Michel Cadot
Messages: 59080
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-12520: TNS:listener could not find available handler for requested type of server
 *Cause: None of the known and available service handlers for requested type
 of server (dedicated or shared) are appropriate for the client connection.
 *Action: Run "lsnrctl services" to ensure that the instance(s) have
 registered with the listener and that the appropriate handlers are
 accepting connections.

Regards
Michel
Re: Re: listener could not find available handler for requested type of server [message #467757 is a reply to message #467673] Tue, 27 July 2010 02:58 Go to previous messageGo to next message
bnrk1212
Messages: 12
Registered: May 2010
Location: Kigali/RWANDA
Junior Member

Yes i run it and i get the following error :

Service "+ASM" has 1 instance(s).
Instance "+ASM2", status BLOCKED, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "+ASM_XPT" has 1 instance(s).
Instance "+ASM2", status BLOCKED, has 1 handler(s) for this service...
Handler(s):

"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Re: Re: listener could not find available handler for requested type of server [message #467850 is a reply to message #467757] Tue, 27 July 2010 13:04 Go to previous messageGo to next message
BlackSwan
Messages: 22780
Registered: January 2009
Senior Member
check article 240710.1 for more details.
Re: Re: listener could not find available handler for requested type of server [message #467990 is a reply to message #467850] Wed, 28 July 2010 07:45 Go to previous messageGo to next message
bnrk1212
Messages: 12
Registered: May 2010
Location: Kigali/RWANDA
Junior Member

how to check articles (240710.1)
Re: Re: listener could not find available handler for requested type of server [message #467993 is a reply to message #467990] Wed, 28 July 2010 08:21 Go to previous messageGo to next message
Michel Cadot
Messages: 59080
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This article is in on Metalink.

Regards
Michel
Re: Re: listener could not find available handler for requested type of server [message #468028 is a reply to message #467993] Wed, 28 July 2010 11:30 Go to previous messageGo to next message
bnrk1212
Messages: 12
Registered: May 2010
Location: Kigali/RWANDA
Junior Member

ok thx for the support but i don't have access on metalink 240710.1

plse if you can assist me on this issue i will be happy and you will be praised
Re: Re: listener could not find available handler for requested type of server [message #468093 is a reply to message #468028] Wed, 28 July 2010 19:48 Go to previous message
BlackSwan
Messages: 22780
Registered: January 2009
Senior Member
http://www.idevelopment.info/data/Oracle/DBA_tips/Automatic_Storage_Management/ASM_45.shtml
Previous Topic: Frequent disconnection between client and database
Next Topic: ORA-12547 in my case
Goto Forum:
  


Current Time: Tue Sep 16 05:19:25 CDT 2014

Total time taken to generate the page: 0.10130 seconds