Re: Listener not listening ?

Well, the TNS_ADMIN key you created in HKLM\Software\Oracle is only relevant for software installed into the default Oracle Home. Since your other software was (correctly) not installed into the default Oracle Home, you need to set the TNS_ADMIN variable in the HKLM\Software\Oracle\HOMEx keys as well. For example, on my machine, the TNS_ADMIN is set in HKLM\Software\Oracle\HOME0, HKLM\Software\Oracle\HOME1, HKLM\Software\Oracle\HOME2, and HKLM\Software\Oracle\HOME3.

The designer install should have prompted you for setting the TNS_ADMIN key during the final phases of the install (I have never seen it not prompt for this) and created the correct key for you. In any case, if you set the TNS_ADMIN in *each* of your HKLM\Software\Oracle\HOMEx registry keys, you should see a difference.

From the Oracle8i Administrator's Guide for Windows NT:

TNS_ADMIN
Oracle software looks for TNS_ADMIN in one location in the registry (depending upon the type of Oracle home installed). If you installed software into the default Oracle home, then any software running from that Oracle home will look in HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE. If you installed a new-style (8.0.4 or later) multiple Oracle home, then the Oracle software looks in HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOMEID. The ALL_HOMES key is used by the installer and plays no role when translating variables.

HTH,

• LM

"Dooban" <doobas_at_terra.com> wrote in message news:b12e10b3.0111011218.467003dd_at_posting.google.com...
> I have installed Oracle EE 8i 1.7 and Designer 6i rel 3, in that
> order.
>
> I have created a TNS_ADMIN key in HKLM-Software-Oracle pointing to
> C:\ORACLE\ORA81\NETWORK\ADMIN.
>
> I have deleted the TNSNAMES.ORA, AND SQLNET.ORA so that there would be
> no conflicts from C:\ORACLE\DEV6i\NET80\ADMIN.
>
> After that I am able to connect with SQLPLUSW with scott/tiger_at_ORCL.
> Just in case it didn´t work I have connected from the SQLPLUSW.exe
> located in:
> C:\ORACLE\ORA81\BIN
> C:\ORACLE\DEV6i\BIN
> C:\ORACLE\des_817\BIN
> In every case I was able to succesfully connect using
> scott/tiger_at_ORCL.
>
> I have also installed Developer 6i rel3 and been able to log using the
> ORCL instance.
>
> The problem arises when trying to launch DESIGNER. When I log using
> the same connection string the following error appears:
>
> ORA-12203: TNS:unable to connect to destination
> RME-00220: Failed to connect to Repository
> I have not yet created the repository, so the second error is ok but
> not the first one.
>
> When issuing a TNSPING ORCL I get a TNS-12541:no listener error. The
> listener IS started !
>
> This is the output of the LSNRCTL status:
>
> C:\>lsnrctl status
>
> LSNRCTL for 32-bit Windows: Version 8.1.7.0.0 - Production on
> 01-NOV-2001 21:16:44
>
> (c) Copyright 1998 Oracle Corporation. All rights reserved.
>
> Conectßndose a

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))
> ESTADO del LISTENER
> ------------------------
> Alias LISTENER
> Versi¾n TNSLSNR for 32-bit Windows: Version
> 8.1.7.0.0 - Production
> Fecha de Inicio 01-NOV-2001 20:56:45
> Tiempo de actividad 0 dÝas 0 hr. 20 min. 1 seg.
> Nivel de Rastreo off
> Seguridad OFF
> SNMP OFF
> Fichero de Parßmetros del Listener
> C:\oracle\ora81\network\admin\listener.ora
> Fichero Log del Listener C:\oracle\ora81\network\log\listener.log
> Resumen de servicios...
> orcl tiene 1 gestor(es) de servicio
> El comando se ha ejecutado correctamente
>
> Sorry for the language.
>
> Pleeease help.
>
> Thanks.
Received on Fri Nov 02 2001 - 20:29:40 CST