| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Names server
We switched to names server last year. We had our NT administrator net use
to each client in the company (effectively assigning a drive to the
administrators machine) and copy the sqlnet.ora over to the remote
machine. Fired up about 10 machines and updated > 1000 systems in three
different waves. Worked
pretty smooth.
RF
Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him.
-----Original Message-----
Sent: Tuesday, March 05, 2002 1:28 PM
To: Multiple recipients of list ORACLE-L
Yechiel,
That's all well and good if you get to set it up from the beginning.
I inherited it. Tnsname.ora everywhere. Different desktops with
different names for the
same databases. It's a nightmare. I plan to setup Onames when I get a
chance to do so.
Putting tnsnames.ora on network file servers wouldn't work so well. We
have offices
( and users ) in Asia, North America, Europe and the Middle East.
At least I only have hundreds of desktops to deal with rather than thousands.
Jared
<adary_at_mehish.co.il>
Sent by: root_at_fatcity.com
03/05/02 07:48 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
cc:
Subject: RE: Names server
Hello All
I saw some remarks about updating tnsnames on many desktops. Why would you have tnsnames in every machine? I put our client software on a central server, with the tnsnames. One update to the tnsnames in the server apply to all. Installing for a new PC is importing the registry entries and add two paths to the search list, done in two minutes.
Yechiel Adar, Mehish Computer Services
adary_at_mehish.co.il
> -----Original Message-----
> From: Karniotis, Stephen [SMTP:Stephen_Karniotis_at_compuware.com]
> Sent: Tue, March 05, 2002 4:29 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Names server
>
> I agree with everyone. Oracle Names saved many days/months of
maintenance
> time in migrating new TNSNAMES to over 30000 desktops. The only gotchas
> with ON was the creation of a separate Administrative database and 24x7
> maintenance of it. With the new extensibility features not requiring a
> database, that job was made much easier.
>
> However, the move to LDAP will benefit you even more because all you
need
> to
> do is put an entry in the directory server for the instances and "magic"
> occurs. I personally hate the concept of the TNSNAMES file because if
> violates the "knowledge" security standard of knowing what databases are
> within the environment. Any savvy user can figure out how to hack in
once
> they have that kind of information.
>
> Thank You
>
> Stephen P. Karniotis
> Technical Alliance Manager
> Compuware Corporation
> Direct: (248) 865-4350
> Mobile: (248) 408-2918
> Email: Stephen.Karniotis_at_Compuware.com
> Web: www.compuware.com
>
> -----Original Message-----
> Sent: Monday, March 04, 2002 6:08 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Names server
>
> I agree with you Jared. On the last job we had TNSNAMES files out to
> everyones work station ..... got to be a pain. Installed Names,
created
> the right files ..... bingo, all worked . Very easy.
>
> -----Original Message-----
> Sent: Monday, March 04, 2002 4:29 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Completely removing names from Oracle would be a mistake IMO.
>
> Reason: Name is fairly easy to implement, LDAP is anything but.
>
> Jared
>
>
>
>
>
> "Freeman, Robert " <Robert_Freeman_at_csx.com>
> Sent by: root_at_fatcity.com
> 03/04/02 01:38 PM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> cc:
> Subject: RE: Names server
>
>
> Names server is depreciated in 9i, but still there.
> They were going to remove it, but I think there was a bit of a backlash,
> so
> they have delayed
> the removal.
> OID (LDAP) is the replacement.
>
> We use names server here, have found it to be pretty stable and reduced
> tnsnames.ora
> administration nicely.
>
> RF
>
>
> Robert G. Freeman - Oracle8i OCP
> Oracle DBA Technical Lead
> CSX Midtier Database Administration
>
> The Cigarette Smoking Man: Anyone who can appease a man's conscience can
> take his freedom away from him.
>
>
>
> -----Original Message-----
> Sent: Monday, March 04, 2002 3:53 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Names server will be obsolete in 9i, I think.
>
> -----Original Message-----
> Sent: Monday, March 04, 2002 11:33 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi ALL:
> Is any one using names server out there? How the it works? Any
infor
> are wellcome.
>
> --
>W z^r&9,Bm
(ک&a
2ZR)eb+ aZ(IǬ9tQ@_|9ӝRjpz
jXh'ZqǬXDCTL kaɚXXǧu1,j
kr+rrׄ\)Ѯv)鞲Ơxb)ܖ^jXy'x5%9,B^
XX*.ޭ騽_ɩlǧv^ Brjw_-+byb.n+
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: Robert_Freeman_at_csx.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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).Received on Tue Mar 05 2002 - 13:23:24 CST
 |
 |