OraFAQ Forum: Networking and Gateways » Re: listener could not find available handler for requested type of server

Home » RDBMS Server » Networking and Gateways » Re: listener could not find available handler for requested type of server (oracle 10g lunix) (

) 1 Vote

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

Re: listener could not find available handler for requested type of server [message #467672]

Mon, 26 July 2010 10:12

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

Report message to a moderator

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

Michel Cadot
Messages: 68745
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

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

Report message to a moderator