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

2003-08-14 Thread Wolfe Stephen S GS-11 6 MDSS/SGSI
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
[EMAIL PROTECTED]
(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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).


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

2003-08-14 Thread Jared Still
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
 [EMAIL PROTECTED]
 (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: [EMAIL PROTECTED]
 
 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).