Error 1031 Connecting To Destination
Contents |
logging of LOG_ARCHIVE_DEST_2. Fri Nov 6 08:45:53 2009 Error 1031 received logging on to the standby Suppressing further error logging of LOG_ARCHIVE_DEST_2. Fri Nov error 1031 received logging on to the standby rac 6 08:50:53 2009 Error 1031 received logging on to the standby Suppressing ping arc2 heartbeat failed to connect to standby error is 1031 further error logging of LOG_ARCHIVE_DEST_2. Fri Nov 6 08:55:53 2009 Error 1031 received logging on to the standby heartbeat failed to connect to standby error is 1033 Suppressing further error logging of LOG_ARCHIVE_DEST_2. Fri Nov 6 09:00:04 2009 Thread 1 advanced to log sequence 15599 Current log# 1 seq# 15599 mem# 0: /DDMESP_home2/oradata/ORAPMES/redo1a.log Current log# 1 error 1034 received logging on to the standby seq# 15599 mem# 1: /DDMESP_home4/oradata/ORAPMES/redo1b.log Fri Nov 6 09:00:53 2009 Error 1031 received logging on to the standby Suppressing further error logging of LOG_ARCHIVE_DEST_2. Fri Nov 6 09:01:24 2009 WARNING: inbound connection timed out (ORA-3136) Fri Nov 6 09:01:32 2009 WARNING: inbound connection timed out (ORA-3136) OR Errors in file c:\oracle\product\10.2.0\admin\lims\bdump\lims_arc1_2756.trc: ORA-01017: invalid username/password; logon denied Sun Jul 20
Error 1033 Received Logging On To The Standby
05:08:19 2008 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 OR *** 2008-07-20 21:47:24.812 *** SERVICE NAME:() 2008-07-20 21:47:24.781 *** SESSION ID:(156.1) 2008-07-20 21:47:24.781 Redo shipping client performing standby login OCISessionBegin failed -1 .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges ' *** 2008-07-20 21:47:25.046 62692 kcrr.c Error 1031 received logging on to the standby Error 1031 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'to_prod' Error 1031 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'to_prod' ORA-01031: insufficient privileges *** 2008-07-20 21:47:25.062 62692 kcrr.c PINGARC1: Heartbeat failed to connect to standby 'to_prod'. Error is 1031. *** 2008-07-20 21:47:25.062 60970 kcrr.c kcrrfail: dest:2 err:1031 force:0 blast:1 Solution : 1. REMOTE_LOGIN_PASSWORDFILE configured to SHARED or EXCLUSIVE 2. Recreate the password file on the standby database to have the same sys password as the primary database. OR Copy the password from Primary server
error:- FAL[client, USER]: Error 16191 connecting to PRODNY for fetching gap sequenceSat Dec 29 10:12:00 2012Fetching gap sequence in http://muthuappsdba.blogspot.com/2012/12/error-16191-pingarc2-heartbeat-failed.html thread 1, gap sequence 2192-2212Error 1017 received logging on to the standby------------------------------------------------------------Check that the primary and standby are using a password fileand remote_login_passwordfile is set to SHARED http://oraclecorner.blogspot.com/2014/07/potential-bug-in-11202.html 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 received logging to standby 'PRODVA'. Error is 16191.Error 1017 received logging on to the standby returning error ORA-16191PING[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 received logging on error val is 1031 and errmsg is 'ORA-01031: insufficient privileges'*** 2012-12-29 08:00:10.260OCISessionBegin 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.cError 1031 received logging on to the standby*** 2012-12-29 08:00:10.261 912 krsu.cError 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.cError 1031 for archive log file 1 to 'PRODVA'*** 2012-12-29 08:00:10.261 2864 krsi.ckrsi_dst_fail: dest:2 err:1031 force:0 blast:1ORA-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 FALSESQL> 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=yIn cause sec_case_sensitive_logon parameter value is false, we have to use be
simple procedure. Error After changing SYS password on 11.2.0.2 database, we started receiving errors ORA-1017 ORA-1031 ORA-16373 ORA-16778 ORA-16810 We scp-ed the password file from RAC production nodes to DR nodes, and restarted the DG log apply, as per normal process. Data Guard started failing intermittently, with files not being applied on either of an instance thread for hours, hearbeat and HC were failing. Database use ASYNC log applym has sec_case_sensitive_logon=TRUE, no dedicated redo_transport_user user and only SYS is in pwfile. Note: 11.2.0.3 or 11.2.0.4 databases didn't have the same issue, which initially got us thinking that it was a 11.2.0.2 related bug, but it turned out to be a problem with scp. Fix Simon checksum-ed oracle password file with "sum" command, and discovered that scp-ed files had a different check-sum. He took the valid orapw file and scp-ed to the other production node and two DR nodes, checksum-ed, restarted log apply and Data Guard started working. 2014-07-14 16:24:46.042 00000000 1856455312 DMON: Database DBDR_A returned ORA-16664 2014-07-14 16:24:46.042 00000000 1856455312 for opcode = HEALTH_CHECK, phase = BEGIN, req_id = 1.1.1856455312 .... .... 2014-07-14 15:18:38.033 RSM detected log transport problem: log transport for database 'DBDR_A' has the following error. 2014-07-14 15:18:38.033 ORA-01031: insufficient privileges 2014-07-14 15:18:38.034 RSM0: HEALTH CHECK ERROR: ORA-16737: the redo transport service for standby database "DBDR_A" has an error 2014-07-14 15:18:38.297 00000000 1856454759 Operation HEALTH_CHECK canceled during phase 2, error = ORA-16778 2014-07-14 15:18:38.300 00000000 1856454759 Operation HEALTH_CHECK canceled during phase 2, error = ORA-16810 *** 2014-07-14 15:20:51.155 4265 krsh.c Error 1031 received logging on to the standby *** 2014-07-14 15:20:51.155 912 krsu.c Error 1031 connecting to destination LOG_ARCHIVE_DE