Ora 03135 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 informatica ORA-03135: Connection Lost Contact Tips Oracle Database TipsOra-03135 Connection Lost Contact Sap
by Burleson Consulting June 15, 2015 Question: I am attempting to connect to my Oracle database and I get the ORA-03135 ora-03135 connection lost contact standby 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 Cause: 1) Server unexpectedly ora-03135 connection lost contact oracle 12c 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 parameter in the sqlnet.ora file
Ora-03135 Connection Lost Contact Data Guard
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 independently investigate their credentials and experience, and not rely on advertisements and
here for a quick overview of the site Help ora 03135 connection lost contact dbd error ocisessionbegin Center Detailed answers to any questions you might have Meta sqlplus ora-03135 connection lost contact Discuss the workings and policies of this site About Us Learn more about Stack
Ora-03135 Connection Lost Contact In Datastage
Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask http://www.dba-oracle.com/t_ora_03135_connection_lost_contact.htm 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: Sign up What the reason of error “ORA-03135: Connection lost contact” when migration Microsoft OracleClient to ODP.NET up http://stackoverflow.com/questions/24079467/what-the-reason-of-error-ora-03135-connection-lost-contact-when-migration-mic vote 1 down vote favorite Recently decided to make the migration. And on some database servers all works fine, but on the other for some unknown reason errors occur. I'm use the following code: using System.Data.OracleClient; using Oracle.ManagedDataAccess.Client; namespace ConsoleApplication1 { class Program { static void Main(string[] args) { System.Data.OracleClient.OracleConnection _conn = new System.Data.OracleClient.OracleConnection("Data Source=[TNS_NAME];User Id=[USER_ID];Password=[PASS];"); _conn.Open(); Oracle.ManagedDataAccess.Client.OracleConnection _conn1 = new Oracle.ManagedDataAccess.Client.OracleConnection("Data Source=[HOST/TNS_NAME];User Id=[USER_ID];Password=[PASS];Validate Connection = true"); _conn1.Open(); } } } on the line _conn1.Open() i get an error "ORA-03135: Connection lost contact" Why this phenomenon can occur? DB server - Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production c# oracle migration odp.net oracleclient share|improve this question edited Jun 6 '14 at 10:25 asked Jun 6 '14 at 10:18 Feagor 64 One difference between the OracleClient and ODP.NET is that ODP.NET's OracleConnection is actually a connection
WizardInformatica Cloud for Amazon AWSComplex Event ProcessingProactive Healthcare Decision ManagementProactive MonitoringReal-Time Alert ManagerRule PointData IntegrationB2B Data ExchangeB2B https://network.informatica.com/thread/34697 Data TransformationData Integration HubData ReplicationData ServicesData Validation OptionFast CloneInformatica PlatformMetadata ManagerPowerCenterPowerCenter ExpressPowerExchangePowerExchange AdaptersData QualityAddress DoctorAddress Doctor CloudData as a ServiceData ExplorerData QualityData Quality Services (Strike Iron)Data Security Group (Formerly ILM)Data ArchiveData Centric SecuritySecure@SourceSecure TestingMaster Data ManagementIdentity ResolutionMDM connection lost Big Data Relationship ManagementMDM Multidomain EditionMDM Registry EditionProcess AutomationActiveVOSCloud ExtendProduct Information ManagementInformatica ProcurementProduct Information ManagementUltra MessagingUltra Messaging OptionsUltra Messaging Persistence EditionUltra Messaging Queuing EditionUltra Messaging Streaming EditionVibe Data StreamDocumentationKnowledge BaseResourcesPAM (Product Availability Matrices)Support TVInformatica Expert AssistantVelocity (Best Practices)Mapping connection lost contact TemplatesDebugging ToolsUser Groupsglobal.search.communityLog inSign Up Informatica Network > Data Integration > PowerCenter > Discussions Please enter a title. You cannot post a blank message. Please enter your message and try again. 4 Replies Latest reply: Mar 22, 2012 11:00 PM by Veeru B ORA-03135: connection lost contact user152921 Mar 26, 2008 11:27 PM Hi All,I am facing this problem from last week ,whenever reader thread is idle for more then an hour ,session is failing with connection lost error.My source database is oracle.ORA-03135: connection lost contactDatabase driver error...Please advice what are the parameter we need to check 8000Views Tags: none (add) data-integrationContent tagged with data-integration, powercenterContent tagged with powercenter R