Re: 11g - ORA 12154 error after installation of ODAC1110610beta

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 Received on Mon Nov 26 2007 - 17:10:33 CET