Error 12637 Received Logging On To The Standby
Contents |
17, 2015DatabaseOracleopenwares 本来DG已经配置为最大可用模式(maximize availability)了,也就是说如果物理备库无法访问,不应该影响主库的运行才对。 但是有一条光纤物理链路出现故障严重丢包,导致主库向其传输归档日志时出现超时错误,无法归档,导致主库运行十分缓慢,直至无法正常访问。 alert_orcl.log文件中有如下错误记录: Fri Jul 17 00:34:32 2015 ORA-16198: LGWR received timedout error from KSR LGWR: Attempting destination LOG_ARCHIVE_DEST_3 network reconnect error 12154 received logging on to the standby (16198) LGWR: Destination LOG_ARCHIVE_DEST_3 network reconnect abandoned Fri Jul 17 00:34:32 error 12154 received logging on to the standby 11g 2015 Errors in file e:\oracle\product\10.2.0\admin\orcl\bdump\orcl_lgwr_1568.trc: ORA-16198: Timeout incurred on internal channel during remote archival LGWR: Network
Error 12154 Received Logging On To The Standby Rac
asynch I/O wait error 16198 log 1 service 'db_feich' Fri Jul 17 00:34:32 2015 Destination LOG_ARCHIVE_DEST_3 is UNSYNCHRONIZED LGWR: Failed to archive log 1 thread 1 sequence
Error 1031 Received Logging On To The Standby
4526 (16198) Fri Jul 17 00:34:32 2015 Errors in file e:\oracle\product\10.2.0\admin\orcl\bdump\orcl_lgwr_1568.trc: ORA-16198: Timeout incurred on internal channel during remote archival LGWR: Error 16198 closing archivelog file 'db_feich' LGWR: Error 16198 disconnecting from destination LOG_ARCHIVE_DEST_3 standby host 'db_feich' Fri Jul 17 00:34:42 2015 LGWR: Standby redo logfile selected to archive thread 1 sequence 4527 LGWR: Standby error 1031 received logging on to the standby ora-01031 insufficient privileges redo logfile selected for thread 1 sequence 4527 for destination LOG_ARCHIVE_DEST_2 Fri Jul 17 00:34:43 2015 Thread 1 advanced to log sequence 4527 (LGWR switch) Current log# 2 seq# 4527 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG Fri Jul 17 00:37:18 2015 LGWR: Standby redo logfile selected to archive thread 1 sequence 4528 LGWR: Standby redo logfile selected for thread 1 sequence 4528 for destination LOG_ARCHIVE_DEST_2 Fri Jul 17 00:37:18 2015 Thread 1 advanced to log sequence 4528 (LGWR switch) Current log# 3 seq# 4528 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG Fri Jul 17 00:40:00 2015 LGWR: Standby redo logfile selected to archive thread 1 sequence 4529 LGWR: Standby redo logfile selected for thread 1 sequence 4529 for destination LOG_ARCHIVE_DEST_2 Fri Jul 17 00:40:00 2015 Thread 1 advanced to log sequence 4529 (LGWR switch) Current log# 1 seq# 4529 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG Fri Jul 17 00:40:05 2015 ARC1: LGWR is actively archiving destination LOG_ARCHIVE_DEST_3 ARC1: Standby redo logfile selected for thread 1 sequence 4528 for destination LOG_ARCHIVE_DEST_3 Fri Jul 1
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 message. Please
Error 1033 Received Logging On To The Standby
type your message and try again. More discussions in Data Guard All PlacesDatabasePerformance & error 12514 received logging on to the standby AvailabilityData Guard This discussion is archived 1 2 3 Previous Next 32 Replies Latest reply on Oct 16, 2014 7:40 AM error 12514 received logging on to the standby oracle 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 response to http://openwares.net/database/dataguar_standby_network_timeout.html 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 Error 1033 received logging https://community.oracle.com/thread/3618547?start=15&tstart=0 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 Tracing not turned on. Tns er
2011 TNS-12570: TNS:packet reader failure Intermittent TNS-12570 on Application server [ID 556964.1]OS: Windows 11gr2. Fatal NI connect error 12570, connecting to:(LOCAL=NO) VERSION http://dbataj.blogspot.com/2011/10/tns-12570-tnspacket-reader-failure.html INFORMATION: TNS for 32-bit Windows: Version 11.2.0.2.0 - Production Oracle Bequeath NT http://oracle.ittoolbox.com/groups/technical-functional/oracle-db-l/tns-error-in-oracle-11g-on-windows-server-2008-5046429 Protocol Adapter for 32-bit Windows: Version 11.2.0.2.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 11.2.0.2.0 - Productionopiodr aborting process unknown ospid (6528) as a result of ORA-609 Time: 05-OCT-2011 16:31:55 Tracing not turned on. Tns error struct: ns main err received logging code: 12570 TNS-12570: TNS:packet reader failure Receiving above error in the alert.log file after that searched on metalink and found following solution: The Database server sqlnet log shows : nsmainerrcode:12637 TNS-12637:Packetreceivefailed nssecondaryerrcode:12547 ntmainerrcode:0 ntsecondaryerrcode:0 ntOSerrcode:0ChangesRecently Installed security update MS05-019 or Windows Server 2003 Service Pack 1 on the Appliction server..CauseThis is due to the bug in the Microsoft Windows received logging on Server 2003 SP1. Installing security update MS05-019 or Windows Server 2003 Service Pack 1 may cause network connectivity between clients and servers to fail For more informaiton and for the fix refer the below URL: http://support.microsoft.com/?kbid=898060 SolutionTo resolve this problem, install security update 913446 (security bulletin MS06-007). For more information about how to obtain and install security update 913446, visit the following Microsoft Web site:http://www.microsoft.com/technet/security/bulletin/MS06-007.mspx Posted by Mohammed Taj at Wednesday, October 05, 2011 Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest Labels: BUG Reactions: No comments: Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) Labels 11.2.0.3.0 (1) Advance Replication (2) ARCHIVE LOG backup/recovery Many Options (4) ASM (Automatic Storage Mgmt) (5) Audit Database (3) Authentication (6) AWR Report (2) Backup and Recovery Overview (4) Backup Scripts (7) Block Change Tracking (1) Blog Stats (3) BUG (34) Business Intelligence (12) CERTIFICATION (15) CHANGE_SCHEMA_NAME (1) Compile (1) Data Guard (5) Database Creation (4) Database Reference (34) DBMS_JOB (2) DBMS_LOB (1) DBMS_PROFILER (1) dbms_repair (1) DBMS_STATS (4) DBNEWID (5) D
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries MacProTX Inside-ERP VoIP_News Inside-CRM maxwellarnold PCMag I_am_the_dragon Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker JoeTorre bracke Locutus Ramnath.Awate DukeGanote Dennis Stevenson Craig Borysowich Richard mircea_luca Nikki Klein AbhaiTripathi knowscognosdoi Clinton Jones blrvenkat bluesguyAZ59 iudithm COMPANIES RSA Conference UC4 Apperian Sophos View All Topics View All Members View All Companies Toolbox for IT Topics Oracle Groups Ask a New Question Oracle Database This group is where peers share technical expertise, solve problems, and discuss issues related to the use of Oracle Databases, including Oracle Grid. Home | Invite Peers | More Oracle Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. TNS Error in Oracle 11g On Windows Server 2008 Dipti_Jadav asked Dec 22, 2012 | Replies (5) I am using Oracle 11g on Windows Server 2008 R2 in which I am facing lots of tns error in my database alert.log file. And these errors are thrown by Oracle on the front end side after some time. LISTENER CONTENT : LISTENER2 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = server)(PORT = 1522)) ) SID_LIST_LISTENER9 = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = ORACLE) (ORACLE_HOME = D:\oracle\product\11.2.0\dbhome_1) (SID_NAME = ORACLE) ) ) SID_LIST_LISTENER2 = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = ORACLE) (ORACLE_HOME = D:\oracle\product\11.2.0\dbhome_1) (SID_NAME = ORACLE) ) ) ADR_BASE_LISTENER9 = D:\oracle ADR_BASE_LISTENER2 = D:\oracle LISTENER9 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = server)(PORT = 1521)) ) Here two listeners used but listener2 used by few people for particular purpose and error does not thrown by it.