Re: sqlplus error

From: Puneet Khanna <khannapk_at_hotmail.com>
Date: Thu, 5 Aug 1999 11:50:26 -0400
Message-ID: <7ocbsp$anb$1@nntp3.uunet.ca>

SQLPLUS 8 uses net 8. For net8 do "tnsping80 <alias>" . Easiest way is to use "oracle net8 easy config" add the alias and test the connection.
Also note tnsnames.ora for net8 is in oracle_home/net80/admin directory and for net2 in oracle_home/network/admin

Puneet

Munish <munish_at_my-deja.com> wrote in message news:7oc7l4$c3r$1_at_nnrp1.deja.com...
> Hi,
> I just installed oracle 8i database. When I used sqlplus8i from where
> the database in installed it works fine.
>
> On client machine, I edited the tnsnames.ora file and I did tnsping
> (SID) and it gives me OK. Client are running sqlplus 8. Now when we
> try to connect it to the database (SID) it gives me error
>
> ORA-12154: TNS:could not resolve service name
>
> Any help is appreciated
>
> Thanks
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Thu Aug 05 1999 - 10:50:26 CDT