This discussion is archived
2 Replies Latest reply: Sep 13, 2009 11:59 PM by P.Forstmann RSS

listener status unknown

user3266490 Newbie
Currently Being Moderated
Hi,
How to the register listener automatically?

[oraoid@oraapps ~]$ lsnrctl status LISTENER_1

LSNRCTL for Linux: Version 10.1.0.4.2 - Production on 14-SEP-2009 12:11:23

Copyright (c) 1991, 2004, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oraapps.yantro.com)(PORT=1525)))
STATUS of the LISTENER
------------------------
Alias LISTENER_1
Version TNSLSNR for Linux: Version 10.1.0.4.2 - Production
Start Date 14-SEP-2009 11:36:24
Uptime 0 days 0 hr. 34 min. 58 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /devp/p01/app/oracle/10.1.2/network/admin/listener.ora
Listener Log File /devp/p01/app/oracle/10.1.2/network/log/listener_1.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oraapps.yantro.com)(PORT=1525)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Services Summary...
Service "geta" has 1 instance(s).
Instance "geta", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oraoid@oraapps ~]$
  • 1. Re: listener status unknown
    Nicolas.Gasparotto Oracle ACE
    Currently Being Moderated
    Status unknown means a static database registration (db name entry in the listener.ora file) instead of dynamic registration (the db register itself).
    Please, find out nore :
    http://download.oracle.com/docs/cd/B19306_01/network.102/b14212/listenercfg.htm#g511554

    Nicolas.
  • 2. Re: listener status unknown
    P.Forstmann Guru
    Currently Being Moderated
    Since your listener is using a non default TCP port, you have to configure the database instance to register to this non default listener using LOCAL_LISTENER instance parameter: http://download.oracle.com/docs/cd/B19306_01/network.102/b14212/listenercfg.htm#sthref1032

    Edited by: P. Forstmann on Sep 14, 2009 8:59 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points