Oracle Error Ora-03135
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 informatica ORA-03135: Connection Lost Contact Tips Oracle Database Tips by Burleson ora-03135 connection lost contact sap Consulting June 15, 2015 Question: I am attempting to connect to my Oracle database and I get the ORA-03135 error: ORA-03135:Ora-03135 Connection Lost Contact Standby
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 Cause: 1) Server unexpectedly terminated or was
Ora-03135 Connection Lost Contact Oracle 12c
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 parameter in the sqlnet.ora file or to check for a ora-03135 connection lost contact data guard 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 independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualif
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
Ora 03135 Connection Lost Contact Dbd Error Ocisessionbegin
company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions sqlplus ora-03135 connection lost contact Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million ora-03135 connection lost contact in datastage programmers, just like you, helping each other. Join them; it only takes a minute: Sign up “ORA-03135: connection lost contact” when inserting large file up vote 6 down vote favorite I'm trying to do an insert http://www.dba-oracle.com/t_ora_03135_connection_lost_contact.htm with a potentially large amount of binary data into a remote Oracle (11g) database using Entity Framework (ODP.Net). It 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: http://stackoverflow.com/questions/12163370/ora-03135-connection-lost-contact-when-inserting-large-file 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. 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
ORA-03113: end-of-file on communication channel. This actually means that your session has been dropped and there could be different reasons which might http://salmandba.blogspot.com/2015/07/ora-03135-connection-lost-contact.html have caused this. Most commonly; a firewall between client and server could have caused this session/connection drop, if firewall senses some session to be idle for a longer period of time. This session drop timeout setting is done in the firewall and to deny its effect, SQLNET profile parameter "expire_time" could be used to keep the database sessions alive to avoid connection lost any connection drop by the firewall. SQLNET.EXPIRE_TIME To avoid the problem of "unwanted" disconnection,sqlnet.expire_timecan be added in the sqlnet.ora file of database server. This parameter has a value in minutes and it would cause database server to send a packed to each client connect to it at an interval equal to the value of this parameter. This small packet sending would connection lost contact actually deceive firewall so that it considers it an active connection and does not drop it. We can initially set it to a value of 10 minutes which can be alerted with coordination of network admin who can help to find out firewall settings. Add the following line in$ORACLE_HOME/network/admin/sqlnet.ora ############ SQLNET.EXPIRE_TIME = 10 ############ Actual work of this parameter is to check the client sessions which might have exited but server process related to the session is still intact; so that this server process could also be terminated and resources could be released. For details about this parameter, pleaseClick Here at 7:58 PM Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest Labels: ORA-03135: connection lost contact No comments: Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) Search Oracle Community Forums Search This Blog Salman Ahmed Qureshi I am from Pakistan, living and working in Singapore. Click Here to view my complete profile. Please click here for the complete list of my Articles Blog Archive ► 2016 (20) ► October (2) ► September (2) ► August (1)