Error 1031 Received Logging On To The Standby
Contents |
ourselves. Always be positive and keep smiling..have a great day friends :) Source: Internet March 05,
Error 1031 Received Logging On To The Standby Ora-01031 Insufficient Privileges
2013 Error 1031 received logging on to the standby ISSUE Error error 1031 received logging on to the standby rac 1031 received logging on to the standby ORA-01031: insufficient privileges PING[ARC0]: Heartbeat failed to connect to error 1017 received logging on to the standby standby 'dgp'. Error is 1031. PRIMARY======= Primary database Alert log error:-------------------------------- Error 1031 received logging on to the standby ORA-01031: insufficient privileges PING[ARC0]: Heartbeat failed to connect
Error 1031 Virtual Driver Error
to standby 'dgp'. Error is 1031. Chech DR sync and see the difference. THREAD PR-ARCHIVED STBY-ARCHIVED STBY-APPLIED SHIPPING GAP(PR -> STBY) APPLIED GAP(STBY -> STBY) ------ ----------- ------------- ------------ ------------------------ ------------------------- set pages 999 lines 999 col MESSAGE for a100 select to_char(timestamp,'YYYY-MON-DD HH24:MI:SS')||' '||message||severity from gv$dataguard_status where severity in ('Error','Fatal') order by timestamp; show parameter
Error 12154 Received Logging On To The Standby
log_archive_dest_state_2; LISTNER VERIFICATION FROM PRIMATY DB ------------------------------------ select dest_id,status,error from v$archive_dest where dest_name='LOG_ARCHIVE_DEST_2'; FIND GAP -------- select thread#,low_sequence#,high_sequence# from gv$archive_log; ps -ef |grep tns lsnrctl status DR== DR database Alert log error: ---------------------------- Error 1031 received logging on to the standby set pages 999 lines 999 col MESSAGE for a100 select to_char(timestamp,'YYYY-MON-DD HH24:MI:SS')||' '||message||severity from gv$dataguard_status where severity in ('Error','Fatal') order by timestamp; select inst_id,process,status,thread#,sequence#,block#,blocks from gv$managed_standby; PROCESS STATUS ------- ------------ RFS IDLE RFS IDLE RFS IDLE MRP0 WAIT_FOR_LOG checking log transfer and apply ------------------------------- SELECT SEQUENCE#,FIRST_TIME,NEXT_TIME,APPLIED FROM gV$ARCHIVED_LOG ORDER BY SEQUENCE#; select count(*) from GV$ARCHIVED_LOG where applied='NO'; Redo transfer was not happening. When we checked in the v$managed_process data dictionary view, we could see that RFS was not starting. Here, ora-01031 usually appears when some sysdba session failes to authenticate 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
logging of LOG_ARCHIVE_DEST_2. Fri Nov 6 08:45:53 2009 Error 1031 received logging on to the error 12154 received logging on to the standby 11g standby Suppressing further error logging of LOG_ARCHIVE_DEST_2. Fri Nov 6
Error 1033 Received Logging On To The Standby
08:50:53 2009 Error 1031 received logging on to the standby Suppressing further error logging of LOG_ARCHIVE_DEST_2. error 12514 received logging on to the standby Fri Nov 6 08:55:53 2009 Error 1031 received logging on to the standby Suppressing further error logging of LOG_ARCHIVE_DEST_2. Fri Nov 6 09:00:04 2009 Thread http://select-star-from.blogspot.com/2013/03/error-1031-received-logging-on-to.html 1 advanced to log sequence 15599 Current log# 1 seq# 15599 mem# 0: /DDMESP_home2/oradata/ORAPMES/redo1a.log Current log# 1 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 https://anargodjaev.wordpress.com/2014/02/13/error-1031-received-logging-on-to-the-standby-2/ 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 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 connec
to check: Standby Server Check the status archive destination SQL> select status, error from v$archive_dest; http://jameskoopmann.blogspot.com/2014/01/oracle-data-guard-log-transport.html STATUS ERROR ----------------- -------------------- ERROR received logging ORA-01031: insufficient privileges Primary Server Check alert_log from background dump folder eg. bdump Error 1031 received logging on to the standby PING[ARC1]: Heartbeat failed to connect to standby 'PrimServ1'. Error is 1031. 2014-01-14 16:02:23.992000 -04:00 Error received logging on 1031 received logging on to the standby Check orapwd
on my primary (RAC) & forgetting about propogating (to 2 single node standbys) that change through the passwword files so that DG LTS would continue properly. The types of errors received in the alert log (on primary) consisted of three forms..at least in this situation: Tue Jan 21 20:15:08 2014 Error 1031 received logging on to the standby FAL[server, ARCb]: Error 1031 creating remote archivelog file 'orclstb1' FAL[server, ARCb]: FAL archive failed, see trace file. ARCH: FAL archive failed. Archiver continuing ORACLE Instance orclprim - Archival Error. Archiver continuing. Tue Jan 21 20:22:59 2014 Error 1031 received logging on to the standby PING[ARC8]: Heartbeat failed to connect to standby 'orclstb2'. Error is 1031. Error 1031 received logging on to the standby PING[ARC8]: Heartbeat failed to connect to standby 'orclstb1'. Error is 1031. Tue Jan 21 21:57:11 2014 Error 1031 received logging on to the standby to resolve, simply recreate the password file on each of my primary RAC nodes, using RAC primary node 1 for example: set env for instance using oraenv cd $ORACLE_HOME/dbs orapwd file=orapworclprim1 password=