Search This Blog

Saturday, August 6, 2011

DATA GUARD LOG SHIPPING FAILS WITH ERROR ORA-16191 IN 11G

While configure physical standby database on 11gr1,11gr2 , data guard log shipping fails with error ORA-16191

Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE, 
and that the SYS password is same in the password files.
      returning error ORA-16191
------------------------------------------------------------
PING[ARC2]: Heartbeat failed to connect to standby 'proddg'. Error is 16191.

This error occur because i created password file on standby database via ORAPWD utility. but in 11g we just need to copy the password file from primary database to standby database because password must be identical on primary and standby db.

Solution:
1. copy the password file from primary db to standby db
or
2. turn off case sensitivity for password file authentication 
2.1 alter system set sec_case_sensitive_logon=false scope=both;
2.2 create new password file on primary and standby via ORAPWD utility

Metalink NOTE: ID 462219.1

2 comments:

Muhammad Abdul Halim said...

Thanks for this post. very nice. your blog is really updated and your are doing very well.

Regards
Muhammad Abdul Halim

Anonymous said...

Thanks Taj. Your this tip helped me today.