topic Re: ORACLE with PIX HELP in Network Security

ORACLE with PIX HELP

j.hato — Fri, 21 Feb 2020 07:15:33 GMT

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

Re: ORACLE with PIX HELP

marcreiter — Thu, 26 Feb 2004 20:00:38 GMT

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.

Re: ORACLE with PIX HELP

sateeshk — Sat, 28 Feb 2004 01:40:55 GMT

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

Re: ORACLE with PIX HELP

alan — Tue, 02 Mar 2004 14:59:52 GMT

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