This discussion is archived
1 2 Previous Next 16 Replies Latest reply: Apr 7, 2010 2:24 AM by 732311 RSS

ORA-03135: connection lost contact

556258 Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    http://orcl-experts.info/troubleshooting.htm
  • 8. Re: ORA-03135: connection lost contact
    636344 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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
    756740 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    $ 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