Here is an example that you have to put in
$ORACLE_HOME/network/admin/tnsnames.ora (UNIX or NT) :
EXAMPLE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = LOCALHOST)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = EXAMPLE)
)
)
"Graeme Barnett" <graeme.barnett_at_unn.ac.uk> wrote in message
news:9t2jsq$7n9$1_at_dax.unn.ac.uk...
> 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
>
>
Received on Fri Nov 16 2001 - 04:16:37 CST
