News
Perth, Australia
+ (61) 417713124
prosolutions@gavinsoorma.com

11g RMAN Duplicate from Active Database and ORA-01017

  • Posted by Gavin Soorma
  • On September 8, 2010
  • 0 Comments
  • ORA-01017, ORA-17627, ORA-17629

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.

 

0 Comments

Leave Reply

Your email address will not be published. Required fields are marked *