On 25 nov, 17:06, rom_...@[EMAIL PROTECTED]
wrote:
> OS: Win XP SP2
> Oracle 11g installed.
>
> 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 "ORA 12154: 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 ORA 12154 but 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.
|
