Re: Oracle Name server

"Al Wilson" <wilson_at_email.chop.edu> wrote in message news:vIuo7.6925$ym4.277752_at_iad-read.news.verio.net...
> So let me understand this...
> I know TNSNAMES.ORA resides on the client workstation. Does that mean
that
> that SQLNET.ORA resides on an Oracle server?
> "Chuck Hamilton" <chuck_hamilton_at_yahoo.com> wrote in message
> news:9nohcr$8vt58$1_at_ID-85580.news.dfncis.de...
> > -----BEGIN PGP SIGNED MESSAGE-----
> > Hash: SHA1
> >
> > "news.pa.verio.net" <wilson_at_email.chop.edu> wrote in message
> > news:knPn7.6706$ym4.269575_at_iad-read.news.verio.net...
> > > I am a PC tech, and I think by the very name, an Oracle Name Server
> > > would be helpful.
> > > Can anyone point me to basic document on what this is and how it is
> > > setup? Or explain it to me? Is it basically an oracle database
> > > itself? Is it a variation of the Domain Name System (DNS)?
> > >
> > >
> >
> > It is similar to DNS but used for resolving oracle database service
> > names to a Net8 address. Net8 clients are configured for which name
> > resolution methods they will use in the sqlnet.ora file. The most
> > common is probably TNSNAMES which is the net8 equivelent of a HOSTS
> > file. It uses a text file to resolve service names to addresses.
> > ONAMES or Oracle Names uses a Names server to perform exactly the
> > same function.
> >
> > A good place to start reading would probably be the Net8
> > Administrators Guide.
> >
> > -----BEGIN PGP SIGNATURE-----
> > Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>
> >
> > iQA/AwUBO5/I0Gm5A4kkb4ZsEQI3FgCcCU46dr3OwXCcaJ4KWnDB92Zvl6oAoOSd
> > /gYjVKjPYPZbapKYOXoSXTif
> > =NQzn
> > -----END PGP SIGNATURE-----
> >
> >
> >

>
>

No,
sqlnet.ora determines some basic net8 configuration parameters. Both client and server need it.
sqlnet.ora determines in which order a service name will be resolved. The default order is : first using tnsnames.ora then using Oracle Names. If you have set up an Oracle Names server you want the order to be : first the Names Server then tnsnames.
sqlnet.ora contains also the address of the names server so the client can contact it.
Please read the manual as indicated above.

Regards,

Sybrand Bakker, Senior Oracle DBA Received on Fri Sep 14 2001 - 17:51:08 CDT