Re: Installing Ora8i and Developer6i on same machine
Date: Wed, 29 May 2002 22:51:54 -0700
Message-ID: <3CF5BDFA.604046B3_at_exesolutions.com>
"Loddar M." wrote:
> "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 ?
>
> 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.
If you have 8i, which it appears, why are you using CONNECT_DATA = (SID .... rather than CONNECT_DATA = (SERVICE_NAME .... ?
Daniel Morgan Received on Thu May 30 2002 - 07:51:54 CEST