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
��� ����� <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
03/05/02 07:48 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
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
[EMAIL PROTECTED]
> -----Original Message-----
> From: Karniotis, Stephen [SMTP:[EMAIL PROTECTED]]
> 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: [EMAIL PROTECTED]
> 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 " <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 03/04/02 01:38 PM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> 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,B�m����
(��ک�&�a��
2Z��R�)e��b�+ �aZ�(���I��Ǭ�9��t�Q@_�|�9ӝRjp�z
jX����h���'���ZqǬ���X�������DCTL��� ���ka�ɚ�X��X��ǧu��1����,j����
�k����r+rr���ׄ\�����)���Ѯ��v)�鞲Ơx�b)ܖ�^jX�y�'����x5%9,B��^��
�����X��X��*.�����ޭ騽�_�����ɩl�ǧv�^ B�r��jw_��-����+��b�yb��.n�+���
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Freeman, Robert
INET: [EMAIL PROTECTED]
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: [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).
