ORA_01017: Invalid username/password error while creating a standby database

Issue: ORA_01017: Invalid username/password error while creating a standby database

$ rman TARGET sys/change_on_install@TEST

Recovery Manager: Release 11.2.0.4.0 - Production on Fri Oct 24 15:24:44 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-01017: invalid username/password; logon denied

Though I changed the passwords and recreated the password file in primary and copied back to standby server, still i received the invalid username and password on the standy

Solution:


SQL> show parameter REMOTE_LOGIN_PASSWORD

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile            string      NONE

SQL> show parameter REMOTE_OS_AUTHENT

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
remote_os_authent                    boolean     FALSE
SQL>


The parameter remote_login_password file should be set to exclusive. Changed the value to EXCLUSIVE in primary and restarted the database

SQL> alter system set remote_login_passwordfile='EXCLUSIVE' scope=spfile;

System altered.


SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 2405122048 bytes
Fixed Size                  2255592 bytes
Variable Size             503317784 bytes
Database Buffers         1895825408 bytes
Redo Buffers                3723264 bytes
Database mounted.
Database opened.
SQL>

Now the rman command duplicate target database for standby works fine.