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?
2
-
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 RiaubaSep 3, 2015 at 18:19
-
Are you using GNS or no?– Andrew BrennanNov 17, 2016 at 11:24
Add a comment
|
2 Answers
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.– MarcoSep 3, 2015 at 20:54
-
-
What is the result of
tnspingto 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.– MarcoSep 4, 2015 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.– tesla747Sep 4, 2015 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
answered Sep 3, 2015 at 17:52
