ORA-01017: invalid username/password; logon denied error during standby database creation
Posted by Pavan DBA on April 25, 2012
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.
As always don’t try this directly on a prod env, instead first test it…. HAPPY LEARNING
Pavan DBA's Blog 
sunil said
Hi Pavan,
It is nice and useful.
Hope this also be useful here.
https://ora-data.blogspot.in/2016/12/oracle-data-guard-concepts.html
Thanks,
habeeb awa said
RMAN-04006: error from auxiliary database: ORA-01017: invalid username/password; logon denied..
Hi Pavan Sir,
i am not sure why i am getting this. Where i am doing wrong. This is the result of the parameter….i copied the primary database password file to standby already. Please advise…Thanks
show parameter REMOTE_OS_AUTHENT;
remote_os_authent boolean FALSE
show parameter REMOTE_LOGIN_PASSWORD;
remote_login_passwordfile string EXCLUSIVE
Pavan DBA said
after copying password file,have you changed it according to standby instance name?
habeeb awa said
Yes Sir I do.
Pavan DBA said
plz send me steps you have followed to mymailbox.21@gmail.com. i will check
jaspreet matharu said
I faced this error many times but neither me nor mine any of the friends resolved it in correct way….
Nevertheless this resolution was awesome
Pavan DBA said
good to hear that