Re: Error 12154 - could not resolve the connect indentifier specified

From: jodleren <sonnich_at_hot.ee>
Date: Mon, 26 Jan 2009 09:42:55 -0800 (PST)
Message-ID: <7552f4da-e249-433d-a61e-fff33bbd16de_at_r15g2000prd.googlegroups.com>



On Jan 26, 7:06 pm, ddf <orat..._at_msn.com> wrote:
> On Jan 26, 9:43 am, jodleren <sonn..._at_hot.ee> wrote:
>
>
>
> > Hi all
>
> > I have to make to connect to two databases in other departsments. I am
> > using 3 computers, my own, test intra server and intra server.
> > I have updated the tnsnames.ora file on the test server, but it is the
> > only one, which cannot connect to anything except our own server.
>
> > The error:  ORA-12154: TNS: could not resolve the connect indentifier
> > specified
> > I get this error when trying to connect from the ODBC settings window.
> > Passw is correct, as it works from my conmputer etc, and I am myself
> > in both cases.
>
> > Could anyone give me a hint of what I am missing?
>
> > The test server has (AFAIK) never been configured to work outside, and
> > now we need it. Also, it is not updated as much as our real stuff, so
> > some settings might lack.
>
> > Any ideas?
>
> > WBR
> >Sonnich
>
> Your tnsnames.ora file is, apparently, incorrectly configured or
> missing on this test machine or in a different location from the
> directory where Oracle expects to find it.  A tnsping of the
> 'offending' service should produce an informative message indicating
> where this file should be located:
>
> TNS Ping Utility for 32-bit Windows: Version 11.1.0.6.0 - Production
> on 26-JAN-2009 11:02:58
>
> Copyright (c) 1997, 2007, Oracle.  All rights reserved.
>
> Used parameter files:
> c:\oracle\orahome11g\network\admin\sqlnet.ora
>
> ...
>
> When you have this information you can relocate the tnsnames.ora you
> have configured to its proper location.
>
> David Fitzjarrell

It works now, thanks.
I also check the TNS_ADMIN in the registry; what tool should I otherwise use for that?

WBR
Sonnich

PS: good to be back with oracle Received on Mon Jan 26 2009 - 11:42:55 CST

Original text of this message