RMAN ORA-17629

RMAN active database duplicate fails with ORA-17627 ORA-17629 [ID 1268962.1]

Goal

RMAN active database duplicate fails with
ORA-17627: ORA-01017: invalid username/password; logon denied
ORA-17629: Cannot connect to the remote database server

Fix

Connect to target and auxiliary database by explicitly providing username and password along with a TNS alias as below.

$ rman target <username>/<password>@<tns_alias> auxiliary=username/password@<tns_alias>

Prerequisites Specific to Active Database Duplication

When you connect RMAN to the source database as TARGET, you must specify a password, even if RMAN uses operating system authentication. The source database must be mounted or open. If the source database is open, then archiving must be enabled. If the source database is not open, and if it is not a standby database, then it must have been shut down consistently.

When you connect RMAN to the auxiliary database instance, you must provide a net service name. This requirement applies even if the auxiliary instance is on the local host.

The source database and auxiliary instances must use the same SYSDBA password, which means that both instances must already have password files. You can create the password file with a single password so you can start the auxiliary instance and enable the source database to connect to it.