Re: novice Oracle 9i tnslsnr problem

From: Karsten Farrell <kfarrell_at_belgariad.com>
Date: Fri, 17 Jan 2003 19:54:08 GMT
Message-ID: <AbZV9.109$id1.9243809@newssvr15.news.prodigy.com>

Paul Brewer wrote:
> "Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message
> news:ppnV9.25058$jM5.66252_at_newsfeeds.bigpond.com...
>

>>
>>This won't work, because it's all over the place as a continuous line of
>>text. Lay it out properly: and I see that Karsten has already posted
>>explaining precisely how to do that.
>>

>
> Howard,
>
> I don't want to pick a fight or anything, but just in the spirit of
> experimentation, (using 816 client IIRC), I once tried putting all the
> details for each alias on one line in the tnsnames.ora file.
>
> It seemed to work fine. My conclusion *then* was that while I have no
> problem with Oracle's formatting, it isn't actually necessary, since
> carriage returns, spaces and tabs are ignored when parsing tnsnames.ora
>
> Was that conclusion wrong?
>
> Regards,
> Paul
>

In fact, when I installed Oracle 9iAS, the following entry was added to one of the many generated tnsnames.ora files:

repserv,repserv.world=(ADDRESS=(PROTOCOL=tcp)(HOST=LF_DEV2)(PORT=1949))

All on one line ... and even a comma-separated alias list. Of course, 9iAS Reports is an 8.0.6 product. Received on Fri Jan 17 2003 - 13:54:08 CST