oracle 数据库 启动指定监听

2019独角兽企业重金招聘Python工程师标准>>>

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。

转载于:https://my.oschina.net/u/1473861/blog/1633814