Oracle Database Discussions

Hi,

When i say......set oracle_sid=pwdev and then SQLPLUS is working fine.
But when i say "rman target system/system@pwdev" it is giving below error:-


Recovery Manager: Release 9.2.0.6.0 - Production
Copyright (c) 1995, 2002, Oracle Corporation. 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

Please advice.....

Below is the output of lsnrctl status:-

LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC2)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 9.2.0.6.0 - Produc
tion
Start Date 04-JAN-2012 19:47:58
Uptime 4 days 19 hr. 27 min. 26 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File E:\Oracle\Ora9206\network\admin\listener.ora
Listener Log File E:\Oracle\Ora9206\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC2ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=gbmorast04.npil.com)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=gbmorast04.npil.com)(PORT=8080))(Pre
sentation=HTTP)(Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=gbmorast04.npil.com)(PORT=2100))(Pre
sentation=FTP)(Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=gbmorast04.npil.com)(PORT=8080))(Pre
sentation=HTTP)(Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=gbmorast04.npil.com)(PORT=2100))(Pre
sentation=FTP)(Session=RAW))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "pwdev.emea.pfizer.com" has 2 instance(s).
Instance "pwdev", status UNKNOWN, has 1 handler(s) for this service...
Instance "pwdev", status READY, has 1 handler(s) for this service...
Service "twdevXDB.emea.pfizer.com" has 1 instance(s).
Instance "pwdev", status READY, has 1 handler(s) for this service...
Service "pwval.emea.pfizer.com" has 2 instance(s).
Instance "pwval", status UNKNOWN, has 1 handler(s) for this service...
Instance "pwval", status READY, has 2 handler(s) for this service...
Service "pwvalXDB.emea.pfizer.com" has 1 instance(s).
Instance "pwval", status READY, has 1 handler(s) for this service...
The command completed successfully


Two database reside in this server...