praty wrote:
> It looks like a secret to me. Where does oracle client install store
> the server name?
>
> I use the string "foo.mycompany.com" to connect to my oracle instal
> using sqlplus.
>
> However, I cannot find foo.mycompany.com in any of the .ora files in
> the network directory of my client installation! [which includes
> tnsnames.ora, sqlnet.ora, etc.]
>
> FYI, I am using 8.1.7. sqlplus client install downloaded from oracle
> site.
>
> TIA,
> Praty
Don't know if this answers your specific question. I'm assuming you
installed it on a Windows o/s.
It's like the old shell game ... guess which walnut shell the pea is
hidden under. You start by looking in %ORACLE_HOME%\bin\oracle.key,
which contains only one line - a partial registry key (eg,
Software\ORACLE\HOME0). Now open your registry (regedit) and look in
HKLM\Software\ORACLE\HOME0, where you'll most likely find an ORACLE_SID
key, which most likely will point to foo.
Received on Fri Nov 22 2002 - 15:06:11 CST
