Oracle实例注册监听到listener

在listener.ora增加SID_LIST_LISTENER 节点配置

# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.


SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = orcl) (SID_NAME = orcl) ))


LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
  )



ADR_BASE_LISTENER = /u01/app/oracle

global_dbname和sid_name配置从如下sql中获得。

SQL> show parameter service_names

NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
service_names			     string	 orcl
SQL> alter system register;

System altered.

SQL> 

当使用lsnrctl status看到如下，说明已经注册到了listener。