Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: TNS names problem, please help
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 - 09:18:19 CST