My only problem with TNSManager is that it cuts off anything after the first period. I have databases in several areas that have inherited their local names, such as prod.gr, prod.fr, prod.uk, prod.na, and prod.jp. TNSmanager handles them all as prod.world which makes it a problem for me. Dick Goulet Senior Oracle DBA/NA Team Lead PAREXEL International ________________________________ From: Vishal Gupta [mailto:vishal@xxxxxxxxxxxxxxx] Sent: Sunday, October 25, 2009 12:30 PM To: jkstill@xxxxxxxxx; Goulet, Richard Cc: jifjif@xxxxxxxxx; sundarmahadevan82@xxxxxxxxx; Oracle-L@xxxxxxxxxxxxx Subject: RE: tnsManager Vs OID I am beginning to like tnsManager. I did not knew about this utility. But i think it does everything which one might expect it do in a enterprise class environment. And its simple enough in its implementation. Kudos to Andy Barry. - Provides high availability implementation by allowing multiple tnsManager instances. - Allow automatic synchronization between different tnsManager instances. I dont know how it scales in terms of scalability. If performance is all right then its perfect. Regards, Vishal Gupta From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jared Still Sent: 25 October 2009 15:31 To: Richard.Goulet@xxxxxxxxxxx Cc: jifjif@xxxxxxxxx; sundarmahadevan82@xxxxxxxxx; Oracle-L@xxxxxxxxxxxxx Subject: Re: tnsManager Vs OID Ditto. Oracle Names was indeed superior to OID for naming purposes. Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist Oracle Blog: http://jkstill.blogspot.com Home Page: http://jaredstill.com On Sun, Oct 25, 2009 at 5:43 AM, Goulet, Richard <Richard.Goulet@xxxxxxxxxxx> wrote: They did, it was called ONames till some BOZO convinced them that LDAP was the future. Dick Goulet Senior Oracle DBA/NA Team Lead PAREXEL International ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of ~Jeff~ Sent: Sunday, October 25, 2009 3:52 AM To: sundarmahadevan82@xxxxxxxxx; Oracle-L@xxxxxxxxxxxxx Subject: Re: tnsManager Vs OID tnsManager just uses a tnsnames.ora file , no database required. Its a shame Oracle didn't make OID so elegantly simple! 2009/10/25 sundar mahadevan <sundarmahadevan82@xxxxxxxxx> From Alan's reply, Am I correct in understanding that OID requires an oracle database for names resolution. But with respect to tnsManager, I do not think it requires a database. On Fri, Oct 23, 2009 at 7:28 PM, Guillermo Alan Bort <cicciuxdba@xxxxxxxxx> wrote: > Plus you get the basic memory footprint of an Oracle Database... I don't > reckon you will need much memory... but at least 200MB... > > cheers. > Alan Bort > Oracle Certified Professional -- //www.freelists.org/webpage/oracle-l