Re: TNS names problem, please help

If you are connecting on the same machine you will need to set TWO_TASKS env to the DB SID and use . oraenv set to Dev6 oratab entry. This should allow the Dev6 oracle_home to take effect and connect tothe DB via a tcp connection.

Em Pradhan wrote:

> Hi
> Make sure your listener service is running or not.
> Also
> Try with out service name (connect string or host string)
> to connect to database.
> HTH
> pradhan
>
> ajeru wrote:
>
> > I have installed Oracle 8i and Oracle Designer 6.0 to different Oracle
> > homes on the same machine. Now I've been trying for 2 days to have
> > designer connect to the 8i database but continue to get the the
> > following error message: "TNS:could not relolve service name". The
> > tnsnames.ora files in both oracle homes contain the same specification
> > for the service name:
> >
> > ORADB =
> > (DESCRIPTION =
> > (ADDRESS_LIST =
> > (ADDRESS = (PROTOCOL = TCP)(HOST = jones)(PORT = 1521))
> > )
> > (CONNECT_DATA =
> > (SERVICE_NAME = oradb)
> > )
> > )
> >
> > I have this definition in every single tnsnames.ora file I found on my
> > machine (and there are many). The SID and global database name of the 8i
> > database are also "oradb".
> >
> > Can anyone help with this please? I really have no idea at all as to
> > what the problem could be.
> >
> > Thank you
> >
> > --
> > Alexander Jerusalem
> > alexander.jerusalem_at_Xchello.at
> > To mail me remove the X before chello
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
Received on Sat Jan 22 2000 - 20:49:13 CST