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 - 07:42:48 CST
