Ora-03135 Oracle Error
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 Don Burleson Blog ora-03135 connection lost contact oracle
ORA-03135: Connection Lost Contact Tips OracleOra-03135 Connection Lost Contact Informatica
Database Tips by Burleson Consulting June 15, 2015 Question: I am attempting to connect to my Oracle database and I ora-03135 connection lost contact 12c get the ORA-03135 error: ORA-03135: connection lost contact tips What can I do to avoid the ORA-03135 error? Answer: The oerr utility shows this for the ORA-03135 error: ORA-03135: connection lost contact ora-03135: connection lost contact sap 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 a firewall terminates the connection. One solution for the ORA-03135 error is to increase the value of the sqlnet.ora expire_time
Ora-03135 Connection Lost Contact Standby
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 documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals. Feel free to ask questions on our Oracle forum. Verify experience! Anyone considering using the services of an Oracle support expert should in
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 ora 03135 connection lost contact dbd error ocisessionbegin type your message and try again. More discussions in General Database Discussions All PlacesDatabaseGeneral Database ora-03135 connection lost contact oracle 12c Discussions This discussion is archived 1 2 Previous Next 21 Replies Latest reply on Jan 13, 2012 7:19 PM by 447967
Ora-03135 Connection Lost Contact Data Guard
ORA-03135 at heavy load 447967 Nov 30, 2011 7:08 PM Dear Anybody! ora 11g, x64, no firewal, no proxy, GigabitEth.... Looks like the ora does not server the new connection at heavy load. The server have http://www.dba-oracle.com/t_ora_03135_connection_lost_contact.htm more permanent connection never have a problem. But one connection periodic (~10sec) check the server heatl. For this connections the ora sometimes reject the connection with ORA-03135 or drop the connection with ORA-03135. The strange is this probelm occured only if the subject database size is high. In case of small or middle sized database this never occured. The SQLNET.EXPIRE_TIME, RCV_TIMEOUT, SEND_TIMEOUT, INBOUND_CONNECT_TIMEOUT not a solution because the sqlnet.log has absolutly https://community.oracle.com/thread/2318354 no entry at this time interval. At listner alert log has absolutely no entry for this incident. At rdbms alert log has absolutely no entry for this incident. Thanks for any advise... Edited by: kzsolt2 on Nov 30, 2011 10:58 AM Edited by: kzsolt2 on Nov 30, 2011 11:04 AM Edited by: kzsolt2 on Nov 30, 2011 11:08 AM I have the same question Show 0 Likes(0) 3089Views Tags: none (add) 11gContent tagged with 11g, editionContent tagged with edition, expressContent tagged with express, heavyContent tagged with heavy, limitContent tagged with limit, loadContent tagged with load, ora-03135Content tagged with ora-03135 This content has been marked as final. Show 21 replies 1. Re: ORA-03135 at heavy load sb92075 Nov 30, 2011 7:06 PM (in response to 447967) The strange is this probelm occured only if the subject database size is high.please quantify "high" What is unit of measure for "high". is this 3-tier application? Is connection pooling used? Like Show 0 Likes(0) Actions 2. Re: ORA-03135 at heavy load 447967 Nov 30, 2011 7:32 PM (in response to sb92075) "please quantify "high"" Our system are very load intesive and servide time sensitive. Therefor the all database moved (located) at ramdisk (fast as possible at XXI cent). The limit for the subject database is 20GB (
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads http://stackoverflow.com/questions/12163370/ora-03135-connection-lost-contact-when-inserting-large-file with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: https://oracledb101.wordpress.com/2012/10/05/error-ora-03135-connection-lost-contact/ Sign up “ORA-03135: connection lost contact” when inserting large file up vote 6 down vote favorite I'm trying to do an insert with a potentially large amount of binary data into a remote Oracle (11g) database using Entity Framework (ODP.Net). It connection lost works fine for really small files (<5 KB), but for larger ones (e.g. 44 KB) I get an error: "ORA-03135: connection lost contact". I don't think it's timing out, as the exception occurs within a second of executing the command. I tried setting both of the following in my connection string, but to no avail: Validate Connection=true Pooling=false I also looked in the listener.log file on the remote machine. It shows the connections being made, but no sign of exceptions or terminated connections. connection lost contact I'm up for suggested fixes or troubleshooting methods. Edit: The same SQL operations work when accessing an Oracle instance on the local network. c# oracle odp.net share|improve this question edited Jan 5 '14 at 19:07 Guido Leenders 2,0921828 asked Aug 28 '12 at 16:12 Ishmael Smyrnow 6491623 Well maybe it is not that, but I had the "ORA-03135: connection lost contact" on weird stuff when the connection was not lost at all it only happend that Oracle was no longer able to swallow the SQL statement submitted. I got it on huge queries (>2000 line of code). Maybe I am sending you on the right track but I thought after 4 hours no answer I at least could tell you that piece of my own experience. For me it looked like the message always appears when the parser of the SQL command crashed in the background. –hol Aug 28 '12 at 20:47 Might be worth checking the alert log on the remote machine to see if that reported an error. If not it maybe points to the problem being at the client end, not the server. Also, are there any firewalls in the way, or anything else at network level that might have logs you can check? –Alex Poole Aug 29 '12 at 7:11 A network log would be helpful. The firewall is not on, and it's a Windows server machine hosting Oracle. I'm not sure where TCP traffic is
target database to my new install of 12cR2 Cloud Control and after testing the connection string it would always time out. This error pop up did suggest to check for firewalls. In the past I have been burned by iptables being turned on by default and causing problems for RAC installs so I did check to ensure iptables where not only running on the db node but also the oms server as well but no such luck iptables were already off. To ensure it wasn't some weird network problem I ssh'ed into the db node and was able to make a local connection and so I setup an entry in the tnsnames.ora file to check connecting through the listener. To my surprise I had the same problem with sqlplus connecting and would get the following error sqlplus system@a250 SQL*Plus: Release 11.2.0.2.0 Production on Thu Oct 4 11:04:51 2012 Copyright (c) 1982, 2010, Oracle. All rights reserved. ERROR: ORA-03135: connection lost contact Process ID: 0 Session ID: 0 Serial number: 0 I have seen type of problem before but its usually is a firewall or other network problem but connecting to the db from a console was new. I checked the listener log file and it had normal entries with no errors at all. Next I checked the alert log for the database and found something. ORA-19815: WARNING: db_recovery_file_dest_size of 10737418240 bytes is 100.00% used, and has 0 remaining bytes available. ************************************************************************ You have following choices to free up space from recovery area: 1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard, then consider changing RMAN ARCHIVELOG DELETION POLICY. 2. Back up files to tertiary device such as tape using RMAN BACKUP RECOVERY AREA command. 3. Add disk space and increase db_recovery_file_dest_size parameter to reflect the new space. 4. Delete unnecessary files using RMAN DELETE command. If an operating system command was used to del