Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: sqlplus error

Re: sqlplus error

From: Eric <admin_at_t10.net>
Date: Thu, 5 Aug 1999 12:16:14 -0700
Message-ID: <37a9c5d1@mindmeld.idcomm.com>


Good step by step:
http://www.orafaq.org/faqnet.htm

Puneet Khanna wrote in message <7ocbsp$anb$1_at_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 - 14:16:14 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US