DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ORA-02063: preceding line from

  1. #1
    Join Date
    Feb 2001
    Posts
    119

    ORA-02063: preceding line from

    I am getting these errors every(Daily 5 to 10 times ) now and then .The orders table ,I am calling from another database through a DB link FM.DVT .After 5 mins everything works normal .

    SQL> select orderno FROM ORDERS where rownum <2;
    select orderno FROM ORDERS where rownum <2
    *
    ERROR at line 1:
    ORA-12570: TNSacket reader failure
    ORA-02063: preceding line from FM.DVT


    SQL> select orderno FROM ORDERS where rownum <2;
    select orderno FROM ORDERS where rownum <2
    *
    ERROR at line 1:
    ORA-02051: another session in same transaction failed
    ORA-02063: preceding line from FM.DVT

  2. #2
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    Can you turn on tracing and re-execute the statement.

    there may be many reasons,
    a network issue while sending and receiving packets.......
    client could be behind the firewall.......
    are you sure the local and remote run the same versions and installed patches...........
    check for bugs in the versions.......

    .....................
    Last edited by dbasan; 05-26-2005 at 05:23 PM.
    "What is past is PROLOGUE"

Posting Permissions

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


Click Here to Expand Forum to Full Width