Pavan DBA's Blog

The DBA Knowledge Store

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

7 Responses to “ORA-01017: invalid username/password; logon denied error during standby database creation”

  1. sunil said

    Hi Pavan,
    It is nice and useful.

    Hope this also be useful here.


  2. 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

  3. 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

Leave a Reply

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

You are commenting using your 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

%d bloggers like this: