Re: TNSNAMES.ORA

averste_at_helios.uni-muenster.de (Michael Averstegge) wrote:

>Hi,
 

>I got a CD-Licence with no docu. So I bought "Oracle DB Handbook".
>They write on page 418 to use SQL*Net V2 Configuration tool.
>But I can not find $ORACLE_HOME/network/config/ncsschema.sql.
>Also I can not find it on the CD.
 

>At least, if I write a tnsnames.ora by myself, I do not know
>where to copy it (server and user need a copy).

Actually only clients need tnsnames.ora. Servers only need listener.ora. The only time a server needs tnsnames.ora is if it's also needs to connect to another instance.

Both files go in $ORACLE_HOME/network/admin along with sqlnet.ora. There should also be a subdirectory under this called 'sample'. You can use the files in there as starting points for the ones you need to create.

BTW I tried to use the Windows version of the configuration tool. It was such a pain to use that I gave up and just configured everything by hand. They either need an easier interface, or better documentation on it. Perhaps a small Concepts Manual for sqlnet v.2 is what's really needed. Something that explains all the terms and shows how things fit together.

--
Chuck Hamilton
chuckh_at_ix.netcom.com

Never share a foxhole with anyone braver than yourself!