Re: Weird Problem with Net8 connecting to Oracle Server

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Tue, 11 Dec 2001 06:59:07 +1100
Message-ID: <3c1514d3$0$5901$afc38c87@news.optusnet.com.au>

Excuse me leaping in, but...

If it works from 'test connection', then good... I'd hazard a guess that the Net8 Assistant is writing out a perfectly valid tnsnames.ora.

But then I'm wondering which one you are using when you then try and connect via sqlplus? Are you sure that there isn't another tnsnames.ora lurking somewhere it shouldn't be?

Of course, everything should be sitting in ORACLE_HOME/network/admin... but there is also a TNS_ADMIN environment variable you can set to change that, so I wonder if that has been set, and is therefore pointing at an old tnsnames file that is never being altered by the Net8 Assistant.

Just a thought.
Regards
HJR

--
----------------------------------------------
Resources for Oracle: http://www.hjrdba.com
===============================


"Martin Stephenson" <martinstephenson_at_hotmail.com> wrote in message
news:9v280u$29u$1_at_newstoo.ericsson.se...


> Thanks Niall,

> I changed the alias to LEWIS_PROD and I commented out the auth. link in

> sqlnet.ora but it's still the same

> and it sill works from the Net8 Assistant "Test Connection" function

>

> :o(

>

> M.

>

>

Received on Mon Dec 10 2001 - 13:59:07 CST