Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: where does an oracle installation keep its server name?

Re: where does an oracle installation keep its server name?

From: praty <fullyamazed_at_hotmail.com>
Date: 22 Nov 2002 12:44:33 -0800
Message-ID: <32d49be5.0211221244.7a136035@posting.google.com>


It does not exist in the files you mentioned!! The hostname/sid foo simply does not exist anywhere in sqlnet.ora and tnsnames.ora. Makes me curious!

Thanks,
Praty
TurkBear <john.greco_at_dot.state.mn.us> wrote in message news:<3qfqtuk8om65rl9nfcr65slesi7lvsmla7_at_4ax.com>...
> Look for foo as an alias in your tnsnames.ora file and
> mycompany.com as a names default domain in sqlnet.ora
>
> Try connecting with just foo
>
>
> fullyamazed_at_hotmail.com (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
Received on Fri Nov 22 2002 - 14:44:33 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US