Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2002
    Posts
    2

    Unanswered: Error ORA-03113 in dblink with a firewall

    Hi:

    I have an Oracle server connecting via dblink to another Oracle box, for a long term data copy. The process first selects data from database in temporal tables (around 4 horas long) and then tries to copy to remote server through the link.

    When both boxes where in the same IP subnet the copy run well, but since one of these was migrated to another subnet and a firewall instaled between them, the copy process doesn't work and aborts 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
    >

    May the firewall be the cause? I am getting no messages in listener logs or OS logs (unfortunatelly, I am not the DBA and so I don't have acces to Oracle alert log). Any check you can suggest? Thanks in advance for any help.

    Regards,

    José Enrique González
    Caracas, venezuela

  2. #2
    Join Date
    Jan 2004
    Posts
    370
    Does the database link work at all?

    select sysdate from dual@<database link>

Posting Permissions

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