$ 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.
