Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: TNS names problem, please help

Re: TNS names problem, please help

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: Mon, 24 Jan 2000 14:50:10 GMT
Message-ID: <388C66A2.E16D624E@edcmail.cr.usgs.gov>


You might try setting your TNS_ADMIN environment variable to point to the location of your TNSNAMES.ORA file.

HTH,
Brian

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 Mon Jan 24 2000 - 08:50:10 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US