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-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
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
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