rom_vl1@[EMAIL PROTECTED]
wrote:
> On Nov 26, 12:32 pm, "frank.van.bor...@[EMAIL PROTECTED]
"
> <frank.van.bor...@[EMAIL PROTECTED]
> wrote:
>> On 25 nov, 17:06, rom_...@[EMAIL PROTECTED]
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 Wa****ngton
damorgan@[EMAIL PROTECTED]
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
|
