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

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.
    https://ora-data.blogspot.in/2016/12/oracle-data-guard-concepts.html

    Thanks,

  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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: