Re: Error 12154 - could not resolve the connect indentifier specified
From: ddf <oratune_at_msn.com>
Date: Mon, 26 Jan 2009 09:06:46 -0800 (PST)
Message-ID: <5155fc03-4581-4ffd-a7fb-3a4ba47af442_at_q30g2000prq.googlegroups.com>
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
Date: Mon, 26 Jan 2009 09:06:46 -0800 (PST)
Message-ID: <5155fc03-4581-4ffd-a7fb-3a4ba47af442_at_q30g2000prq.googlegroups.com>
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 Received on Mon Jan 26 2009 - 11:06:46 CST