Re: TNS names problem, please help

From: Claudio Tassi <claudio_at_janet.NOSPAM.it>
Date: Sat, 22 Jan 2000 18:14:28 +0100
Message-ID: <86cnoc$hic$1@pinco.nettuno.it>

ajeru <ajeru_at_my-deja.com> wrote in message news:86avi3$ub7$1_at_nnrp1.deja.com...
> 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)
> )
> )

You can try replacing SERVICE_NAME with SID_NAME = SID_OF_YOUR_DATABASE

Claudio Received on Sat Jan 22 2000 - 11:14:28 CST