Cause:
While try to connect to auxiliary instance for rman duplication , i cant connec standby database due to credential issue. As the standby database is new and there is no user ,we should use the password file of primary database on the standby
[oracle@orcl ~]$ rman target sys/password auxiliary sys/password@orcldgp
Recovery Manager: Release 12.1.0.2.0 - Production on Fri Jun 18 18:39:18 2021
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1559282684)
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04006: error from auxiliary database: ORA-01017: invalid username/password; logon denied
Copy the password file of primary to standby database $ORACLE_HOME/dbs location
[oracle@orcl ~]$ echo $ORACLE_HOME
/oracle/base/product/12.1.0/dbhome_1
[oracle@orcl ~]$ scp /oracle/base/product/12.1.0/dbhome_1/dbs/orapworcl oracle@192.168.56.123:/oracle/base/product/12.1.0/dbhome_1/dbs/
oracle@192.168.56.123's password:
orapworcl 100% 7680 7.5KB/s 00:00
Modify the file name with standby database name
[oracle@orcldg dbs]$ mv orapworcl orapworcldgp
[oracle@orcldg dbs]$ pwd
/oracle/base/product/12.1.0/dbhome_1/dbs
Post that i can able to connect with sys user on auxiliary instance
[oracle@orcl ~]$ rman target sys/password auxiliary sys/password@orcldgp
Recovery Manager: Release 12.1.0.2.0 - Production on Fri Jun 18 18:42:04 2021
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1559282684)
connected to auxiliary database: ORCLDGP (not mounted)
RMAN>
