Hi please can you tell me how to configure toad for 11gR2 three node cluster database (Oracle) - am unable to configure.
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.
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
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)
)
)
- can you ping that server. Example:
ping xxx
ping -a xxx
- 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)