I figured it out. I compared the SQLNET.ORA file to the production version
that was working and saw immediate differences. I made them the same and
now all is fine. Thanks!
"Axl" <axl_at_nospam.com> wrote in message
news:tuvkctfqgqlg21_at_corp.supernews.com...
> How do I check to see if I have more than one "tree"?
>
> "Ban Spam" <ban-spam_at_operamail.com> wrote in message
> news:Xns915738ECB9CD9SunnySD_at_24.0.3.73...
> > "Axl" <axl_at_nospam.com> wrote in news:tuvh0fpou9l736_at_corp.supernews.com:
> >
> > > I have been using 8.0.5 client software on my app server to connect to
> > > various Oracle databases in my company. Last week, our network admins
> > > decided to migrate the server to a new box and wanted me to reinstall
> > > the software fresh. The only CD I could find was 8.1.7, which has
> > > turned into a problem. After I installed the software using the
"user"
> > > option, I copied over the tnsnames.ora file from my other box and put
> > > it in the admin folder like usual. I wanted to test the connections,
> > > so I went in to the Net8 Configuration Assistant. I chose Local Net
> > > Service Name configuration, then Test, then I was presented with a
drop
> > > down list of all of the services in my tnsnames.ora file. Each one
> > > tested Ok. However, when I go into SQLPlus on that same machine and
> > > try to login to any of them, I get various errors, most of which are
> > > TNS - Can't resolve service name. I don't understand why it would
test
> > > ok in the Configuration Assistant, but be unable to resolve the name
in
> > > SQLPlus. Can anyone help please?
> > >
> > > Thanks,
> > > Axl
> > >
> > >
> > >
> >
> > One possibility is that you have more than one "ORACLE_HOME" tree,
> > and multiple tnsnames.ora files.
> >
> >
>
>
Received on Mon Nov 12 2001 - 08:03:49 CST
