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: tnsping works, SQL/Plus does not

Re: tnsping works, SQL/Plus does not

From: Cory Phillips <cory_at_localhost.localdomain>
Date: 2 Sep 2001 23:46:19 -0600
Message-ID: <slrn9p6302.fpi.cory@localhost.localdomain>


I'm not sure that's really possible. I don't have 8i. Maybe it's just possible that the Personal Oracle 8 download was messed up. I do have the jdk version 1.2.2 installed. I noticed Oracle installs a JRE version 1.1. I updated my PATH environment variable and CLASSPATH so it would not be referencing any part of JDK1.2, but it didn't help.

On 2 Sep 2001 06:39:57 -0700, Justin Cave <jocave_at_yahoo.com> wrote:
>cory_at_localhost.localdomain (Cory Phillips) wrote in message news:<slrn9p1dtt.1iu.cory_at_localhost.localdomain>...
>> When I started SQL Plus, it was unresponsive for a few minutes, then it
>> reported "Could not resolve Service name".
>> ORA-12154: TNS:could not resolve service name
>>
>> I searched my hard drive and found two tnsnames.ora files. I already
>> had my connect string set up in one but not the other, so I also added
>> it to
>> d:\bin\orawin95\net80\admin\tnsnames.ora
>>
>> So now I have both d:\bin\orawin95\net80\admin\tnsnames.ora and
>> d:\bin\orawin95\network\admin\tnsnames.ora. So which is it anyway?
>> Net80 or Network?
>
>I'm really suspicious of your directory structure. It would appear
>that you have installed both an Oracle 8.0.x and 8.1.x in the same
>Oracle home. The Oracle 8.0.x client uses the net80 directory while
>the 8i client uses the network directory. If you actually have both
>versions installed, they're stomping all over each other, ensuring
>that neither will work. The only way to resolve this sort of conflict
>would be to get rid of all the Oracle software on your machine and
>re-install.
>
>Justin Cave

-- 
Cory Phillips
cory_h_phillips_at_yahoo.com
Received on Mon Sep 03 2001 - 00:46:19 CDT

Original text of this message

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