I have a two node RAC setup where my scan ips are registered in DNS and my public Ips are also registered in the dns. Now while connecting from my windows machine through oracle client in sql developer im getting connection time out error and network adapter error. My question is that should I register my VIP also in dns and will that resolve this issue?
-
1Yes you have to register VIPs in DNS. When you connect to scan IPs you are being redirected to one of the node's VIP. Priv IPs are used for nodes interconnect. – Mindaugas Riauba Sep 3 '15 at 18:19
-
Are you using GNS or no? – Andrew Brennan Nov 17 '16 at 11:24
As far as I remember when I investigated RAC you need to add the VIP addresses to the DNS.
-
-
How do you define the connection? IP address or name? When it is name you need to put it in DNS or in the hosts file. – Marco Sep 3 '15 at 20:54
-
-
What is the result of
tnsping
to the database? What is the content of thetnsnames.ora
? I never implemented RAC and I never used sql developer (do you use the latest version?) so I do not know if it needs something special to connect to a RAC database. – Marco Sep 4 '15 at 17:48 -
Tnsping works even too. Im getting struck somewhere. Unsure where. Tnsnames is ok since im able to connect it from the server. – tesla747 Sep 4 '15 at 17:51
Are you running this two node setup on Linux servers? Are you able to ping the target server through hostname? Once while I was testing a two node RAC running on Virtualbox, I had to add hostname resolution so that the client could communicate with the SCAN ips and resolve them.
If that's the problem, edit the C:\windows\system32\drivers\etc\hosts and add the ip and hostnames for SCAN resolution.
Ex.:
127.0.0.1 localhost
192.168.56.91 rac-scan.localdomain rac-scan
192.168.56.92 rac-scan.localdomain rac-scan
192.168.56.93 rac-scan.localdomain rac-scan