Oracle have dropped support for Oracle Names. It's no longer a product. It's
been replaced by Oracle Internet Directory (OID) which is an ldap server,
but with enough Oracle initial data to make it slightly difficult to use a
vanilla ldap server.
OID is a pig. It's unreliable and corrupts your TNS data. Also, the
redundancy features in the sqlnet client part don't work with some
application servers, coldfusion in particular. So your limited to a single
point of faliure. i.e. you can only point your client at one TNS server
(like having one DNS server) , so when you want to do maintanance on your
TNS server it a big deal. And believe me you'll want to do maintenance.
Regularly.
You would have to be career-suicidal to want to use it for servers, there
may be some value in having people's PCs point to an OID server, especially
if you have a lot of them, but for the machines that your databases run on,
stick with a good old fashioned tnsnames.ora file.
----- Original Message -----
From: "MOORE Peter (ACP) "
<oracledba-ezmlmshield-x72545018.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Wednesday, April 06, 2005 2:04 PM
Subject: RE: centralized tnsnames.ora
> I'm with you Kevin.
>
> The easiest way to manage a localized naming architecture is to use Oracle
> Names server.
>
> ------------------------------------------
> Atos Origin
> Peter Moore
> Systems DBA
> peter.c.[Email address protected]
> ------------------------------------------
>
>
> -----Original Message-----
> From: O Donnell Kevin
> [mailto:oracledba-ezmlmshield-x11018406.[Email address protected]
> Sent: 06 April 2005 13:12
> To: LazyDBA Discussion
> Subject: RE: centralized tnsnames.ora
>
> On the same note whats everyones take on the names server?
>
> -----Original Message-----
> From: Anandha_Kumaran
> [mailto:oracledba-ezmlmshield-x81665271.[Email address protected]
> Sent: Wednesday, April 06, 2005 7:53 AM
> To: LazyDBA Discussion
> Subject: RE: centralized tnsnames.ora
>
> Hi All,
>
> I believe this is better than and mapping the drive in network.
> Thanks to everyone.
>
> Rgds
> Anand
>
> -----Original Message-----
> From: Deepak Panda
> [mailto:oracledba-ezmlmshield-x83310518.[Email address protected]
> Sent: Wednesday, April 06, 2005 5:06 PM
> To: LazyDBA Discussion
> Subject: Re: centralized tnsnames.ora
>
> Yes it can be done. for that you need to set the TNS_ADMIN environment
> variable pointing to the new location.
>
> Hope this helps.
>
> Regards
>
> Deepak
>
>
>
> ----- Original Message -----
> From: "Anandha_Kumaran "
> <oracledba-ezmlmshield-x68748962.[Email address protected]
> To: "LazyDBA Discussion" <[Email address protected]
> Sent: Wednesday, April 06, 2005 4:47 PM
> Subject: centralized tnsnames.ora
>
>
>> Hi All,
>>
>> Is it possible to have tnsnames.ora in server (centralized) and access
>
>> it from the client tnsnames.ora (just pointing to the server's)?
>> How to do that?
>> Any sample available?
>>
>> Rgds
>> Anand
>> **********************************************************************
>> **** This email (including any attachments) is intended for the sole
>> use of the intended recipient/s and may contain material that is
>> CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance
>> by others or copying
> or
>> distribution or forwarding of any or all of the contents in this
>> message
> is
>> STRICTLY PROHIBITED. If you are not the intended recipient, please
>> contact the sender by email and delete all copies; your cooperation in
>
>> this regard is appreciated.
>> **********************************************************************
>> ****
>>
>>
>> --------
>> website: http://www.LazyDBA.com
>> Please don't reply to RTFM questions
>> Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
>
>> see http://www.lazydba.com/unsubscribe.html
>> To subscribe: see http://www.lazydba.com By using this list you agree
>
>> to these
> terms:http://www.lazydba.com/legal.html
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
> see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com By using this list you agree to
> these terms:http://www.lazydba.com/legal.html
> ************************************************************************
> **
> This email (including any attachments) is intended for the sole use of the
> intended recipient/s and may contain material that is CONFIDENTIAL AND
> PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying
> or
> distribution or forwarding of any or all of the contents in this message
> is
> STRICTLY PROHIBITED. If you are not the intended recipient, please contact
> the sender by email and delete all copies; your cooperation in this regard
> is appreciated.
> ************************************************************************
> **
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
> see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com By using this list you agree to
> these terms:http://www.lazydba.com/legal.html
>
>
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com To unsubscribe: see
> http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com By using this list you agree to
> these terms:http://www.lazydba.com/legal.html
>
>
> _______________________________________________________
>
> This e-mail and the documents attached are confidential and intended
> solely for the addressee; it may also be privileged. If you receive this
> e-mail in error, please notify the sender immediately and destroy it.
> As its integrity cannot be secured on the Internet, the Atos Origin group
> liability cannot be triggered for the message content. Although the
> sender endeavours to maintain a computer virus-free network, the
> sender does not warrant that this transmission is virus-free and will
> not be liable for any damages resulting from any virus transmitted.
> _______________________________________________________
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
>
Oracle LazyDBA home page