I'd be prepared to bet that you have either (or both of) ONAMES and HOSTNAME
set in sqlnet.ora under NAMES.DIRECTORY_PATH before (or instead of)
TNSNAMES, in which case you would be using either a names server or
hostnaming.
sounds like a network administration OCP question to me.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"praty" <fullyamazed_at_hotmail.com> wrote in message
news:32d49be5.0211221244.7a136035_at_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 Mon Nov 25 2002 - 03:41:21 CST
