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

"iulian" <4spam_at_mail.com> wrote in message news:<T4Yt9.60384$%h2.10249_at_news02.bloor.is.net.cable.rogers.com>...
> 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

Try this way:

1) Put your TNSNAMES.ORA file in 'c:\'
2) Configure it properly
3) Go to Start-->Run-->cmd (NT) or command (Windows9x)
4) Execute the below command:
      SET TNS_ADMIN=C:\

If it says ok then set this permanently in the Environment Variables.

Regards,
Sagi Received on Tue Oct 29 2002 - 18:32:23 CET