We have a RAC environment. We have granted the following:
1. execute to public on DBMS_DEBUG
2. alter any Procedure
3. create any Procedure
But we are still receiving an error when connecting to a specific RAC instance:
"ORA-12154: tns: could not resolve service name."
And then:
"Cannot connect debug session. In order to debug when connected to a RAC instance you must have entries for the Individual RAC instances in your tnsnames.ora file or connect directly to an individual RAC instance."
Sample tns entries:
open.ttn.com =
(DESCRIPTION =
(LOAD_BALANCE = yes)
(ADDRESS = (PROTOCOL = TCP)(HOST = abcd1234.ttn.com)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = abcd1235.ttn.com)(PORT = 1521))
(CONNECT_DATA = (SERVICE_NAME = open.ttn.com)))
open1,open1.ttn.com=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = abcd1234.ttn.com)(PORT = 1521))
(CONNECT_DATA = (SID = open1)))
open2,open2.ttn.com =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = abcd1235.ttn.com)(PORT = 1521))
(CONNECT_DATA = (SID = open2)))
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center