Re: Personal Oracle 8i/Dev6i question
Date: Fri, 02 Mar 2001 18:04:35 +0100
Message-ID: <shkv9tol0p6qialaf7hpd1g02vvls8ohi6_at_4ax.com>
On Fri, 02 Mar 2001 15:22:41 GMT, lhpbd_at_earthlink.net wrote:
>Hey all,
>
> I currently have Personal Oracle 8i and Developer 6i installed
>on a Win98 machine. The database is in one Oracle home, the developer
>tools in another Oracle home. Here is my question:
>
>- I start the listener, then the database, yet I can not get
>Forms/Reports to find the the database. When I try to connect I get
>the following error: "TNS: could not resolve service name" or "TNS:
>could not connect to destination". I am using the service names
>listed in the TNSNAMES.ora file, but apparently something is missing.
>Help!
>
>Thanks in advance,
>Chris
You did make sure but Oracle_home\network\admin directories have a
tnsnames.ora or you did make sure the registry var TNS_ADMIN is set to
one of those directories?
You probably now have different tnsnames.ora, as during installation a
default one is being copied to the admin directory.
Hth,
Sybrand Bakker, Oracle DBA Received on Fri Mar 02 2001 - 18:04:35 CET