Toad World® Forums

Auto Debugger and trace don't work

Message from: falujar

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


Historical Messages

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

__