Re: ORA-12154: TNS:could not resolve service name

Thanks. The first one suit my needs, I guess. I just didn't want to copy the tnsnames.ora to all existing homes, every time I change something.

iulian

"Karsten Farrell" <kfarrell_at_medimpact.com> wrote in message news:7sYt9.556$nh1.32699675_at_newssvr13.news.prodigy.com...
> iulian wrote:
> > Hi guys. My problem is:
> > I installed Oracle Server 9i and Developer Forms & Reports 6i on the
same
> > machine, in this order, and now there are 2 oracle homes OraHome90 and
> > OraDev.
> > I keep getting this error (ORA-12154: TNS:could not resolve service
name)
> > when I try to connect using Forms Builder, or a third party Oracle
client or
> > SQLPlus in OraDev. Yet, I am able to connect using the SQLPlus in the
> > OraHome90 or Entrprise Manager.
> > I've created an entry in tnsnames.ora in OraHome90 pointed to my server,
but
> > not similar one in the OraDev. I made the OraHome90 the default home.
What
> > else? What did I miss?
> > Thanks in advance.
> >
> > iulian
> >
> >
> BTW, I removed all but one of your cross-posts ... so you'll only see my
> answer here. Most of the regulars monitor all the NGs you cross-posted to.
>
> You have two choices:
>
> 1. Set TNS_ADMIN environment variable to your OraHome90. That will tell
> all your software in OraDev to look over there. Of course, you'll have
> to make sure your OraHome90 tnsnames.ora has all the necessary entries
> from your OraDev tnsnames.ora.
>
> 2. Make one copy with all the necessary entries from both and copy that
> one to *every* other tnsnames.ora you can find. In Windows, do a Start /
> Search (or Find); in Unix do a 'find $ORACLE_HOME -name tnsnames.ora
> -print'. They should all be identical.
>
Received on Thu Oct 24 2002 - 15:20:39 CDT