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

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.