RE: OID and tnsnames.ora

From: Goulet, Richard <Richard.Goulet_at_parexel.com>
Date: Wed, 19 Aug 2009 13:17:18 -0400
Message-ID: <23C4836D8E9C5F4280A66C0C247BC16F2CA27E16_at_US-BOS-MX011.na.pxl.int>

One headache with tnsmanager. It looks at db1.fsg.us and db1.us as the same, namely db1. That was out major headache.

Dick Goulet
Senior Oracle DBA
PAREXEL International

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Bobak, Mark Sent: Wednesday, August 19, 2009 11:31 AM To: genegurevich_at_discover.com; oracle-l_at_freelists.org Subject: RE: OID and tnsnames.ora

Hi Gene,

OID is a bear, and if all you want to do is use it for a centralized repository for service name resolution, I strongly recommend you look at:
http://www.shutdownabort.com/tnsmanager/

It will take about 30 minutes to set up, tops. It doesn't even require installation of an Oracle client.

I've been running it in all environments (dev, preprod, and prod) for over a year. No problems, no hiccups, no crashes.

I love it.

Hope that helps,

-Mark

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of genegurevich_at_discover.com
Sent: Wednesday, August 19, 2009 11:22 AM To: oracle-l_at_freelists.org
Subject: OID and tnsnames.ora

Hello everybody:

Can anyone point me to a document/article/book explaining how to use OID to
resolve service names instead of tnsnames.ora?

thank you

Gene Gurevich

Please consider the environment before printing this email.

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Wed Aug 19 2009 - 12:17:18 CDT