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: Connection problem: ORA-12203 and ORA-12154

Re: Connection problem: ORA-12203 and ORA-12154

From: FlyingVee <b-horton_at_worldnet.att.net>
Date: 1998/03/22
Message-ID: <6f38r9$dh7@bgtnsc03.worldnet.att.net>#1/1

Steven Cools wrote:
>
> Hi,
>
> a little explanation about my current situation:
>
> Oracle 7.3 is installed on a central server (Netware 4.11 - Windows).
> Several client machine (Windows 95) can succesfully connect to this server
> (for example by using SQL*Plus) but there are problems with 1 client
> machine.
> I get following error message when I try to connect with SQL*Plus (with the
> same parameters as used on the other client machines):
>
> ORA-12203: TNS: Unable to connect to destination
>
> or sometimes:
>
> ORA-12154: TNS: Could not resolve service name
>
> I checked both errors and their (possible) solution and the manual says
> that I
> should check TNSNAMES.ORA but..the other client machines use the same
> TNSNAMES.ORA so that can't be the problem...
>
> Any other suggestions ? If you can please forward them to Steven_at_digimap.be
>
> greetings,
>
> Steven Cools
>
>

Don't know what you mean that they all use the same TSNAMES. Each machine has its own TSNAMES.ora under ORAWIN. Check on the PC in question that it truely has the server it's looking for. Received on Sun Mar 22 1998 - 00:00:00 CST

Original text of this message

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