29 December 2012

Error 16191 PING[ARC2]: Heartbeat failed to connect to standby ORA-16191 ORA-01017 ORA-01031

Stand by Server alert log error:-


FAL[client, USER]: Error 16191 connecting to PRODNY for fetching gap sequence
Sat Dec 29 10:12:00 2012
Fetching gap sequence in thread 1, gap sequence 2192-2212
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
   
     

Primary Server Alert log error:-


PING[ARC2]: Heartbeat failed to connect to standby 'PRODVA'. Error is 16191.
Error 1017 received logging on to the standby
      returning error ORA-16191
PING[ARC2]: Heartbeat failed to connect to standby 'PRODVA'. Error is 16191.

Primary Server Trace file detail;-


OCISessionBegin failed -1
.. Detailed OCI error val is 1017 and errmsg is 'ORA-01017: invalid username/password; logon denied
'
OCISessionBegin failed. Error -1
.. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
'

*** 2012-12-29 08:00:10.260
OCISessionBegin failed. Error -1
.. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
'
*** 2012-12-29 08:00:10.261 4265 krsh.c
Error 1031 received logging on to the standby
*** 2012-12-29 08:00:10.261 912 krsu.c
Error 1031 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'PRODVA'
Error 1031 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'PRODVA'
*** 2012-12-29 08:00:10.261 4265 krsh.c
Error 1031 for archive log file 1 to 'PRODVA'
*** 2012-12-29 08:00:10.261 2864 krsi.c
krsi_dst_fail: dest:2 err:1031 force:0 blast:1
ORA-01031: insufficient privileges

Cause:-


Password file got correpted or Password changes in Primary and standby servers or we have to check sec_case_sensitive_logon parameter on primary and standby.

SQL> show parameter sec_case_sensitive_logon;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon             boolean     FALSE
SQL>

Solution:-


We have to recreate the passwd file or copy Primary server to Standby server.

Example:-


In cause sec_case_sensitive_logon parameter value is true, we have to use below orapwd command.

orapwd file=$ORACLE_HOME/dbs/orapwPROD password=muthu123 entries=10 ignorecase=y

In cause sec_case_sensitive_logon parameter value is false, we have to use below orapwd command.

orapwd file=$ORACLE_HOME/dbs/orapwPROD password=muthu123 entries=10

No comments: