12c New and Useful LSNRCTL Outputs

The 12c Lsnrctl utility includes a couple of additional SHOW features that were not available in earlier releases.

LSNRCTL>show pid   <==Show the pid of the tnslsnr or listener process:

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hostname.us.oracle.com)(PORT=1521)))

PID=(3568)    <==This is the pid for the listener that the LSNRCTL utility is communicating with in this session.

The command completed successfully

LSNRCTL>show ORACLE_HOME <==Show the ORACLE_HOME where this listener process is running:

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hostname.us.oracle.com)(PORT=1521)))

ORACLE_HOME="/u01/app/grid_home/product/12.1.0.2/dbhome_1"

The command completed successfully