utorak, 29. svibnja 2012.

ERROR ORA-12170: TNS:Connect timeout occurred when you try to connect to Oracle Database over firewall

When i try to connect to Oracle 10gR2 database over Cisco ASA Firewall i got ORA-12170 error despite that tnsping-ing "tnsnames_entry" is going just fine. On ASA i set up incoming and outgoing NAT address. Only difference is that listener of database is not configured on standard port of 1521 (it was set at non-default port of 1531)

The problem was resolved with the help i got on this link: What is the advantage of enabling sqlnet inspection in ASA appliance.

After setting following parameter in ASA config:

fixup protocol sqlnet 1531


Nema komentara:

Objavi komentar