Re pushing the tnsnames.ora out to desktops:
I considered that, but there were too many versions of it out there,
and the users may have ODBC DSN' s dependent on the contents
of their tnsnames.ora.
Re the share drive: Considered that too, but it's too easy for
net admins to re-arrange drives without advance warning.
( it has happened )
I compromised. The tnsnames.ora stays on the desktops.
The sqlnet.ora has this line:
NAMES.DIRECTORY_PATH = (ONAMES, TNSNAMES)
so that their tnsnames will still work, but I can make changes
in the name servers without worrying about their tnsnames files.
Updating the names servers is pretty simple, and I don't have
to schedule a change to all the desktops.
Works for me anyway.
Jared
Stephen Lee <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
06/12/2003 12:01 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: Oracle Names
I never liked names, but that's just me. I thought keeping the names
servers up to date, and making sure every client was configured to use the
name servers, was a pain in the butt. You can have multiple names servers
to eliminate a single point of failure.
The method I liked the best was to have the PC admin people push a new
tnsnames.ora out to client machines using push software. Let THEM fuss
with
it!
Another method that works is to have the tnsnames.ora on a share and stick
a
shortcut on the client desktop that will update the local tnsnames.ora
when
the user clicks on it.
> -----Original Message-----
>
> 1. Are any of you using the Oracle Names?
> 2. Is it as easy to configure as Oracle makes it sound, or is
> it difficult?
> 3. Is Names reasonably robust? I can see this as yet another
> single point of
> failure.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
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:
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).
