Attempting to kill a RAC session from Session Browser, but receive error:
"No tnsnames entry found for instance 'instance_name' - SQL no executed"
No entry for the individual RAC instance is recorded in the tnsnames.ora
Add entries for each RAC instance in the tnsnames.ora file:
Example:
RAC, two nodes
tnsnames.ora:
RAC_FGL1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = node1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RAC)
(INSTANCE_NAME = ins_name1)
)
)
RAC_FGL2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = node2)(PORT = 1522))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RAC)
(INSTANCE_NAME = ins_name2)
)
)
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center