Database Error 3135
Contents |
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion Excel-DB ora-3135 connection lost contact Don Burleson Blog
ora 03135 connection lost contact dbd error ocisessionbegin ORA-03135: Connection Lost Contact Tips Oracle tips by Burleson June 15, 2015 Question: I am ora-03135 connection lost contact informatica attempting to connect to my Oracle database and I get the ORA-03135 error: ORA-03135: connection lost contact tips What can I do to avoid the ORA-03135 error? Answer: The ora-03135 connection lost contact 12c oerr utility shows this for the ORA-03135 error: ORA-03135: connection lost contact Cause: 1) Server unexpectedly terminated or was forced to terminate. or 2) Server timed out the connection. Action: 1) Check if the server session was terminated. 2) Check if the timeout parameters are set properly in sqlnet.ora. The ORA-03135 error is common when connecting remotely when aOra-03135 Connection Lost Contact Sap
firewall terminates the connection. One solution for the ORA-03135 error is to increase the value of the sqlnet.ora expire_time parameter in the sqlnet.ora file or to check for a expire parameter in a SQL*Plus profile. To diagnose the ORA-03135 error, start by checking to see if the OS PID still exists, using the ps –ef|grep syntax. Check to see if there is a Network Address Translation (NAT) between the client and server In Windows, check to see if a Windows firewall is checking for your local connections: Windows XP -> Control panel -> security -> Tab "Advanced" Also, setting the parameters sqlnet.inbound_connect_timeout and inbound_connect_timeout_listenername to 0 can stop the ORA-03135 error. Get the Complete Oracle SQL Tuning Information The landmark book "Advanced Oracle SQL Tuning The Definitive Reference" is filled with valuable information on Oracle SQL Tuning. This book includes scripts and tools to hypercharge Oracle 11g performance and you can buy it for 30% off directly from the publisher. Burleson is the American Team Note: This Oracle docu
Error in v$archive_dest from PR. Run the below sql in PR SQL>select error,status from gv$archive_dest where dest_id=2;
Ora-03135 Connection Lost Contact Standby
Below are the error by time to time i get. ORA ora-03135 connection lost contact oracle 12c 03135: connection lost contact ORA 12152: TNS:unable to send break messageORA-16198: Timeout incurred on internal channel during sqlnet.ora expire_time remote archivalORA-12152: TNS unable to send break messageORA-12592: TNS bad packet++Error in standby alert logRFS :Possible network disconnect with primary databaseFetching gap sequence in thread 1, gap sequence http://www.dba-oracle.com/t_ora_03135_connection_lost_contact.htm 19565-19664Thu Aug 14 09:23:01 2014RFS[2981]: Assigned to RFS process 4390RFS[2981]: Opened log for thread 1 sequence 19575 dbid 480254220 branch 818176800CORRUPTION DETECTED: In redo blocks starting at block 1count 2048 for thread 1 sequence 19575 ++ Primary databae trace error of alert log krsb_stream_send: Error 3135 sending stream IOVRFS network connection lost at host 'MZFCCSTD' error 3135Error http://oracletechdba.blogspot.com/2014/08/archive-logs-not-shiping-to-standby-or.html 3135 writing standby archive log file at host 'MZFCCSTD'*** 2014-08-13 16:48:29.964 4265 krsh.cLNS: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (3135)*** 2014-08-13 16:48:29.964 4265 krsh.cLNS: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned*** 2014-08-13 16:48:29.964 4265 krsh.cError 3135 for archive log file 3 to 'MZFCCSTD'*** 2014-08-13 16:48:29.964 2864 krsi.ckrsi_dst_fail: dest:2 err:3135 force:0 blast:1ORA-03135: connection lost contactClosing Redo Read ContextDiag: ++ ping is working++ tnsping is working with expected msec( < 2msec)++ When we trasfer the file it scping with expected bandwidth as like estimate http://oracletechdba.blogspot.com/2014/08/to-calulation-oracle-data-guard-standby.html.Solution:++ We are using Juniper switch and by default SQL ALG is enabled.So as per metalink 1130523.1 we have to disable. "Work with your Network Administrator to make sure the following Firewall Features are disabled. SQLNet fixup protocol Deep Packet Inspection (DPI) SQLNet packet inspection SQL Fixup SQL ALG (Juniper firewall)" At Juniper switch level command to Disable SQL ALG globally using the "set security alg sql disable".Or You can try change the port of the listener in DR with respective change in PR tnsname.ora Posted by Karl M
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management http://sap.ittoolbox.com/groups/technical-functional/sap-basis/application-server-time-out-settings-2307174 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 http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=36306 GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries Inside-ERP MacProTX VoIP_News Inside-CRM PCMag I_am_the_dragon maxwellarnold Michael Meyers-Jouan TerryCurran connection lost Chris_Day Andrew.S.Baker JoeTorre bracke Locutus Ramnath.Awate Richard DukeGanote Craig Borysowich Dennis Stevenson Nikki Klein mircea_luca AbhaiTripathi knowscognosdoi Clinton Jones bluesguyAZ59 Iqbalyk blrvenkat COMPANIES Juniper Networks CloudLock Avaya Adaptive Planning View All Topics View All Members View All Companies Toolbox for IT Topics SAP Groups Ask a New Question SAP Basis The SAP connection lost contact Basis group is for the discussion of specific configuration and development issues that arise when utilizing the SAP Basis & System Administration. Home | Invite Peers | More SAP 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. Application Server Time Out Settings sap basis asked Aug 18, 2008 | Replies (4) Hi guys, I have an environment SAP ECC 5.0 running oracle 10g. 1 DB server and 2 applicat
Web and Mobile SQL*Plus Data Warehousing Installation Networking Backup Recovery Security Tuning PLSQL Oracle Applications Scripts Administration ORA-HOWTO Web and Mobile SQL*Plus Data Warehousing Installation Networking Backup Recovery Security Tuning PLSQL Oracle Applications Papers Administration ORA-HOWTO Web and Mobile SQL*Plus Data Warehousing Installation Networking Backup Recovery Security Tuning PLSQL Oracle Applications Forum All threads Best last month Links Oracle official Oracle Technical Info Tools (free) Tools (commercial) Oracle FAQ Other DBA-sites Oracle development Not Oracle specific Oracle Blogs Imho Fqa Pirats | Start a new thread | All threads | Best last month | No question at this time DBA Top 10 1 M. Cadot 38600 2 F. Diaz 33800 3 J. Schnackenberg 19400 4 B. Vroman 16850 5 A. Kavsek 16650 6 T. Boles 15700 7 P. Wisse 15050 8 M. Hidayathullah ... 11700 9 A. Hudspith 8600 10 A. Khan 4900 About Advertise here Download PLATOThe free tool for auditing and tuning your databaseVersion 55 now available Sep 02, 2016 The DBA-Village forum as RSS feed Site StatisticsEver registered users47779Total active users2127Act. users last 24h23Act. users last hour2Registered user hits last week620Registered user hits last month6871 Go up ora -3135 lost connection and ora 3114 not connected to database Next thread: RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in re Prev thread: Wallet question Message Score Author Date Hi Frnds, One of my user getting ORA-3135 and O...... Muhammed Thameem Apr 01, 2009, 12:10 Hi, Looking about these errors make me think ab...... jean-luc touzalin Apr 01, 2009, 13:08 Hi, Thanks for your reply.I dint contact with net...... Muhammed Thameem Apr 01, 2009, 15:15 Follow up by mail Click here Subject: ora -3135 lost con