TNS Scan Issue with Client Firewall

This is a 2 node 11gR2 RAC cluster database.

When attempting to configure an ODBC connection to Oracle I encountered an issue with the scan listener and the client firewall. It seems even though I was able to obtain a successful tnsping to the database:

01_good_tnsping.jpg

However, trying to connect via ODBC produced the following error:

02_unable to connect_odbc.jpg

Instead of pursuing the cumbersome process of dealing with a network team and trying to figure out the firewall issue I simply converted the tnsnames.ora entry to reflect each of the hosts:

03_good_tnsping_withoutscan.jpg

I still had a good tnsping, so I moved on to the ODBC DSN again….finally having success:

04_Finally_connected.jpg

There are a lot of articles related to this error, but most seem to point to the client side firewall blocking communication. Keep in mind that the client side needs to be able to resolve not just the SCAN , but the VIPs and the real IP’s  of all servers in the RAC.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s