# RAC 11gR2 not able to talk with Toad Client

**URL:** <https://forums.toadworld.com/t/rac-11gr2-not-able-to-talk-with-toad-client/29629>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [April 3, 2014, 12:59pm UTC](https://forums.toadworld.com/t/rac-11gr2-not-able-to-talk-with-toad-client/29629 "2014-04-03T12:59:07Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![benu.dutta](https://avatars.discourse-cdn.com/v4/letter/b/edb3f5/32.png) [@benu.dutta](https://forums.toadworld.com/u/benu.dutta)\
**Post date:** [April 3, 2014, 12:59pm UTC](https://forums.toadworld.com/t/rac-11gr2-not-able-to-talk-with-toad-client/29629/1 "2014-04-03T12:59:07Z")

</div>

Hi please can you tell me how to configure toad for 11gR2 three node cluster database (Oracle) - am unable to configure.

---

<div class="post-metadata">

**Author:** ![Bert\_Scalzo](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bert_scalzo/32/274_2.png) [@Bert\_Scalzo](https://forums.toadworld.com/u/Bert_Scalzo)\
**Post date:** [April 3, 2014, 1:25pm UTC](https://forums.toadworld.com/t/rac-11gr2-not-able-to-talk-with-toad-client/29629/2 "2014-04-03T13:25:44Z")

</div>

As long as you have a properly configured tnsnames.ora file with no errors and correct entries for a RAC cluster - then Toad works just fine. Nothing special required.

---

<div class="post-metadata">

**Author:** ![benu.dutta](https://avatars.discourse-cdn.com/v4/letter/b/edb3f5/32.png) [@benu.dutta](https://forums.toadworld.com/u/benu.dutta)\
**Post date:** [April 3, 2014, 1:32pm UTC](https://forums.toadworld.com/t/rac-11gr2-not-able-to-talk-with-toad-client/29629/3 "2014-04-03T13:32:12Z")

</div>

Thank you Bert - can you paste any examples - as even on Direct connection it is failing. I have entered all the host details too on Toad client machine - still unable to connect to DB server on RAC

---

<div class="post-metadata">

**Author:** ![Bert\_Scalzo](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bert_scalzo/32/274_2.png) [@Bert\_Scalzo](https://forums.toadworld.com/u/Bert_Scalzo)\
**Post date:** [April 3, 2014, 1:37pm UTC](https://forums.toadworld.com/t/rac-11gr2-not-able-to-talk-with-toad-client/29629/4 "2014-04-03T13:37:33Z")

</div>

Just so we’re clear - this is not a toad problem or bug. This is a simple don’t know how to setup oracle tnsnames.ora file issue. I will help - just want to make sure you understand this is basic oracle sqlnet confiuration file setup issue.

Below are tnsnames.ora entries for a two node RAC cluster. If you are using SCAN then you would not need the RACVIP entry. Likewise if you are using VIP then you would not need the RACSCAN entry. So if I’m using VIP, then I connect 99% of time to Toad (or sqlplus or whetever) using the VIP entry - so that oracle can load balance me to best node. If I need to perform some node specific DBA task - then I’d connect using RAC1 or RAC2 depending on which node I want to direct connect to.

RACSCAN =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = rac)(PORT = 1521))

(LOAD\_BALANCE = yes)

(CONNECT\_DATA =

(SERVER = DEDICATED)

(SERVICE\_NAME = RAC)

)

)

RACVIP =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip)(PORT = 1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip)(PORT = 1521))

(LOAD\_BALANCE = yes)

(CONNECT\_DATA =

(SERVER = DEDICATED)

(SERVICE\_NAME = RAC)

(FAILOVER\_MODE =

(TYPE = SELECT)

(METHOD = BASIC)

(RETRIES = 180)

(DELAY = 5)

)

)

)

RAC1 =

(DESCRIPTION =

(ADDRESS\_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = rac1)(PORT = 1521))

)

(CONNECT\_DATA =

(SERVICE\_NAME = RAC)

(INSTANCE\_NAME = RAC1)

)

)

RAC2 =

(DESCRIPTION =

(ADDRESS\_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = rac2)(PORT = 1521))

)

(CONNECT\_DATA =

(SERVICE\_NAME = RAC)

(INSTANCE\_NAME = RAC2)

)

)

---

<div class="post-metadata">

**Author:** ![damir.vadas\_250](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/damir.vadas_250/32/37_2.png) [@damir.vadas\_250](https://forums.toadworld.com/u/damir.vadas_250)\
**Post date:** [April 4, 2014, 2:19am UTC](https://forums.toadworld.com/t/rac-11gr2-not-able-to-talk-with-toad-client/29629/5 "2014-04-04T02:19:27Z")

</div>

1. can you ping that server. Example:

ping xxx

ping -a xxx

1. can you telnet that server on that port (where listener is, mostly 1521). Example:

telnet xxx 1521

(leave space as they are)

if 1 and 2 are true then adopt your tnsnames.ora with Bert suggestion.

Otherwise ask for some admin help (you are firewalled or you do not know listener port)
