10 Replies Latest reply on Jul 23, 2014 2:31 AM by Mayuresh Wagh

    ORA-03135: connection lost contact

    Baeny Khaeroni
      Share This:

      Hi All,

       

      We have problem and message found in arerror.log is ORA-03135: connection lost contact.

      Below is detail:

       

      We have server group in my environment. We have two server application, server #1 is normal but server #2 is problem.

      We have checked in arerror.log found the message:

      Mon Jul 14 16:39:10 2014  390620 : SQL database is now available (ARNOTE 592)
      Mon Jul 14 16:49:43 2014  390620 : Failure during SQL operation to the database (ARERR 552)
      Mon Jul 14 16:49:43 2014     ORA-03135: connection lost contact


      Log from system is below:

      Jul 17 16:57:54 Nettisapp arserverd[28080]: [ID 970746 user.error] 390620 : Failure during SQL operation to the database (ARERR 552)
      Jul 17 16:57:54 Nettisapp arserverd[28080]: [ID 702911 user.error] ORA-03135: connection lost contact
      Jul 17 16:58:09 Nettisapp arserverd[28080]: [ID 970746 user.error] 390620 : SQL database is now available (ARNOTE 592)
      Jul 17 17:01:16 Nettisapp arserverd[28080]: [ID 970746 user.error] 390620 : Failure during SQL operation to the database (ARERR 552)
      Jul 17 17:01:16 Nettisapp arserverd[28080]: [ID 702911 user.error] ORA-03135: connection lost contact


      We have checked with ping,traceroute,tnsping is normal.

      We try to restart the AR service and normal, but after one hour we have founded the same problem.


      Below is detail my environment:

      Version: 7.1.00 Patch 005 200809150630 Sep 15 2008 07:44:03

      Database: SQL -- Oracle

      Hardware: sun4u

      OS: SunOS 5.10


      Please help me,where is the problem?


      Best Regards,

      Baeny