REPOST: Re: Perl Crashes with large tnsnames.ora

From: TurkBear <jgreco1_at_mn.rr.com>
Date: Fri, 25 Jan 2002 16:11:31 -0600
Message-ID: <7$--$%%%_$___$_%%$@news.noc.cabal.int>

In fact you may want to move directly to a Directory Services ( of some flavor ) model, since Oracle has indicated a limited life for Oracle Names...

Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote:

>On 25 Jan 2002 11:40:55 -0800, craig.stalsberg_at_uscellular.com (Craig
>Stalsberg) wrote:
>
>>We have having a problem with PERL programs crashing trying to connect
>>with Oracle when we have a large number of entries in our tnsnams.ora
>>file. I believe the largest number allowed is somewhere around 165.
>>We are using Perl 5.005_03 on HP-UX 10. Anyone run into this problem?
>> How did you solve the problem?
>>
>>Craig Stalsberg
>>US Cellular
>
>1 Obviously this is a problem with Perl, not with Oracle
>2 anyone having more than 10-20 service names in a tnsnames.ora should
>consider setting up Oracle Names. It is easy enough to do so.
>I can't see any reason why anyone would voluntarily maintaining 165
>service names in tnsnames.ora, this is just asking for trouble.
>
>Regards
>
>Sybrand Bakker, Senior Oracle DBA
>
>To reply remove -verwijderdit from my e-mail address

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! Check out our new Unlimited Server. No Download or Time Limits! -----== Over 80,000 Newsgroups - 19 Different Servers! ==-----

WAS CANCELLED BY =======: From: TurkBear <jgreco1_at_mn.rr.com> Control: cancel <qtl35ukecir1i2j38d573nb126mmcak8rh_at_4ax.com> Subject: cmsg cancel <qtl35ukecir1i2j38d573nb126mmcak8rh_at_4ax.com> Date: Mon, 28 Jan 2002 02:32:50 GMT Message-ID: <cancel.qtl35ukecir1i2j38d573nb126mmcak8rh_at_4ax.com> X-No-Archive: yes Newsgroups: microsoft.test,alt.flame.niggers,comp.databases.oracle.misc NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88 Lines: 1 Path: news.uni-stuttgart.de!news.fh-hannover.de!comnets.rwth-aachen.de!news.rwth-aachen.de!news-koe1.dfn.de!news-fra1.dfn.de!news-lei1.dfn.de!newsfeed.freenet.de!news.stealth.net!msrtrans1!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp03!u&n&a&c&anceller Xref: news.uni-stuttgart.de control:40716333

This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers. Received on Fri Jan 25 2002 - 16:11:31 CST