Results 1 to 3 of 3

Thread: Error in dblink

  1. #1
    Join Date
    Feb 2002
    Posts
    2

    Unanswered: Error in dblink

    Hi:

    I have an Oracle server with a dblink defined to another instance in a remote box. When runnig a long-timing data copy between them, process abort after a while with this message:

    ERROR at line 1:
    ORA-02068: following severe error from LNK_STA
    ORA-03113: end-of-file on communication channel
    ORA-06512: at "SAC.STA_PACKAGE", line 211
    ORA-06512: at "SAC.STA_PACKAGE", line 537
    ORA-06512: at line 1

    ¿What could be hapennig? Thanks in advance for any help

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >What could be hapennig?
    A firewall or other network timeout might be happening?
    Do short queries work OK?
    Does the error occur after the same amount of elapsed time?
    Did this ever work OK?
    If so, what changed.
    You provided too few clues for any definitive response.

  3. #3
    Join Date
    Oct 2003
    Location
    Slovakia
    Posts
    482
    Originally posted by anacedent
    >What could be hapennig?
    A firewall or other network timeout might be happening?
    Do short queries work OK?
    Does the error occur after the same amount of elapsed time?
    Did this ever work OK?
    If so, what changed.
    You provided too few clues for any definitive response.
    ...or the second instance went down...

Posting Permissions

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