Re: Unable to connect to Oracle Expert repository
Date: Wed, 14 Aug 2002 12:27:45 GMT
Message-ID: <ajdic2$5o1$1_at_cronkite.cc.uga.edu>
If you've got OEM installed in a separate Oracle_home, and you probably should, try copying your tnsnames.ora and sqlnet.ora files over to its network\admin directory. Chances are it's trying to use a different tnsnames file. You can also try setting TNS_ADMIN in your registry (I've had mixed results with this) under hkey_local_machine/software/Oracle to point to the directory where your tnsnames file is.
In article <10cb5393.0208131852.7ca059c8_at_posting.google.com>,
a_sood_at_rediffmail.com (Ak) wrote:
>Hi,
>I am attempting to connect to the database using Oracle Expert (I am
>not connecting to an OMS repository). I get the following error:
>
>XP-21162: Database connection attempt has failed
>ORA-12154: TNS:could not resolve service name
>
>The connect string in the tnsnames.ora is correct. I can connect to
>the database using other tools. I have two oracle homes on the machine
>running Oracle Expert. The tnsnames.ora file resides under the
>$ORACLE_HOME\net80\ADMIN\ directory.
>
>Thanks!
Received on Wed Aug 14 2002 - 14:27:45 CEST