Thanks for the question, Russ.
Asked: July 12, 2016 - 4:53 pm UTC
Last updated: July 13, 2016 - 1:31 am UTC
Version: 12c
Viewed 1000+ times
You Asked
I am trying to understand how the oracle listener gets its config info. I see this when I run lsnrctl status:
Listener Parameter File /home/oracle/u01/app/oracle/product/12.1.0/dbhome_1/network/admin/listener.ora
Listener Log File /home/oracle/u01/app/oracle/diag/tnslsnr/las03-005-07-5/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=las03-005-07-5.dev.iarc)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=las03-005-07-5.dev.iarc)(PORT=5500))(Security=(my_wallet_directory=/home/oracle/u01/app/oracle/admin/mydb1/xdb_wallet))(Presentation=HTTP)(Session=RAW))
when I cat the listener.ora file I see this:
# listener.ora Network Configuration File: /home/oracle/u01/app/oracle/product/12.1.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = mydb1.dev.iarc)
(ORACLE_HOME = /home/oracle/u01/app/oracle/product/12.1.0/dbhome_1)
(SID_NAME = MYDB1)
)
)
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = las03-005-07-5.dev.iarc)(PORT = 1521))
)
ADR_BASE_LISTENER = /home/oracle/u01/app/oracle
My question is where does the listener pick up the config to listen on the port 5500 endpoint when there is no entry in listener.ora for port 5500? Is there another config file somewhere the listener uses to pick up the endpoint info?
and Connor said...
You probably have configured (because its there by default) EM Express, the monitoring/admin web tool to look after your database. This registers itself with the listener so you can access it via your browser.
More info here on that here:
http://www.oracle.com/technetwork/database/manageability/emx-intro-1965965.html You'll see similar concepts in the "handled services" section of lsnrctl. Services on the database can register with the listener, without the listener having a config entry for them.
Hope this helps.