I tend to agree with justin. In addition sqlplus shouldn't run java anyway,
It isn't (yet ) a java based product. Can you do what Justin suggests
unistall oracle completely using the universal installer, then delete all
oracle directories that might remain, then delete HKLM\software\oracle from
the registry. Having done this reinstall and try again.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Cory Phillips" <cory_at_localhost.localdomain> wrote in message
news:slrn9p6302.fpi.cory_at_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 - 03:45:44 CDT
