Re: listener

From: Mladen Gogala <mgogala_at_yahoo.com>
Date: Wed, 13 May 2015 15:15:38 -0400
Message-ID: <5553A2DA.30001_at_yahoo.com>

On 05/13/2015 01:27 PM, Zelli, Brian wrote:
> Ok, really stupid question. How do I know the exact name of my listener?

The name is "Rumpelstilskin". First, we start it:

    [oracle_at_oradb admin]$ lsnrctl start rumpelstilskin

    LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 13-MAY-2015     15:12:05

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

    Starting /oracle/product/11.2.0.4/home/bin/tnslsnr: please wait...

    TNSLSNR for Linux: Version 11.2.0.4.0 - Production     System parameter file is
    /oracle/product/11.2.0.4/home/network/admin/listener.ora     Log messages written to
    /oracle/diag/tnslsnr/oradb/rumpelstilskin/alert/log.xml     Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))     Listening on:
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oradb)(PORT=1521)))

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))     STATUS of the LISTENER

---

    Alias                     rumpelstilskin
    Version                   TNSLSNR for Linux: Version 11.2.0.4.0 -
    Production
    Start Date                13-MAY-2015 15:12:05
    Uptime                    0 days 0 hr. 0 min. 0 sec
    Trace Level               off
    Security                  ON: Local OS Authentication
    SNMP                      OFF

    Listener Parameter File
    /oracle/product/11.2.0.4/home/network/admin/listener.ora     Listener Log File
    /oracle/diag/tnslsnr/oradb/rumpelstilskin/alert/log.xml     Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))     (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oradb)(PORT=1521)))     Services Summary...
    Service "orcl.home.com" has 1 instance(s).

       Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

Next, we guess the name from the first try:

    oracle_at_oradb admin]$ ps ax|grep tnslsnr       3367 ? Ssl 0:00
    /oracle/product/11.2.0.4/home/bin/tnslsnr rumpelstilskin -inherit       3379 pts/1 S+ 0:00 grep tnslsnr

Our first-born is safe! One needs to remember that Linux "ps" command shows the full command line, when using BSD syntax.

-- 
Mladen Gogala
Oracle DBA
http://mgogala.freehostia.com


--
http://www.freelists.org/webpage/oracle-l

Received on Wed May 13 2015 - 21:15:38 CEST