Oracle RAC 10g - Application connect directly to database IP address
647526Aug 19 2010 — edited Aug 20 2010Hi,
I am a developer and does not have much knowledge about oracle admin. Sorry, if I don't use the term correctly.
We have a vendor application using Oracle RAC on two node (node1/vip1,node2/vip2). Our application was configured to use JDBC connection string (not TNS, someone told me it's a bad practice - but it's how our consultant vendor set it up). The connection string is configured to point to VIP1 hostname and VIP2 hostname.
When I look at the list of connections using netstat, I am seeing the connection was established to vip1's ip address as well as node2's ip address (no vip2 or node1 ip).
1) Should the application just only connect to VIP ip address and not to server ip address?
2) Because our JDBC entry only contains VIP1 and VIP2 hostname, does it normal that the application can resolve the NODE2 ipaddress? ( we look on all application's configuration files, we are sure that application does not have knowledge of node1/node2 ip address or hostname)
3) Is this a normal VIP hostname to be resolved to database ip address and not VIP ip address?
4) I read about VIP address that it will be mapped to the other node's MAC when the node fail, could this happen because VIP misconfiguration?
Edited by: user644523 on Aug 19, 2010 1:34 PM