Re: Installing Ora8i and Developer6i on same machine
Date: Wed, 29 May 2002 11:59:07 +0200
Message-ID: <ad28pk$81j$1_at_news.citykom.de>
[Quoted] "Jerzy Zakrzewski" <objectivesolutions_at_sympatico.ca> schrieb im Newsbeitrag
news:0wsI8.2783$Ed1.596258_at_news20.bellglobal.com...
> 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 ?
[Quoted] I don't know what is wrong, but i had a similar mistake, using the host-name instead of the IP-No. When naming the host in the Win-Network, Win2000 used different names, internal and in the network. So try a shorter host name without an >-< or use the IP-Adress of our host in the tnsnames.ora. Received on Wed May 29 2002 - 11:59:07 CEST