From: Sybrand Bakker <>
Date: Wed, 18 Feb 2004 23:06:44 +0100
Message-ID: <>

[Quoted] On Tue, 17 Feb 2004 22:00:14 +0100, "Joop Gijsbers" <> wrote:

>I am using a central , shared tnsnames.ora with a multihome Oracle client
>(both 8.1.7 as 9.1.2) on Windows 2000.
>I have set in both user environment as system environment the TNS_ADMIN
>variable directed to the directory of that shared tnsnames.ora (and also
>Dba studio of the 8.1.7 clinet recognizes and uses that central
>tnsnames.ora, but the OEM console (stand alone) says he uses that central
>tnsnames.ora, but in reality when i add a database to the tree, he makes a
>new tnsnames.ora with that entry in c:\oracle\ora92\network\admin and i
>cannot connect to that database, unless i do a manual copy of that entry to
>the central tnsnames.ora.
>I looked in the registry for conflicting TNS_ADMIN enttires, but i did not
>find them.
>Who has a clue?

[Quoted] OEM uses the tnsnames.ora on the management server. It doesn't use the tnsnames.ora on the client. Using the console you can connect to a database even when you don't have a tnsnames.ora entry.

Sybrand Bakker, Senior Oracle DBA
Received on Wed Feb 18 2004 - 23:06:44 CET

Original text of this message