oracle监听配置listener.ora文件如下
# listener.ora Network Configuration File: /opt/oracle/product/11.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
ADR_BASE_NEPTUNELISTENER = /opt/oracle
NEPTUNELISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.137.58.248)(PORT = 21521))
(ADDRESS = (PROTOCOL = IPC)(KEY = REGISTER))
)
)
SECURE_CONTROL_NEPTUNELISTENER=(TCPS,IPC)
SECURE_PROTOCOL_NEPTUNELISTENER=(TCPS,IPC)
SECURE_REGISTER_NEPTUNELISTENER=(TCPS,IPC)
DYNAMIC_REGISTRATION_NEPTUNELISTENER=OFF
ADMIN_RESTRICTIONS_NEPTUNELISTENER=ON
LOGGING_NEPTUNELISTENER=ON
LOGGING_LISTENER=ON
SECURE_REGISTER_NEPTUNELISTENER_PROD = (IPC)
SID_LIST_NEPTUNELISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = Neptunia)
(SID_NAME = Neptunia)
)
)
INBOUND_CONNECT_TIMEOUT_NEPTUNELISTENER = 1800
ADR_BASE_ESIGHTLISTENER = /opt/oracle
其中NEPTUNELISTENER为监听实例的名字,启动可以用如下命令:
lsnrctl start NEPTUNELISTENER
同理,停止将上述命令中的start换成stop,查询状态的就将start换成status。