Skip to main content
damiri
damiri
New Member
January 26, 2015
Question

Oracle 11g R2 session issue/drop with Fortigate

  • January 26, 2015
  • 2 replies
  • 12261 views

Hello,

have FG-200B running 5.0.7 in transparent mode without any scanning or anything else. Oracle database until Saturday was 11g R1 and with session-ttl tweaking:

 

config system session-ttl config port edit 0 set protocol 6 set timeout 28800 set end-port 1521 set start-port 1521 next end

 

system was working fine. After upgrade to 11g R2 without any changes to FG, we started to getting errors like:

ORA-03113, ORA-12571 and  NET: Network error (53)

 

I have researched a bit forum but wasn't able to find solution for this. Anybody with some aces in sleeves?

 

Damir

    2 replies

    Silver
    Silver
    New Member
    January 27, 2015

    Hi,

     

    Please delete the Port 1521 for oracle tns on session helper. your problem will be solved!

     

    Thanks

    damiri
    damiriAuthor
    New Member
    January 27, 2015

    Already tried to remove but then get even worse. So with this setup at least I got one app running. Any other suggestions?

    nicolase
    nicolase
    New Member
    October 4, 2016

    I used to have this problem. After a lot of changes made in the database and in the FortiGate, the problem was solved upgrading the FortiOS from 5.2.3 to 5.2.9

    Alexis_G
    Alexis_G
    New Member
    January 16, 2019

    I am facing the same issue on FGT-VMX (5.6.6)

     

    I tried by increasing session-ttl (on firewall custom service, or on firewall policy or globaly), and sometime there was a connection but most of the times noGo !!

     

    Then tried with deleting the tns session-helper, still noGo !!

     

    I m working along with TAC,

    Any ideas, any further feedback

    Regards

     

    Terms & ConditionsAccessibility statement