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_S
Yet another blog for dba's. Shared my work experience here. Hope it will be useful for you guys all.