3 Replies Latest reply on Sep 16, 2015 4:21 PM by Shahid_Ali

    Failed to connect to database instance: ORA-03135: connection lost contact Error

    1224266

      Hi All,

       

      Please anyone help me to resolve this production issue.....

       

      We are reviving the "Failed to connect to database instance: ORA-03135: connection lost contact Error" because of that our production database is unavailable or disconnected from the user and informatica sessions.

       

      We added the connection timed out parameter in sqlnet.ora listener.ora. But still the issue is not resolved.

       

       

      SQLNET.ORA=  "SQLNET.INBOUND_CONNECT_TIMEOUT = 180"

      LISTENER.ORA= "INBOUND_CONNECT_TIMEOUT_LISTENER = 120"