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

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

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

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;