Pavan DBA's Blog

The DBA Knowledge Store

Posts Tagged ‘ora-01017’

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 – 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


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

Posted in Dataguard | Tagged: , , , | 7 Comments »

%d bloggers like this: