Data Guard Log Shipping Fails With Error Ora-16191 In 11g

Issue:

PING[ARC1]: Heartbeat failed to connect to standby ‘STANDBY’. Error is 16191.

Sat Aug 06 02:06:52 2011

Error 1017 received logging on to the standby

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

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

Things Verified :

1. Create password file for sys in both primary and standby

2. Login as a sys from primary to standby and vice versa

Sqlplus sys@STANDBY as sysdba

3. tnsping also works from primary to standby and vice versa

Solution :

In 11g oracle comes with the strong password authentication, so we have to use ignorecase parameter while creating password file in both primary and standby, otherwise we have to set SEC_CASE_SENSITIVE_LOGON=FALSE (Dynamic parameter).

1. orapwd file=orapw$ORACLE_SID password=***** entries=5 ignorecase=Y

2. alter system set SEC_CASE_SENSITIVE_LOGON=FALSE scope=both;