Re: A real newbie DBA question on setting up a 9i client

host name, SQLNET listener port(s), and the service name or SID of the database.

Why not just use the sqlnet assistant to create the tnsnames.ora file for you? It works pretty well for the most part.

Then copy the file to a common network drive so that all clients don't require individual tnsnames.ora files. You don't want to go down that road, as it makes changes very difficult.

HTH Jared

On Wed, 2003-08-13 at 11:09, Wolfe Stephen S GS-11 6 MDSS/SGSI wrote:
> When I configure an 8i client to attach to an Oracle database, I always
> have the
> The service name which has always been the database/instance name -- I
> assume these don't necessarily have to be the same, but it appears to be
> that way for single database applications.
>
> I also have the host name which has always been the NetBIOS name of the
> hosting W2K server.
>
> So here is the question, is that all I need to configure the client if I
> know I'm going to connect using TCP for a 9i client?
>
> v/r
>
> Stephen S. Wolfe, GS-11, DAFC
> Data Services Manager
> stephen.wolfe_at_macdill.af.mil
> (813) 827-9974 DSN 651-9974
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Wolfe Stephen S GS-11 6 MDSS/SGSI
> INET: Stephen.Wolfe_at_macdill.af.mil
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).