Re: listener

From: Hans Forbrich <fuzzy.graybeard_at_gmail.com>
Date: Wed, 13 May 2015 12:04:51 -0600
Message-ID: <55539243.2060204_at_gmail.com>



Umm... in any case, running or not, the listener name is either defaulted to LISTENER if there is no LISTENER.ora or it is explicitly listed in LISTENER.ora

[oracle_at_gandalf ~]$ *cat $ORACLE_HOME/network/admin/listener.ora*
# listener.ora Network Configuration File: /u01/app/oracle/product/rdbms/11.2.0/dbhome_1/network/admin/listener.ora # Generated by Oracle configuration tools.

*LISTENER *=
   (DESCRIPTION_LIST =

     (DESCRIPTION =
       (ADDRESS = (PROTOCOL = TCP)(HOST = gandalf.forbrich.de)(PORT = 1521))
       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
     )

   )

ADR_BASE_LISTENER = /u01/app/oracle

*TEST *=
   (DESCRIPTION_LIST =

     (DESCRIPTION =
       (ADDRESS = (PROTOCOL = TCP)(HOST = gandalf.forbrich.de)(PORT = 1522))
       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
     )

   )

A lot of people think that the first "LISTENER = " is some form of directive, but it is actually the description for the listener named "LISTENER". if it is running ...

[oracle_at_gandalf ~]$ *lsnrctl status*

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 13-MAY-2015 11:49:43

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

Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=gandalf.forbrich.de)(PORT=1521))) STATUS of the LISTENER



Alias *LISTENER*

and

[oracle_at_gandalf ~]$*lsnrctl status test*

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 13-MAY-2015 11:57:55

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

Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=gandalf.forbrich.de)(PORT=1522))) STATUS of the LISTENER



Alias *test*

and if it is running,

[oracle_at_gandalf ~]$ ps -ef | grep tns
oracle 1119 1 0 11:51 ? 00:00:00 /u01/app/oracle/product/rdbms/11.2.0/dbhome_1/bin/tnslsnr *LISTENER *-inherit
oracle 1508 1 0 11:55 ? 00:00:00 /u01/app/oracle/product/rdbms/11.2.0/dbhome_1/bin/tnslsnr *test *-inherit oracle 2763 813 0 12:02 pts/0 00:00:00 grep tns


Another common mistake is to confuse "lsnrctl" which is a command shell, with "tnslsnr" which is the actual listener core.

/Hans

On 13/05/2015 11:27 AM, Zelli, Brian wrote:

>
> Ok, really stupid question.  How do I know the exact name of my 
> listener?  In my init.ora?  in my tnsnames.ora?  When I grep for it in 
> unix?
>
> They all seem to be showing me something different……..
>
> Brian
>
>
> This email message may contain legally privileged and/or confidential 
> information. If you are not the intended recipient(s), or the employee 
> or agent responsible for the delivery of this message to the intended 
> recipient(s), you are hereby notified that any disclosure, copying, 
> distribution, or use of this email message is prohibited. If you have 
> received this message in error, please notify the sender immediately 
> by e-mail and delete this email message from your computer. Thank you. 


--
http://www.freelists.org/webpage/oracle-l
Received on Wed May 13 2015 - 20:04:51 CEST

Original text of this message