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.
>
> --
�y� �筅� ~'"jS� "�,P��i��0�}���`.�+
�%��u+b�Z�v+2��&�B�܍z�(�D����z�9���Nu���w�9�&�'��&���+�&���bp��z�� z�?1���x ��lN�D0�Dʋ���_~�&������x%��lzwZ�C�Y��Ơz� ��F���j�"�'(�z-xE�
;)zYb�
.+-��jwb��^��,j�86"��nu楊w��{Z�x��CRP� "�.���ڙ� ����x%��r����hm�ޚ��u�虊.�����,zwm���,�(�f�u�+��^�)ߢ���*'�) ���r���x
