Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Community Member

ORACLE with PIX HELP

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

3 REPLIES
Community Member

Re: ORACLE with PIX HELP

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.

Community Member

Re: ORACLE with PIX HELP

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

Community Member

Re: ORACLE with PIX HELP

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

115
Views
0
Helpful
3
Replies
CreatePlease to create content