Re: Getting Ora 12203 when connecting from Discoverer
From: Frank van Bortel <fbortel_at_home.nl>
Date: Thu, 27 Dec 2001 20:58:39 +0100
Message-ID: <3C2B7D6F.3C517E97_at_home.nl>
Date: Thu, 27 Dec 2001 20:58:39 +0100
Message-ID: <3C2B7D6F.3C517E97_at_home.nl>
anil chada wrote:
>
> Sybrand --
>
> Thanks for the information. Actaully after doing couple of tests, i
> found out that it is not looking at tnsnames.ora file located on
> oraHome816, it is still looking at net80/admin directory in ora_disc
> oracle home. That means TNS_ADMIN value in windows registry is not
> working...
>
> By any chance do you know why it not looking at TNS_ADMIN variable.
>
> to setup TNS_ADMIN value i used regedit...
> went to HKEY_LOCAL_MACHIINE\SOFTWATE\ORACLE\HOME3 and added TNS_ADMIN
> value.
>
> HOME3 is pointing to C:\oracle\discoverer home.
>
<snip>
[Quoted] [Quoted] are you switching homes? Don't. And add tns_admin 1 level up:
HKLM\Software\Oracle
-- Gtrz, Frank van BortelReceived on Thu Dec 27 2001 - 20:58:39 CET