viernes, 1 de abril de 2011

Error en Listener "The listener supports no services "

Hace poco estabamos realizando una instalación de Oracle 11g y cambiamos el puerto del listener, configuramos el listener.ora el tnsnames.ora pero aún asi no funcionaba.

Entrada en el tnsnames.ora
TEST11G =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST =TEST)(PORT = 1523)))
    (CONNECT_DATA =
     (SERVICE_NAME = TEST11G)))


Entrada del listener.ora

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = TEST)(PORT = 1523))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1523))
    )
  )
ADR_BASE_LISTENER = /oracle/app/oracle



asi que realizamos el  start del listener
$ lsnrctl start

LSNRCTL for HPUX: Version 11.2.0.1.0 - Production on 01-FEB-2011 13:41:30
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Starting /oracle/app/oracle/product/11.2.0/db11g/bin/tnslsnr: please wait...
TNSLSNR for HPUX: Version 11.2.0.1.0 - Production
System parameter file is /oracle/app/oracle/product/11.2.0/db11g/network/admin/listener.ora
Log messages written to /oracle/app/oracle/diag/tnslsnr/fanbdd24/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test)(PORT=1523)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1523)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test)(PORT=1523)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for HPUX: Version 11.2.0.1.0 - Production
Start Date 01-FEB-2011 13:41:30
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/app/oracle/product/11.2.0/db11g/network/admin/listener.ora
Listener Log File /oracle/app/oracle/diag/tnslsnr/fanbdd24/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=TEST)(PORT=1523)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1523)))
The listener supports no services
The command completed successfully

El tnsping responde adecuadamente, y si intentamos  conectarnos  a la base de datos sin el archivo TNSNAMES.ora tambien responde adecuadamente.

$ sqlplus system/Passwd@test:1523/TEST11G
SQL*Plus: Release 11.2.0.1.0 Production on Feb 1 14:15:13 2011
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
SQL>

pero si lo hacemos a través del tnsnames falla
$ sqlplus system/passwd@TEST11
SQL*Plus: Release 11.2.0.1.0 Production on Feb 1 14:15:19 2011
Copyright (c) 1982, 2009, Oracle. All rights reserved.
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor

¿Por que sucede esto?
Because all of the configuration parameters have default values, it is possible to start and use a listener with no configuration. This default listener has a name of LISTENER, supports no services upon startup, and listens on the following TCP/IP protocol address:

(ADDRESS=(PROTOCOL=tcp)(HOST=host_name)(PORT=1521))

Supported services, that is, the services to which the listener client requests, can be configured in the listener.ora file or this information can be dynamically registered with the listener. This dynamic registration feature is called service registration. The registration is performed by the PMON process—an instance background process—of each database instance that has the necessary configuration in the database initialization parameter file. Dynamic service registration does not require any configuration in the listener.ora file.   Oracle® Database Net Services Administrator's Guide
¿Como podemos cambiar los datos del service registration?
a través del Enterprise manager encontramos el net service administration, una vez configurado allí, el problema desaparecera :)



No hay comentarios:

Publicar un comentario en la entrada