The trouble with multiple oracle homes is that Net8 uses your current
home to find its tnsnames.ora file. You have two choices:
- Copy a working tnsnames.ora to every network\admin (or net80\admin)
you can find. This might mean merging entries from each. Also make sure
you have valid sqlnet.ora files (in one install I found a sqlnet.ora
that had comment lines with no '#' at the front, which thoroughly
confused Net8).
- Set the TNS_ADMIN environment variable (registry variable in Windows
- HKLM\Software\Oracle).
jennifer muise wrote:
> P.S. I should add that the error returned from the Forms/Reports connection
> attempt is:
> "TNS: could not resolve service name."
>
> "jennifer muise" <jen.muise_at_videotron.ca> wrote in message
> news:lfvj9.17960$32.334987_at_weber.videotron.net...
>
>>Hi,
>>
>>I have installed Oracle9i Enterprise Manager at one Oracle home and
>>Oracle9iDS at another Oracle home on Win XP.
>>I have two little questions:
>>
>>1. Do I still need to use the Oracle Home Selector as you had to with
>>Oracle8i? If so, when?
>>
>>2. I can connect to my local database using SQL-Plus, SQLJ and from within
>>JDeveloper. However, I cannot connect when using Oracle Forms or Report
>>Builder.
>>
>>Please help me out - even if I did sneak in an extra question :-)
>>
>>Thanks!
>>
>>
>>
>>
Received on Mon Sep 23 2002 - 11:34:44 CDT
