Hi

I had a look at this and in my opinion your initialization file should contain the db_file_name_convert parameter and you should reduce your coding

db_file_name_convert =
(
'/u02/oradata/MPRTEST' , '/u02/oradata/TEST226' ,
'/u03/oradata/MRPTEST' , '/u03/oradata/TEST226' ,
'/u04/oradata/MRPTEST' , '/u04/oradata/TEST226' ,
'/u05/oradata/MRPTEST' , '/u05/oradata/TEST226' ,
'/u07/oradata/MRPTEST' , '/u07/oradata/TEST226'
)


regarding the error
ORA-12523: TNS:listener could not find instance appropriate for the client connection

whats the output of

lsnrctl services

Are you able to connect to target and auxillary instances using sqlplus ?

sqlplus "sys/change_on_install@TEST226 as sysdba"

If you not then try changing the SID to service name in listener.ora and the reloading the listener.

The key thing is you should get the listener file working correctly and should be able to connect to both auxillary and source(Target database as oracle calls it) before you proceed with cloning

i.e both the following commands should work
sqlplus "sys/change_on_install@TEST226 as sysdba"
sqlplus "sys/change_on_install@MPRTEST as sysdba"

regards
Hrishy