Recently while performing an 11g Release 2 Active Database duplication, I encountered an error which one would normally associate with password files and the fact that the SYS password is not the same on the source and target databases.
RMAN-03002: failure of Duplicate Db command at 09/01/2010 09:17:39
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 09/01/2010 09:17:39
ORA-17629: Cannot connect to the remote database server
ORA-17627: ORA-01017: invalid username/password; logon denied
ORA-17629: Cannot connect to the remote database server
Apparently, if we are performing an active database duplication via RMAN, we cannot connect to the target database using OS authentication like ‘ target /’.
We need to fully qualify the connection to the target database with the SYS user and password like ‘target sys/syspassword’ and not just ‘target /’.
I found a few links which discuss the same topic and thanks for the solution which I am sharing with the community.
http://kr.forums.oracle.com/forums/thread.jspa?threadID=959655
http://www.freelists.org/post/oracle-l/ORA01031-with-RMAN-Duplicate,1
Not too sure if this a 11g Release 2 issue as I had performed a 11g release 1 create standby database from active primary database (read about it) and used the ‘target /’ to connect to the source database.
