Error 1017 Received Logging On To The Standby
Contents |
standby 'STBYKOL'. Error is 1034) Hi Guys, Here is an Interesting case and I was stuck with the error 1017 received logging on to the standby ora 16191 problem since last 2 days and a half. In fact
Error 1017 Received Logging On To The Standby 11g
I was almost done with everything to resolve the mentioned problem but I could not able
Ora 16191 Primary Log Shipping Client Not Logged On Standby
to solve almost. Then I left it as I became exhausted, But I kept on thinking Where could be the problem, at last I got it. Here
Error 1031 Received Logging On To The Standby
was my case: -------------------- I have 2 node rac as primary and a standby was intended to create on single node. I changed parameter file, created passwords, tns entries accordingly. Then I did duplicate target and restored database as standby. After doing everything I saw, RAC node1 was able to send archive error 12154 received logging on to the standby logs to dest_2 which is my standby but unfortunately node2 was unable to enter into standy database. Here are Problem Statement: ---------------------------- Standby was receiving node1's log files but node2 was unable to send logfiles due to the below error 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. Steps for diagnosing ---------------------------- step-1 when I checked query on node 2 sql>select DEST_ID,DEST_NAME,STATUS,BINDING,ERROR from v$ARCHIVE_DEST where status<>'INACTIVE'; all log file location were valid Sql> SELECT DESTINATION, STATUS, ERROR FROM V$ARCHIVE_DEST WHERE DEST_ID=2; dest2 for archive log dest is valid sql> select error_code,message from v$dataguard_status; Error 1034 received logging on to the standby PING[ARC2]: Heartbeat failed to connect to standby 'STBYDB'. Error is 1034. Then I have done the below steps to resolve the problem 1.) alter system set log_archive_dest_state_2
:: Message Navigator E-mail to friend Standby database error: primary failed to connect to standby [message #321206] Mon, 19 May 2008 07:29 tomvdduin Messages: 3Registered: May 2008 Location: Huizen Junior Member This is my error 12154 received logging on to the standby rac first attempt to create a standby server configuration. I don't know what I'm error 1031 received logging on to the standby ora-01031 insufficient privileges doing wrong, but this is what I'm doing: primary database: - perform command 'alter database begin backup' - perform command error 12514 received logging on to the standby 'alter database create standby controlfile as '
logging of LOG_ARCHIVE_DEST_2. Fri Nov 6 08:45:53 2009 Error 1031 received logging on https://anargodjaev.wordpress.com/2014/02/13/error-1031-received-logging-on-to-the-standby-2/ to the standby Suppressing further error logging of LOG_ARCHIVE_DEST_2. Fri Nov 6 08:50:53 2009 Error 1031 received logging on to the standby Suppressing further http://kb.dbatoolz.com/tp/3572.password_file_for_standby_and_primary.html error logging of LOG_ARCHIVE_DEST_2. 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 received logging 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 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 received logging on 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 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 sta
community › Ask DBA › Question Id: 3572 | Permalink password file for standby and primary Question ID: 3572 Created By: 2009-FEB-25 14:53:53 [Davikm15] Updated By: 2009-FEB-26 07:40:06 [Davikm15] Status: Open Severity: Normal Read Only: No 10031 2009-FEB-25 14:53:53 Davikm15 User Registered On: Feb 2009 Total Posts: 2 Hi my question is simple but I having problems with the password file. Should the file name of the password file be the same on both the standy and primary? I have verified that the sys passwords are the same for both DB's. My error is below: Thanks for the help. Wed Feb 25 14:39:00 2009 Errors in file /Panera/Production/Apps11i/10.2.0/admin/ENT02_dbdev/bdump/ent02_arcl_23940.trc: ORA-16191: Primary log shipping client not logged on standby PING[ARCl]: Heartbeat failed to connect to standby 'ENT02DG'. Error is 16191. Wed Feb 25 14:44:00 2009 Errors in file /Panera/Production/Apps11i/10.2.0/admin/ENT02_dbdev/bdump/ent02_arcl_23940.trc: ORA-01017: invalid username/password; logon denied Wed Feb 25 14:44:00 2009 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 ------------------------------------------------------------ 10036 2009-FEB-25 17:01:39 Vitaliy Moderator Registered On: Mar 2006 Total Posts: 347 It's funny because when I went to check on my test standby / primary I had exact same issue! (My test standby database was down for over 6 months ...) ## on ZEPHIR (PRIMARY) I got the following error: ## Wed Feb 25 14:26:20 2009 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 ------------------------------------------------------------ ## from the 10gr2_arc0_27565.trc trace file (on PRIMARY) ## Error 16191 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'rightcube' Error 16191 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'rightcube' *** 2009-02-25 14:36:21.311 61287 kcrr.c PING[ARC0]: Heartbeat failed to connect to standby 'rightcube'. Error is 16191. *** 2009-02-25 14:36:21.311 59530 kcrr.c kcrrfail: dest:2 err:16191 force:0 bla