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

Home -> Community -> Usenet -> c.d.o.tools -> Re: DBDesigner and SQL*Plus: Connection Trouble

Re: DBDesigner and SQL*Plus: Connection Trouble

From: <sybrandb_at_hccnet.nl>
Date: Fri, 27 Apr 2007 21:34:07 +0200
Message-ID: <tvj433pi6pmkkmumc9dig3vsckd9hdg82c@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.

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 - 14:34:07 CDT

Original text of this message

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