Error 1031 Received Logging On To The Standby Oracle
Contents |
free to correct me if I'm making some mistakes in this blog. Pages Home My Profile error 1031 received logging on to the standby rac Sunday, April 1, 2012 Steps to resolve Error 1031 received logging
Error 1031 Received Logging On To The Standby Ora-01031 Insufficient Privileges
on to the standby Case Study. today, I would like to discuss about a typical issue
Error 12514 Received Logging On To The Standby Oracle
faced on our environment. One of our DataGuard environment was out of sync. Since the gap was too much time we decided to use the incremental recovery method and resolve
Error 12154 Received Logging On To The Standby
the gap . The issue faced even though be resolved the gap, the subsequent redo transfer was not happening. When we checked in the v$managed_process data dictionary view, we could see that RFS was not starting. Analysis The following observations were made. The RFS process was not started in the standby which indicatesthat standby is not receiving any redo information error 12154 received logging on to the standby 11g from the primary. In the primary alert log file we could see the errors indicating that the primary is not able to communicate with the standby instance.The error observed was "Error 1031 received logging on to the standby". We tried to connect to the standby instance from primary by using the following command and it was successful. sqlplus sys/oracle@tns. the time stamp of the password file on the primary and the standby was different. This indicated the possibility of having the wrong password file in the standby. solution we copied the password file from the primary to the standby and renamed the password file in the following format ie orapw
if you see messages similar error 1033 received logging on to the standby to the following in the alert log file of error 12541 received logging on to the standby your Primary database, there could be multiple reasons for these errors. ######################################### Error error 12528 received logging on to the standby 1031 received logging on to the standby PING[ARC1]: Heartbeat failed to connect to standby 'mydb_standby'. Error is 1031. ######################################### OR######################################### Error 1031 received http://alazydbasblog.blogspot.com/2012/04/steps-to-resolve-error-1031-received.html logging on to the standby FAL[server, ARC2]: Error 1031 creating remote archivelog file 'mydb_standby' FAL[server, ARC2]: FAL archive failed, see trace file. ARCH: FAL archive failed. Archiver continuing ORACLE Instance mydb - Archival Error. Archiver continuing. ######################################### OR ######################################### Wed Jan 21 13:22:49 2015 Error 1031 http://salmandba.blogspot.com/2015/01/error-1031-received-logging-on-to.html received logging on to the standby Errors in file /u01/app/oracle/diag/rdbms/mydb_prim/mydb/trace/mydb_arc1_2334.trc: ORA-01031: insufficient privileges FAL[server, ARC3]: FAL archive failed, see trace file. ######################################### In my experience, there are 2 major causes of these errors. I will be discussing both in the following Difference in Password file This is mandatory to have same password file on both primary and standby database server. You should make sure that once you build your standby database, you copy the password file from primary database to the standby database. There could also be a possibility that password file on standby server isaccidentallydeleted or you might have recreated the passwordfile using orapwd utility - in either of the case, you canright awaycopy the passwordfile from primary to the standby database server. Location of password file is%ORACLE_HOME%\database on Windowsplatform and $ORACLE_HOME/dbs on U
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank https://community.oracle.com/thread/3618547?start=15&tstart=0 message. Please type your message and try again. More discussions in Data Guard All PlacesDatabasePerformance & AvailabilityData Guard This discussion is archived 1 2 3 Previous Next 32 Replies Latest reply on Oct 16, 2014 7:40 AM by Jr.raj Go to original post This content has been marked as final. Show 32 replies 15. Re: Error 1033 received logging on to the standby Jr.raj Oct 13, 2014 1:51 PM (in received logging response to Jr.raj) Hi CKPT, i have copied password files from primary nodes to standby nodes respectively. current content of primary's alert logfile(last 100 lines) $ tail alert_test1.log -n 100 Error 1033 received logging on to the standby Mon Oct 13 07:53:46 2014 Error 1033 received logging on to the standby Mon Oct 13 07:54:48 2014 Error 1033 received logging on to the standby Mon Oct 13 07:55:50 2014 received logging on Error 1033 received logging on to the standby Mon Oct 13 07:56:53 2014 Error 1033 received logging on to the standby Mon Oct 13 07:57:55 2014 Error 1033 received logging on to the standby Mon Oct 13 07:58:57 2014 Error 1033 received logging on to the standby Mon Oct 13 07:59:59 2014 Error 1033 received logging on to the standby Mon Oct 13 08:01:02 2014 Error 1033 received logging on to the standby Mon Oct 13 08:02:04 2014 Error 1033 received logging on to the standby Mon Oct 13 08:02:27 2014 Error 1033 received logging on to the standby Mon Oct 13 08:02:28 2014 Thread 1 advanced to log sequence 2115 (LGWR switch) Current log# 1 seq# 2115 mem# 0: +DATA/test/onlinelog/group_1.312.849710537 Current log# 1 seq# 2115 mem# 1: +RECO/test/onlinelog/group_1.901.849710537 Mon Oct 13 08:02:28 2014 Archived Log entry 8029 added for thread 1 sequence 2114 ID 0xf5850205 dest 1: Mon Oct 13 08:05:38 2014 *********************************************************************** Fatal NI connect error 12170. VERSION INFORMATION: TNS for Linux: Version 11.2.0.4.0 - Production Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production Time: 13-OCT-2014 08:05:38