1

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?

  • 1
    Yes 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
1

As far as I remember when I investigated RAC you need to add the VIP addresses to the DNS.

  • But why is it needed in dns? It talks between the nodes right. – tesla747 Sep 3 '15 at 14:31
  • 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
  • I have put it in DNS. Im still facing sql developer issues though. – tesla747 Sep 4 '15 at 17:14
  • What is the result of tnsping to the database? What is the content of the tnsnames.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
0

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
  • Nope. Not working. – tesla747 Sep 3 '15 at 18:14
  • Ping is working. – tesla747 Sep 3 '15 at 18:15

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.