Re: 11g - ORA 12154 error after installation of ODAC1110610beta
From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 26 Nov 2007 08:23:01 -0800
Message-ID: <1196094174.656358_at_bubbleator.drizzle.com>
>> On 25 nov, 17:06, rom_..._at_mail.ru wrote:
>>
>>
>>
>>
>>
>>> OS: Win XP SP2
>>> Oracle11ginstalled.
>>> 1. Database was successfully created and was accessible from SQLPlus,
>>> Database Control (Web interface) and TOAD 9.5
>>> 2. Installed ODAC 11.1.0.6.1.0 beta and..
>>> 3. Receive "ORA12154: TNS could not resolve the connect identifier
>>> specified" error always trying to connect trough TOAD or from my
>>> own .NET applications, but...
>>> 4. Full functional access still works from SQLPlus and from Database
>>> Control Web interface.
>>> I have read all posts related with ORA12154but most of them are very
>>> old and do not help. tnsnames and listener settings are ok -
>>> everything worked fine until the last ODAC was installed.
>>> Any ideas of how to resolve the problem are very appreciated.
>>> -Roman
>> Your path setting probably list the ODAC installation directory
>> first now - and in that directory, the correct tnsnames.ora
>> cannot be found.
>> Either copy your *.ora files from your database_home\network\admin
>> directory to the ODAC\network\admin directory, or introduce
>> the tns_admin environment variable (via a "SET" command, or via
>> the registry), and make it point to the correct (database home!)
>> network\admin directory.
>>
>> That should do the trick.- Hide quoted text -
>>
>> - Show quoted text -
Date: Mon, 26 Nov 2007 08:23:01 -0800
Message-ID: <1196094174.656358_at_bubbleator.drizzle.com>
rom_vl1_at_mail.ru wrote:
> On Nov 26, 12:32 pm, "frank.van.bor..._at_gmail.com" > <frank.van.bor..._at_gmail.com> wrote:
>> On 25 nov, 17:06, rom_..._at_mail.ru wrote:
>>
>>
>>
>>
>>
>>> OS: Win XP SP2
>>> Oracle11ginstalled.
>>> 1. Database was successfully created and was accessible from SQLPlus,
>>> Database Control (Web interface) and TOAD 9.5
>>> 2. Installed ODAC 11.1.0.6.1.0 beta and..
>>> 3. Receive "ORA12154: TNS could not resolve the connect identifier
>>> specified" error always trying to connect trough TOAD or from my
>>> own .NET applications, but...
>>> 4. Full functional access still works from SQLPlus and from Database
>>> Control Web interface.
>>> I have read all posts related with ORA12154but most of them are very
>>> old and do not help. tnsnames and listener settings are ok -
>>> everything worked fine until the last ODAC was installed.
>>> Any ideas of how to resolve the problem are very appreciated.
>>> -Roman
>> Your path setting probably list the ODAC installation directory
>> first now - and in that directory, the correct tnsnames.ora
>> cannot be found.
>> Either copy your *.ora files from your database_home\network\admin
>> directory to the ODAC\network\admin directory, or introduce
>> the tns_admin environment variable (via a "SET" command, or via
>> the registry), and make it point to the correct (database home!)
>> network\admin directory.
>>
>> That should do the trick.- Hide quoted text -
>>
>> - Show quoted text -
> > Thank you very much. > You are right. > I thought about it, but I could not check what version of tsnnames.ora > uses ODAC
Put the same, working, TNSNAMES.ORA into every /network/admin directory.
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Mon Nov 26 2007 - 17:23:01 CET