Could someone review my RMAN Duplicate Command Syntax?

[mpoisson]

Hi Hrishy,

The status displays as blocked (see below). When the instance is up and running it looks like the others. It's in a startup / nomount mode.

lsnMACTIVET:/home/oracle>lsnrctl status

LSNRCTL for Solaris: Version 9.2.0.7.0 - Production on 28-AUG-2007 10:47:43

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Solaris: Version 9.2.0.7.0 - Production
Start Date 18-JUN-2006 09:21:31
Uptime 436 days 1 hr. 26 min. 11 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /u01/app/oracle/product/9.2.0/network/admin/listener.o
ra
Listener Log File /u01/app/oracle/product/9.2.0/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=MACTIVET)(PORT=1521)))
Services Summary...
Service "MPRBI" has 1 instance(s).
Instance "MPRBI", status READY, has 1 handler(s) for this service...
Service "MPRTEST" has 2 instance(s).
Instance "MPRTEST", status UNKNOWN, has 1 handler(s) for this service...
Instance "MPRTEST", status READY, has 2 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "RCAT" has 2 instance(s).
Instance "RCAT", status UNKNOWN, has 1 handler(s) for this service...
Instance "RCAT", status READY, has 2 handler(s) for this service...
Service "TEST226" has 1 instance(s).
Instance "TEST226", status BLOCKED, has 1 handler(s) for this service...
The command completed successfully
MACTIVET:/home/oracle>

I can hit the target no problem with SQL Plus, but not the auxiliary:

SQL> connect sys/change_on_install@TEST226 as sysdba;
ERROR:
ORA-12523: TNS:listener could not find instance appropriate for the client
connection


SQL>

The entry in LISTENER.ORA is as follows:

(SID_DESC =
(GLOBAL_DBNAME = TEST226)
(ORACLE_HOME = /u01/app/oracle/product/9.2.0)
(SID_NAME = TEST226)
)


The SID_NAME matches the SERVICE_NAME in TNSNAMES.ORA


TEST226 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = MACTIVET)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = TEST226)

I changed the entry in LISTENER.ORA to

SERVICE_NAME = TEST226

from

SID_NAME = TEST226

I'm still seeing a status of blocked. Thanks again for all of your help with this.