Re: listener
- From: "Mladen Gogala" <dmarc-noreply@xxxxxxxxxxxxx> (Redacted sender "mgogala@xxxxxxxxx" for DMARC)
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 13 May 2015 15:15:38 -0400
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@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@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
Other related posts: