Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SCAN load balancing not working when a firewall exists

omariDec 24 2013 — edited Jan 9 2014

Hi,

I have a two node RAC 11.2.0.3. when i connect to the database using the SCAN IP from a client located in front of the firewall, everything is working fine. but when i try the same from a client located behind a firewall,and the scan listener chooses to redirect the connection to the local listener on the node running the scan_listener the connection succeeds. but if the scan listener redirects to the other node (not running the scan listener) the following error is returned (ORA-12170: TNS:Connect timeout occurred). the two clients (the one inside the firewall and the outer one) have typical configurations including (hosts,tnsnames and version).

Also when i use manual load balancing using VIPs or public IP in the tnsnames.ora it's working fine even outside the firewall.

is there any specific firewall configuration regarding the scan?? all ports are opened from both directions (any to any)


BR,

Omari

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 6 2014
Added on Dec 24 2013
6 comments
3,705 views