ORACLE with PIX HELP

j.hato · ‎02-24-2004

I have an oracle server running vers 8i on inside network. Have been NAT-ed and have access-list permit all the tcp and udp connection to the server when access from outside. Here the error message from client access from outside:

oracle error con 440

unable to make connection oracle - 12514 tns.couldn't resolve service name

the menu was not connectable with oracle. a menu is ended

Many Thanks for HELP

HATO

marcreiter · ‎02-26-2004

Oracle 8 uses dynamic ports in its connections. While it starts on (?1531?) it negotiatats a new port about every 6-20 packets. This will result in the above msg if you do not have all ports open.

Marc

Not an expert after 20 years.

sateeshk · ‎02-27-2004

hi

For testing purpose Pls try to disable NAT in firewall..and try to access the server from outside.

As per ur info u said that all ports r open diffnetly it should work.but still its not working means problem with NATTING.

Regads

Sateesh kumar.k

alan · ‎03-02-2004

PIX uses a default fixup syntax to handle the SQLnet connections. If you have moved the TNSlistner to a non-standard port (other than tcp 1521) PIX will not track the dynamically established sessions-- It watches TYCP 1521 to determine where the next dynamic port was negotiated by Oracle