Re: novice Oracle 9i tnslsnr problem

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Thu, 16 Jan 2003 20:40:40 -0000
Message-ID: <3e285cb5$1_1@mk-nntp-1.news.uk.worldonline.com>

"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?

By the way, I subsequently fed that 'compact' tnsnames.ora back into 9201 OEM and it cheerfully put all the formatting back...

Both still work.

Regards,
Paul Received on Thu Jan 16 2003 - 14:40:40 CST