ORA-01017: invalid username/password; logon denied error during standby database creation

ORA-01017: invalid username/password; logon denied error during standby database creation

I faced a peculiar error while configuring dataguard today. When performed all steps and trying to connect to target and auxiliary databases, got the below error

[oracle@dbserver2 dbs]$ rman target sys/sys123@proddb auxiliary sys/sys123@standb

 

Recovery Manager: Release 10.2.0.1.0 – Production on Wed Apr 25 20:38:34 2012

 

Copyright (c) 1982, 2005, Oracle.  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

To resolve this I tried changing SYS user password so many times, recreated password file and copied that to standby, but nothing worked out.

Finally I resolved this by checking following parameters which are the culprtis in my case

REMOTE_LOGIN_PASSWORD

REMOTE_OS_AUTHENT

By default the above parameters should set to EXCLUSIVE and FALSE values respectively. But due to some reason, they are set to NONE and TRUE in my case. I changed them to EXCLUSIVE and FALSE then its resolved

Note: changing those parameter values need a restart of database.

So, when ever you face similar issue of invalid username/password during standby creation, check the above parameters and change the values (if needed) and try.