Re: Oracle Server and Oracle tools integration problem

On Fri, 16 Nov 2001 08:46:25 -0000, "Graeme Barnett" <graeme.barnett_at_unn.ac.uk> wrote:

>Please can someone advise me on what to do?
>I have installed Designer, Forms/Reports/JDeveloper etc first (as advised by
>a DBA friend) then I've installed Oracle 9i server and client on my NT
>machine.
>
>SQL*Plus can access the database and OEM can access the database, but
>designer etc say that the server is not listed in the tnsnames.ora file.
>I'm presuming it's looking for the one in the ..\network\ADMIN directory,
>where of course the entry does exist for the server.
>
>Cheers,
>
>Graeme
>

Check out whether you have multiple network\admin directories and/or net80\admin directories. (If you have installed the software in multiple Oracle_homes [which you should have]) this would be the case. Then either
a) setup a variable called TNS_ADMIN in HKLM\software\oracle to the correct directory
b) synchronize the directories

8.0 based products (which Designer etc still are) won't understand the service_name = syntax in tnsnames.ora

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Nov 16 2001 - 04:29:58 CST