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

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Fri, 25 Oct 2002 00:28:56 +0200
Message-ID: <gvsgru4977gm2guvb0f09393chfp025ka8@4ax.com>

On Thu, 24 Oct 2002 19:44:51 GMT, "iulian" <4spam_at_mail.com> 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
>

1 Searching the newsgroup archives before posting 2 setting the registry var TNS_ADMIN to the correct directory, as documented.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Oct 24 2002 - 17:28:56 CDT