Auto Debugger and trace don't work

Toad for Oracle & DevOps Toolkit
1

Hi
I’m trying to use debug option with a procedure. But when I press execute, it shows this message “UNABLE TO FIND RAC CONNECTION INFORMATION FOR RACCELR (INST_ID=2)”
I found some information and it says that Oracle doesn’t support debugging accros RAC instances
We have a RAC instances and It works without any problem. What can I do to sort it out?
This is the tnsnames that i’m using

RACCELR.CLINICAROSARIO.COM.CO =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.102)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.105)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = raccelr)
)
)

Thank you so much por your help

2

Message from: GTDG

Toad requires that all instances of your RAC be listed in your TNSNames file. In
order to debug in a RAC environment, the target session and debug sessions need
to be on the same instance as your main session (an Oracle requirement). In
order for us to create these sessions on the correct session, they need to be
listed as individual entries. Greg

Historical Messages

Author: Gregory Liss
Date: Thu Sep 22 08:41:13 PDT 2011
Toad requires that all instances of your RAC be listed in your TNSNames file. In
order to debug in a RAC environment, the target session and debug sessions need
to be on the same instance as your main session (an Oracle requirement). In
order for us to create these sessions on the correct session, they need to be
listed as individual entries. Greg
__

Author: falujar
Date: Thu Sep 22 08:34:15 PDT 2011
Hi
I’m trying to use debug option with a procedure. But when I press execute,
it shows this message “UNABLE TO FIND RAC CONNECTION INFORMATION FOR
RACCELR (INST_ID=2)”
I found some information and it says that Oracle doesn’t support debugging
accros RAC instances
We have a RAC instances and It works without any problem. What can I do to sort
it out?
This is the tnsnames that i’m using

RACCELR.CLINICAROSARIO.COM.CO =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.102)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.105)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = raccelr)
)
)

Thank you so much por your help

__

3

Toad requires that all instances of your RAC be listed in your TNSNames file. In order to debug in a RAC environment, the target session and debug sessions need to be on the same instance as your main session (an Oracle requirement). In order for us to create these sessions on the correct session, they need to be listed as individual entries.

Greg

4

Hi Greg,

I too faced the same error message “UNABLE TO FIND RAC CONNECTION INFORMATION FOR RACCELR (INST_ID=2)” while using the debug option. It was working fine before on RAC with two node environment but all of sudden when i used today it throws an error message.

I followed your advice by creating additional entries in tnsnames.ora for each RAC nodes, without load balancing. But still i am facing the same error message.

Following is the tns entries.

Actual Entry

RAC =

(DESCRIPTION =

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

(FAILOVER=on)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = mcmsdrac)

(FAILOVER_MODE = (TYPE = SELECT)(METHOD = BASIC)(RETRIES = 180)(DELAY = 5))

)

)

Instance 1

RAC1 =

(DESCRIPTION =

(ADDRESS =

(PROTOCOL = TCP)

(HOST = xx.xx.xxx.xx)

(PORT = 1521)

)

(CONNECT_DATA =

(SERVICE_NAME = mcmsdrac)

(instance_name = mcmsdrac1)

)

)

Instance 2

RAC2 =

(DESCRIPTION =

(ADDRESS =

(PROTOCOL = TCP)

(HOST = xx.xx.xxx.xx)

(PORT = 1521)

)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = mcmsdrac)

(instance_name = mcmsdrac2)

)

)

Please help me to get rid out of this issue.

Thanks & Regards