1 2 Previous Next 16 Replies Latest reply: Apr 7, 2010 4:24 AM by 732311 RSS

    ORA-03135: connection lost contact

    556258
      I want to make DB link from Oracle 10g R2 DB to Sybase using ODBC (note the platform Windows 2003 server SP1 and both on the same machine named server ), the steps i followed ,

      1- I defined the ODBC on windows and connected successfully named "odbcloc"

      2- I created the .ora file under <oracle_home> \\...\\hs as follows
      inithsloc.ora
      HS_FDS_CONNECT_INFO = odbcloc
      HS_FDS_TRACE_LEVEL = off

      3- I modified the listener . ora file as follows
      Listner.Ora
      (SID_DESC =
      (SID_NAME = hsloc)
      (ORACLE_HOME = G:\OracleHomesDB\Product\10.2.0\db_1)
      (PROGRAM = hsodbc)
      )
      and restart the listner

      4- From Oracle Warehouse Builder I could connect to this service and extract tables

      5. I created tnsnames.ora but i couldnt connect and got this error ORA-03135: connection lost contact

      HSLOC=
      (DESCRIPTION=
      (ADDRESS=(PROTOCOL=TCP)(HOST=server)(PORT=1522))
      (CONNECT_DATA=
      (SID=hsloc)
      (HS=OK)
      )
      )

      6. I changed the sqlnet.ora paramter sqlnet.expire_time = 0
      but got the same error
        • 1. Re: ORA-03135: connection lost contact
          567269
          Are you sure that your connection requires the sqlnet.ora file? I'm a big fan of deleting it, but we have a pretty simple database setup.

          If you can rename the sqlnet.ora file to sqlnet.ora.old and see if that helps you.

          -J
          • 2. Re: ORA-03135: connection lost contact
            556258
            Thanks for your support but i tried and renamed it and it didnt work i got the same error message
            • 3. Re: ORA-03135: connection lost contact
              ora001
              Saad -

              Hopefully you must have resolved this issue by now. If not check your listner status after you load it.

              C:\Documents and Settings\Owner>lsnrctl services

              LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 13-SEP-2007 22:43
              :40

              Copyright (c) 1991, 2005, Oracle. All rights reserved.

              Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
              Services Summary...
              Service "mssql" has 1 instance(s).
              Instance "mssql", status READY, has 1 handler(s) for this service...
              Handler(s):
              "DEDICATED" established:0 refused:0 state:ready
              LOCAL SERVER
              Service "raidb102g" has 1 instance(s).
              Instance "raidb102", status READY, has 1 handler(s) for this service...
              Handler(s):
              "DEDICATED" established:4 refused:0 state:ready
              LOCAL SERVER
              The command completed successfully

              In the example above "mssql" is my system DSN to MS SQL server. Make sure you have status READY.

              Cheers!
              Prakash
              • 4. Re: ORA-03135: connection lost contact
                dmcghan
                Prakash,

                I'm getting the same error. I just created an ODBC connection to a 2005 SQL Server DB. I tried your trick and I got a status of unknown, any ideas for troubleshooting?

                Regards,
                Dan
                • 5. Re: ORA-03135: connection lost contact
                  Kgronau-Oracle
                  status unknown is good for hsodbc as hsodbc is spawned on the fly by the listener. A up and running status can be gathered only for real Oracle databases as they register at the listener and tell the listener I'm alive and running.
                  • 6. Re: ORA-03135: connection lost contact
                    Kgronau-Oracle
                    The root cause look like a problem in your tns entry:

                    your entry:
                    HSLOC=
                    (DESCRIPTION=
                    (ADDRESS=(PROTOCOL=TCP)(HOST=server)(PORT=1522))
                    (CONNECT_DATA=
                    (SID=hsloc)
                    (HS=OK)
                    )
                    )

                    should be:
                    HSLOC=
                    (DESCRIPTION=
                    (ADDRESS=(PROTOCOL=TCP)(HOST=server)(PORT=1522))
                    (CONNECT_DATA=
                    (SID=hsloc)) ### see 2 closing brackets
                    (HS=OK)
                    )

                    (HS=OK) must be outside of the connect_data section.
                    • 7. Re: ORA-03135: connection lost contact
                      622380
                      http://orcl-experts.info/troubleshooting.htm
                      • 8. Re: ORA-03135: connection lost contact
                        636344
                        I am having essentially the same problem. I discovered the following with regard to OWB: If the connection is defined as a non_Oracle location, Test Connection will run successfully. If it is defined as an Oracle location, you get the ORA-03135. I cannot connect using SQL Plus or SQL Developer: they always return the error.
                        • 9. Re: ORA-03135: connection lost contact
                          25447
                          hi

                          I have been playing around with HSODBC and ran into the same problem
                          ORA-02068: following severe error from HSLINK
                          ORA-03135: connection lost contact

                          Now here is what I have found.

                          I have two R&D boxes:

                          filer server 1:
                          OS: Window 2000
                          Oracle db=EE 10.2.0.3
                          patch level= 1 <<<<<<<<<<<< patch 5731535

                          File Server 2:
                          OS: Window 2003
                          Oracle db=EE 10.2.0.3
                          patch level= 10 <<<<<<<<<<patch 6344567


                          On the file server 2, the HSODBC works great...no problem hooking up to SQL 2000

                          On File Server 1...run into the
                          ORA-02068: following severe error from HSLINK
                          ORA-03135: connection lost contact

                          I will update my File Server1 with the patch 20 ( patch 6867054) and see if that will make the difference.

                          p-
                          • 10. Re: ORA-03135: connection lost contact
                            651688
                            Hi,

                            I am facing the same problem in toad.I have a query which takes min of 2hrs to execute and for every 15mins or so i am left with connection lost contact.Could you let me know the exact reason behind it.I have set the parameter sqlnet.expire_time = 10 in sqlnet.ora file.Is this effecting me if so plz let me know to which value should i set it to.
                            • 11. Re: ORA-03135: connection lost contact
                              669902
                              I have users getting the same error when connecting from an application. The users get booted out after being logged in for a couple of hours then randomly get ORA-03135: connection lost contact errors. I have tried setting SQLNET.EXPIRE_TIME = 5 but the error is still occuring... I am starting to increment EXPIRE_TIME each time to see if setting it higher helps.
                              • 12. Re: ORA-03135: connection lost contact
                                190639
                                i got the same error .Check if the firewall is checking for your local connections.
                                (Windows XP - Control panel - security - Tab "Advanced" )
                                I turned it off and then it seemed to work fine. Dont think this maybe the best solution .
                                • 13. Re: ORA-03135: connection lost contact
                                  barq
                                  thanks, it solved my problem.
                                  Actually Toad recommended me to write my tns file like that. but then I was facing the problem of not connecting to my hsodbc connection. so I changed my tns file back to the format that you recommended and it solved the problem.
                                  • 14. Re: ORA-03135: connection lost contact
                                    732311
                                    $ sqlplus test/test@db1
                                    
                                    SQL*Plus: Release 10.2.0.1.0 - Production on Tue Apr 6 15:58:31 2010
                                    
                                    Copyright (c) 1982, 2005, Oracle.  All rights reserved.
                                    
                                    ERROR:
                                    ORA-03135: connection lost contact
                                    
                                    
                                    Enter user-name:
                                    I'll increase the SQLNET.EXPIRE_TIME ?
                                    there are some relationship with the EXPIRE_TIME? I want to login into the DB, only.
                                    $ lsnrctl services db1
                                    
                                    LSNRCTL for Solaris: Version 10.2.0.1.0 - Production on 06-APR-2010 15:59:52
                                    
                                    Copyright (c) 1991, 2005, Oracle.  All rights reserved.
                                    
                                    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.10.0.1)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=db1)))
                                    Services Summary...
                                    Service "db1" has 1 instance(s).
                                      Instance "db1", status UNKNOWN, has 1 handler(s) for this service...
                                        Handler(s):
                                          "DEDICATED" established:37975 refused:0
                                             LOCAL SERVER
                                    The command completed successfully
                                    Now I haven't this problem. I'm checking on the "alert_db1.log" and find this error: "WARNING: inbound connection timed out (ORA-3136)"

                                    I suppose that the problem "ORA-03135: connection lost contact" is related to this error.
                                    Inbound connection timed out (ORA-3136)
                                    Cheers,
                                    Lain
                                    1 2 Previous Next