I think your WebDB uses the oracle_home, not the oracle8i_home.
so, the tnsnames.ora used by WebDB would be in a different directory
than the one used by plus V8.1....
Try setting tns_admin - you'll need to create it.
--
Frank
Alessandro Nazzani <alexnsb_at_tin.it> schreef in berichtnieuws
8revi0$inf$1_at_nnrp1.deja.com...
> In article <8repi8$c5l$1_at_porthos.nl.uu.net>,
> "Frank" <frankbo_at_interaccess.nl> wrote:
> > This SQL*plus window - is that on the same machine?
>
> Yes.
>
> > What version SQL*Plus is it? Different versions use
> > different locations for tnsnames.ora files, you know...
>
> 8.1.6.0.0
>
> > Have you introduced tns_admin in your registry?
> > (HKLM\Software\Oracle). Value should be the directory
> > where all you network configurations files reside.
>
> A search in the Registry Editor for "tns_admin" returns no results
> (same on development box). I find "traces" of TNS under:
>
> - HKLM/SYSTEM/CONTROLSET001/ENUM/ROOT LEGACY_ORACLEORAHOME81TNSLISTENER
> (same on dev except here I find a Control key under the 0000 key)
>
> - HKLM/SYSTEM/CONTROLSET001/SERVICES ORACLEORAHOME81TNSLISTENER (same
> on dev except here I find a Enum key)
>
> - HKLM/SYSTEM/CONTROLSET003/ENUM/ROOT LEGACY_ORACLEORAHOME81TNSLISTENER
> (same on dev except here I don't find a Control key under the 0000 key)
>
> - HKLM/SYSTEM/CONTROLSET001/SERVICES ORACLEORAHOME81TNSLISTENER (same
> on dev except here I don't find a Enum key)
>
> - HKLM/CURRENTCONTROLSET/ENUM/ROOT LEGACY_ORACLEORAHOME81TNSLISTENER
> (same on dev)
>
> - HKLM/SYSTEM/CURRENTCONTROLSET/SERVICES ORACLEORAHOME81TNSLISTENER
> (same on dev)
>
> With "same" I mean EXACTLY the same (both Keys and Values).
>
> Under HKLM\Software\Oracle I found the following differences:
>
> - No OLEDB key
> - No OO4O key
> - In the HOME0 key I have the following string value (not present on
> dev):
>
> ORA_PLURIMED_PFILE = "E:\Oracle\admin\plurimed\pfile\initplurimed.ora"
>
> Should it point to
>
> E:\Oracle\Ora81\sysman\ifiles\def_PLURIMED.PLURIMEDIA.IT.ora?
>
> As you can imagine, all the above described stuff comes from the
> installer: I'm not experienced enough to even think about
> modifying/creating it.
>
> Regards, Alessandro.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Oct 04 2000 - 05:44:16 CDT
