Unanswered: Error ORA-03113 in dblink with a firewall
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.