Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL*Plus and DBDesigner Connection Trouble

HugeBobApr 27 2007 — edited Jan 9 2010

Good Morning 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.

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 6 2010

Added on Apr 27 2007

#heterogeneous-connectivity

3 comments

9,437 views