Results 1 to 7 of 7
  1. #1
    Join Date
    May 2013
    Posts
    3

    Unanswered: ORA-03135: connection lost contact

    I am trying to read data from one server and loading the table present in different server through data stage job. The job is getting aborted with
    ORA-03135: connection lost contact error.Let me know how to resolve this issue.

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Quote Originally Posted by Oracle
    ORA-03135: connection lost contact

    Cause: 1) Server unexpectedly terminated or was forced to terminate. 2) Server timed out the connection.

    Action: 1) Check if the server session was terminated. 2) Check if the timeout parameters are set properly in sqlnet.ora.
    What is "data stage job"?

    Did you try any other approach? How about direct INSERT through a database link? Or data pump (export source, import it into target)?

    Is it a "one time task" or do you plan to do it repeatedly? Would a materialized view (with its refreshing options) fit into what you do?

  3. #3
    Join Date
    May 2013
    Posts
    3
    Data Stage is an ETL Tool.
    It is repetitive process which we have to do through the tool only.
    My assumption is, the error is because of the connectivity issue between the servers.
    But do not the solution to resolve it

  4. #4
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    Is the session being terminated, or is it failing? You need to determine this first before deciding on a course of action. Is there anything in the server/s logs that point to a possible cause of the problem?
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  5. #5
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    For sake of this discussion, DB_SRC is the system with the SOURCE table & TARGET is the system that is trying to obtain data from SOURCE table.

    Logon to TARGET.
    initiate telnet session & log into DB_SRC system at the OS level.
    Just allow this session to remain idle but connected to DB_SRC system

    If/when this session gets disconnected, then you know that problem is external to Oracle
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  6. #6
    Join Date
    May 2013
    Posts
    3
    Hi Guys,
    Thanks for your reply.

    We got to know that the issue is because of the Firewall time out settings . When the database is connected, but is idle beyond the time frame of 'firewall idle time settings',firewall is closing the connection.So network guys are working on it.

    The issue is out of Oracle

  7. #7
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    Thanks for the update. It may help someone else in future with a similar problem.
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •