1 2 Previous Next 21 Replies Latest reply on May 26, 2011 9:24 AM by user645399 Go to original post
      • 15. Re: ORA-03135: connection lost contact
        user645399
        In my alert log, I noticed this warning

        WARNING: inbound connection timed out (ORA-3136) but thats a minute ago, not sure if thats a part of the problem thats causing ORA 03135

        Any comments?
        • 16. Re: ORA-03135: connection lost contact
          user645399
          Lubiez Jean-Valentin,

          I checked the page and I do not know what kind of information I should look for in the v$Session and V$Process. The 2nd point highlighted in the page is about timeout parameters, is it only for idle connections or are there parameters also for active connections?

          Please enlighten me on this.

          Thanks a lot.
          • 17. Re: ORA-03135: connection lost contact
            Sunny kichloo
            For ORA-3136 thisthread will be helpful

            http://forums.oracle.com/forums/thread.jspa?threadID=457356&start=0&tstart=0
            • 18. Re: ORA-03135: connection lost contact
              user645399
              Sunny,

              I will keep an eye on that error and see if it repeats. The error is to do with the connection time.

              But, now, I desperately need to fix the developers' problem in using the database itself for development.

              Could someone help me
              • 19. Re: ORA-03135: connection lost contact
                user645399
                Here is my sqlnet.ora (after including new parameters)
                SQLNET.AUTHENTICATION_SERVICES = (NTS)
                SQLNET.EXPIRE_TIME = 4
                SQLNET.INBOUND_CONNECT_TIMEOUT = 300
                SQLNET.SEND_TIMEOUT = 300
                SQLNET.RECV_TIMEOUT = 300
                NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
                and I have turned on tracing and still I dont see any changes.

                Its getting disconnected and nothing is being logged in alert log, trace files, and in listener.log, sqlnet.log
                • 20. Re: ORA-03135: connection lost contact
                  Lubiez Jean-Valentin
                  Hello,


                  I think you may have more details if you enable tracing.

                  To do that you may add the following parameters on the sqlnet.ora from the Client of your Developers:
                  trace_level_client=16           
                  trace_file_client=cli           
                  trace_directory_client=C:\temp     # Or a known directory           
                  trace_unique_client=true        # Add '_pid' to trace filename
                  The link below will explain you the steps to follow:

                  http://download.oracle.com/docs/cd/E11882_01/network.112/e10836/trouble.htm#i468763

                  Then, when the error occurs you may check the trace file.

                  There's a tool to check the trace file ( trcasst ):

                  http://download.oracle.com/docs/cd/E11882_01/network.112/e10836/trouble.htm#i459188

                  You may report here the result of this investigation or open a Service Request and send them the traces files with all the details about the error message you got.

                  Also, it's important to understand. Did it work before ? If yes which change in your information system happened (New PL/SQL code ? New Network component or configuration ? ).


                  Hope this help.
                  Best Regards,
                  Jean-Valentin
                  • 21. Re: ORA-03135: connection lost contact
                    user645399
                    I am making the amendments as per your suggestion.

                    No, it has never worked before, we had a different web based system to work with the database server all this while but today its down so, we wanted to work using our client from the pc but we couldn't and we had the problem earlier but we were not so bothered as we had alternative ways.

                    Edited by: user645399 on May 26, 2011 5:24 PM
                    1 2 Previous Next