Database Reference
In-Depth Information
Here is an example of the Oracle 12c listener:
$ps -ef | grep -v grep | grep LISTENER
grid 4799 1 0 Feb19 ? 00:02:00 /u01/app/12.1.0/grid/bin/tnslsnr LISTENER_SCAN3
-no_crs_notify -inherit
grid 8724 1 0 Feb19 ? 00:01:11 /u01/app/12.1.0/grid/bin/tnslsnr LISTENER
-no_crs_notify -inherit
$lsnrctl status
LSNRCTL for Linux: Version 12.1.0.1.0 - Production on 05-MAR-2013 13:39:22
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.1.0.1.0 - Production
Start Date 19-FEB-2013 22:47:56
Uptime 13 days 14 hr. 51 min. 29 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/12.1.0/grid/network/admin/listener.ora
Listener Log File /u01/app/grid/diag/tnslsnr/knewracn1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.16.9.41)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.16.150.37)(PORT=1521)))
Services Summary...
Service "+APX" has 1 instance(s).
Instance "+APX1", status READY, has 1 handler(s) for this service...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status READY, has 2 handler(s) for this service...
Service "-MGMTDBXDB" has 1 instance(s).
Instance "-MGMTDB", status READY, has 1 handler(s) for this service...
Service "_mgmtdb" has 1 instance(s).
Instance "-MGMTDB", status READY, has 2 handler(s) for this service...
Service "
knewdb.kcloud.dblab.com
"
has 1 instance(s).
Instance "knewdb_3", status READY, has 1 handler(s) for this service...
Service "
knewdbXDB.kcloud.dblab.com
"
has 1 instance(s).
Instance "knewdb_3", status READY, has 1 handler(s) for this service...
Service "
knewpdb1.kcloud.dblab.com
"
has 1 instance(s).
Instance "knewdb_3", status READY, has 1 handler(s) for this service...
Service "
knewpdb2.kcloud.dblab.com
"
has 1 instance(s).
Instance "knewdb_3", status READY, has 1 handler(s) for this service...
The command completed successfully
In this example, the listener listens for the ASM instance plus three database instances: APX1, -MGMTDB, and
knewdb_3. The APX1 is the Oracle Enterprise Manager Database Express database instance,-MGMTDB is the Grid
Infrastructure Management repository database instance, and knewdb_3 is the user database instance.
