Re: Installing Ora8i and Developer6i on same machine
Date: Mon, 27 May 2002 16:23:25 GMT
Message-ID: <3CF25D77.4155DD11_at_exesolutions.com>
Jerzy Zakrzewski wrote:
> Installing on Win2000
> Installed Developer 6i in c:\ORANT oracle home DEFAULT_HOME
> Installed Oracle 8.1.7 in c:\myOra8i oracle home=myOra8i
> According to Oracle Doc ID 74131.1 changed developer 6i tnsnames.ora to
> MYORA8I.world =
> (DESCRIPTION_LIST =
> (ADDRESS_LIST =
> (ADDRESS =
> (PROTOCOL = TCP)
> (Host = jerzy-5ltx7an9h)
> (Port = 1521)
> )
> )
> (CONNECT_DATA = (SID=myOra8i)
> )
> )
>
> Rep60_JERZY-5LTX7AN9H,Rep60_JERZY-5LTX7AN9H.world=(ADDRESS=(PROTOCOL=tcp)(HO
> ST=JERZY-5LTX7AN9H)(PORT=1949))
> Can not connect from Developer Report/Forms
> Using proper user/password and service name "myOra8i"
> Getting message REP-0501 Unable to connect to specified database. ORA-12154:
> TNS could not resolve service name.
> Using same string can get to Oracle using SQL+
> What am I doing wrong ?
There is a lot of good information on multiple homes in the published Oracle documentation on the web: Read it.
Likely you just need to make sure that the multiple TNSNAMES.ORA files are identical and make one small change in the registry to point the DEFAULT ORACLE_HOME to the right place.
Daniel Morgan Received on Mon May 27 2002 - 18:23:25 CEST