While debugging on RAC an error is raised prompting "Unable to find RAC connection information for the database name, (used ID=1)"
When debugging on RAC, Toad needs to make a 2nd connection to the same instance on the RAC cluster.
Solution 1:
Ensure Toad can select from GV$INSTANCE and GV$LISTENER_NETWORK, Toad can create a connect string and make the connection.
1. Have the DBA run these grant statements for the user:
GRANT SELECT ON GV$LISTENER_NETWORK to BN_DOWNSTREAM;
GRANT SELECT ON GV$INSTANCE to BN_DOWNSTREAM;
Solution 2:
Ensure Toad retrieves a TNSNAMES entry for a specific instance, so as to use that.
2. Assuming you have a TNSNAMES entry like this:
instance=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=some_server)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=instance)))
create others like it that connect directly to each instance of the RAC cluster.
Make as many as you need to cover all of the instances.
instanc1 =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=some_server )(PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=instance)(INSTANCE_NAME=instance1)))
instance2 =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=some_server )(PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=instance)(INSTANCE_NAME=instance2)))
