Could someone review my RMAN Duplicate Command Syntax?

[mpoisson]

Since my last post I've broken up the script into two parts:

rest_226_from_t.sh

cd /u01/app/oracle/admin/MPRTEST/scripts/RMAN
pwd
export ORACLE_SID=MPRTEST
env
rman target / catalog radmin/change_on_install@rcat CMDFILE rest_226_from_t.res LOG duptest.log
echo "Done!"

rest_226_from_t.res

connect auxiliary sys/change_on_install@TEST226;
run {
set newname for datafile '/u02/oradata/MPRTEST/system01.dbf' TO '/u02/oradata/TEST226/system01.dbf';
set newname for datafile '/u03/oradata/MPRTEST/undotbs01.dbf' TO '/u03/oradata/TEST226/undotbs01.dbf';
set newname for datafile '/u04/oradata/MPRTEST/ADBASE_01.dbf' TO '/u04/oradata/TEST226/ADBASE_01.dbf';
set newname for datafile '/u07/oradata/MPRTEST/ADBASE_BI_01.dbf' TO '/u07/oradata/TEST226/ADBASE_BI_01.dbf';
set newname for datafile '/u05/oradata/MPRTEST/ADBASE_BI_IDX_01.dbf' TO '/u05/oradata/TEST226/ADBASE_BI_IDX_01.dbf';
set newname for datafile '/u04/oradata/MPRTEST/CWMLITE_01.dbf' TO '/u04/oradata/TEST226/CWMLITE_01.dbf';
set newname for datafile '/u05/oradata/MPRTEST/indx01.dbf' TO '/u05/oradata/TEST226/indx01.dbf';
set newname for datafile '/u07/oradata/MPRTEST/ODM_01.dbf' TO '/u07/oradata/TEST226/ODM_01.dbf';
set newname for datafile '/u04/oradata/MPRTEST/PGL_01.dbf' TO '/u04/oradata/TEST226/PGL_01.dbf';
set newname for datafile '/u07/oradata/MPRTEST/tools01.dbf' TO '/u07/oradata/TEST226/tools01.dbf';
set newname for datafile '/u04/oradata/MPRTEST/users_01.dbf' TO '/u04/oradata/TEST226/users_01.dbf';
set newname for datafile '/u07/oradata/MPRTEST/ADBASE_BLOB_01.dbf' TO '/u07/oradata/TEST226/ADBASE_BLOB_01.dbf';


duplicate target database to TEST226 nofilenamecheck;
}


TEST226 has been stated in NOMOUNT mode.

When I run it, I get the following error:

MACTIVET:/home/oracle>cat duptest.log

.
.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-04006: error from auxiliary database: ORA-12523: TNS:listener could not fin
d instance appropriate for the client connection

Recovery Manager complete.

If I STARTUP the auxiliary database and it's mounted, then I get the error:

Starting Duplicate Db at 27-AUG-07
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 08/27/2007 15:18:30
RMAN-05500: the auxiliary database must be not mounted when issuing a DUPLICATE
command

Recovery Manager complete.
MACTIVET:/home/oracle>


I don't get it because if the TEST226 instance is started up normally, then I can connect to it, query it, etc.

I'm stumped as to why I'm getting the listener error. Here are the contents of my listener.ora and tnsnames.ora on the server where both instances reside:

listener.ora
# LISTENER.ORA Network Configuration File: /u01/app/oracle/product/9.2.0/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = MACTIVET)(PORT = 1521))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/9.2.0)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = MPRTEST)
(ORACLE_HOME = /u01/app/oracle/product/9.2.0)
(SID_NAME = MPRTEST)
)

(SID_DESC =
(GLOBAL_DBNAME = TEST226)
(ORACLE_HOME = /u01/app/oracle/product/9.2.0)
(SID_NAME = TEST226)
)
(SID_DESC =
(GLOBAL_DBNAME = RCAT)
(ORACLE_HOME = /u01/app/oracle/product/9.2.0)
(SID_NAME = RCAT)
)
)
tnsnames.ora
# TNSNAMES.ORA Network Configuration File: /u01/app/oracle/product/9.2.0/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = MACTIVEP)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)

MPR =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.9.204.89)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = MPR)
)
)

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

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

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

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