Re: novice Oracle 9i tnslsnr problem

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Sun, 19 Jan 2003 09:39:49 +1100
Message-ID: <9zkW9.27515$jM5.71482@newsfeeds.bigpond.com>

"Paul Brewer" <paul_at_paul.brewers.org.uk> wrote in message news:3e29ae59_2_at_mk-nntp-1.news.uk.worldonline.com...
> "Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message
> news:D2ZV9.26656$jM5.69480_at_newsfeeds.bigpond.com...
> Howard,
>
> You said (in an earlier posting in this thread):
>
> > If this is really how your tnsnames is formatted, then I'm not surprised
> it
> > fails to resolve the name!
>
> My question followed this, relating to formatting of tnsnames.ora, in
which
> I posted that as far as my (admittedly limited) experiment was concerned,
> carriage returns, whitespace and tabs didn't seem to make much difference
> (this was client-side only, using NT4 816/817).
>

OK, here's my tnsnames.ora:

O81 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = purcell)(PORT = 1521))     )
    (CONNECT_DATA =
      (SERVICE_NAME = O81.aldeburgh.local)     )
  )

(Incidentally, this is on an XP client, connecting to an 8i database on a remote machine).

I try this:

SQL> connect scott/tiger_at_o81
Connected.

Now I edit the tnsnames so it looks like this:

O81 =

(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = purcell)(PORT = 1521))

)
(CONNECT_DATA =
(SERVICE_NAME = O81.aldeburgh.local)
)
)

And I try this:

SQL> connect scott/tiger_at_o81
ERROR:
ORA-12154: TNS:could not resolve service name

Warning: You are no longer connected to ORACLE.

So, just removing the white spaces at the beginning of lines cacks up my ability to connect. I tried this on Windows 2000, too, and with a 9i and 8i database. And the results are the same.

Hence my original comments. But I'm happy to admit that it could be very sensitive to what version and/or platform you're running on.

Regards
HJR
> Not trying to prove a point here, just asking, in an amicable way...
>
> Regards,
> Paul
>
>
>
Received on Sat Jan 18 2003 - 16:39:49 CST