Re: DBDesigner and SQL*Plus: Connection Trouble

From: <sybrandb_at_hccnet.nl>
Date: Fri, 27 Apr 2007 21:34:07 +0200
Message-ID: <tvj433pi6pmkkmumc9dig3vsckd9hdg82c_at_4ax.com>


On 27 Apr 2007 11:35:46 -0700, HugeBob <rnurse_at_gmail.com> wrote:

>Hi All,
>
>I'd like to use DBDesigner 4 with Oracle 9i. But, I'm having trouble
>connecting. Even though I'm using the connection info created by
>Oracle Net Configuration Assistant (ONCA). I've verified that ONCA
>writes to my TNSNAMES.ORA file. Other applications like Oracle
>Enterprise Manager Console (OEMC) and Oracle Net Manager (ONM) see the
>connections in the names file. But, when I fire up DBDesigner and
>supply it with the service names in the TNSNAMES.ORA file, I get 12154
>errors: i.e., "Could not resolve service name". I get the same error
>when I use SQL*Plus. This leads me to believe that the two
>applications are not reading the proper file or something. Can anyone
>shed light on what's going on?
>
>Thanks.

[Quoted] multiple tnsnames.ora's on the server, TNS_ADMIN not being set. Dealt with in this forum over and over and over again.

-- 
Sybrand Bakker
Senior Oracle DBA
Received on Fri Apr 27 2007 - 21:34:07 CEST

Original text of this message