RE: Names server

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.
>
> --

ÿóåy«±ç­…ê~'"jS‘ Received on Tue Mar 05 2002 - 12:28:29 CST