Data guard wonderful ORA-16191: Primary log shipping client not logged on standby Problem

After creating a data gurad and switchover, check the Configuration:

SQL> select dest_name, status, error from V $ archive_dest where rownum <3;

 

Dest_name status Error

------------------------------------------------------------

Log_archive_dest_1 valid

Log_archive_dest_2 error ORA-16191: Primary log shipping client not logged on standby

 

ORA-16191 error reported.

 

The Alert Log information is as follows:

 

 

------------------------------------------------------------

Ping [arc2]: Heartbeat failed to connect tostandby 'Dave '. error is 16191.

Thu Jul 18 21:41:20 2013

Error 1017 received logging on to thestandby

------------------------------------------------------------

Check that the primaryand standby are using a password file

Andremote_login_passwordfile is set to shared or exclusive,

And that the Sys passwordis same in the password files.

Returning error ORA-16191

 

The error is very clear about the password file.

 

Check that the remote_login_passwordfile parameter is correct. Then, the password file is rebuilt using the orapwd command on all nodes, and an error is still returned.

[Oracle @ davedbs] $ orapwd file = $ ORACLE_HOME/dbs/orapwdave1 Password = Oracle

[Oracle @ davedbs] $ orapwd file = $ ORACLE_HOME/dbs/orapwdave2 Password = Oracle

 

 

You cannot use alter user to recreate the password.

 

Finally, a password file is created in the master database, and then the password file is transferred to other nodes and rename. After a few minutes, it will be okay to query again.

 

Let's make a note to avoid your next meeting.

 

 

 

 

 

Bytes --------------------------------------------------------------------------------------------

All rights reserved. reprinted articles are allowed, but source addresses must be indicated by links. Otherwise, the documents will be held legally responsible!

QQ: 251097186

Skype: tianlesoftware

Email: tianlesoftware@gmail.com

Blog: http://blog.csdn.net/tianlesoftware

WEAVER: http://weibo.com/tianlesoftware

Twitter: http://twitter.com/tianlesoftware

Facebook: http://www.facebook.com/tianlesoftware

LinkedIn: http://cn.linkedin.com/in/tianlesoftware