RMAN-04006: error from auxiliary database: ORA-01017: invalid username/password; logon denied

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>

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s