一、如果使用默认的1521端口&＃xff0c;让实例自动注册到该监听上&＃xff0c;那么local_listener无需设置&＃xff0c;listener.ora文件按照正常方式配置即可。

二、如果使用非默认1521端口&＃xff0c;让实例自动注册到该监听上&＃xff0c;那么需要设置local_listerner参数&＃xff0c;local_listener &＃xff1d; &＃39;lsnr2&＃39; &＃xff08;可以动态修改&＃xff09;
 
三、编辑listener.ora文件&＃xff0c;该监听为两个&＃xff0c;一个为动态注册使用默认端口&＃xff0c;一个为静态注册使用了非默认端口&＃xff1a;
LISTENER1 &＃61;
  (DESCRIPTION &＃61;
    (ADDRESS &＃61; (PROTOCOL &＃61; TCP)(HOST &＃61; oms)(PORT &＃61; 1526))
  )

SID_LIST_LISTENER1 &＃61;
  (SID_LIST &＃61;
    (SID_DESC &＃61;
      (GLOBAL_DBNAME &＃61; guuc)
      (ORACLE_HOME &＃61; /oracle/product/10201)
      (SID_NAME &＃61; cuug)
    )
  )


SID_LIST_LISTENER &＃61;
  (SID_LIST &＃61;
    (SID_DESC &＃61;
      (SID_NAME &＃61; PLSExtProc)
      (ORACLE_HOME &＃61; /oracle/product/10201)
      (PROGRAM &＃61; extproc)
    )
  )

LISTENER &＃61;
  (DESCRIPTION_LIST &＃61;
    (DESCRIPTION &＃61;
      (ADDRESS &＃61; (PROTOCOL &＃61; TCP)(HOST &＃61; oms)(PORT &＃61; 1521))
    )
    (DESCRIPTION &＃61;
      (ADDRESS &＃61; (PROTOCOL &＃61; IPC)(KEY &＃61; EXTPROC0))
    )

三、数据库监听两个启动后的情况&＃xff0c;此时数据库未启动&＃xff0c;默认的的现在还没有&＃xff0c;非默认的现在有了一个静态的&＃xff1a;
[oracle&＃64;oms admin]$ lsnrctl status

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 14-APR-2010 00:12:37

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (DESCRIPTION&＃61;(ADDRESS&＃61;(PROTOCOL&＃61;TCP)(HOST&＃61;oms)(PORT&＃61;1521)))
STATUS of the LISTENER
------------------------
Alias                     listener
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                14-APR-2010 00:07:35
Uptime                    0 days 0 hr. 5 min. 1 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /oracle/product/10201/network/admin/listener.ora
Listener Log File         /oracle/product/10201/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION&＃61;(ADDRESS&＃61;(PROTOCOL&＃61;tcp)(HOST&＃61;oms)(PORT&＃61;1521)))
  (DESCRIPTION&＃61;(ADDRESS&＃61;(PROTOCOL&＃61;ipc)(KEY&＃61;EXTPROC0)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;
[oracle&＃64;oms admin]$ lsnrctl status listener1

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 14-APR-2010 00:12:40

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (DESCRIPTION&＃61;(ADDRESS&＃61;(PROTOCOL&＃61;TCP)(HOST&＃61;oms)(PORT&＃61;1526)))
STATUS of the LISTENER
------------------------
Alias                     listener1
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                14-APR-2010 00:06:56
Uptime                    0 days 0 hr. 5 min. 43 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /oracle/product/10201/network/admin/listener.ora
Listener Log File         /oracle/product/10201/network/log/listener1.log
Listening Endpoints Summary...
  (DESCRIPTION&＃61;(ADDRESS&＃61;(PROTOCOL&＃61;tcp)(HOST&＃61;oms)(PORT&＃61;1526)))
Services Summary...
Service "guuc" has 1 instance(s).
  Instance "cuug", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

四、启动数据库&＃xff0c;观察监听的变化&＃xff0c;默认的注册了一个实例&＃xff0c;非默认的不变&＃xff1a;
[oracle&＃64;oms admin]$ lsnrctl status

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 14-APR-2010 00:18:40

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (DESCRIPTION&＃61;(ADDRESS&＃61;(PROTOCOL&＃61;TCP)(HOST&＃61;oms)(PORT&＃61;1521)))
STATUS of the LISTENER
------------------------
Alias                     listener
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                14-APR-2010 00:07:35
Uptime                    0 days 0 hr. 11 min. 4 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /oracle/product/10201/network/admin/listener.ora
Listener Log File         /oracle/product/10201/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION&＃61;(ADDRESS&＃61;(PROTOCOL&＃61;tcp)(HOST&＃61;oms)(PORT&＃61;1521)))
  (DESCRIPTION&＃61;(ADDRESS&＃61;(PROTOCOL&＃61;ipc)(KEY&＃61;EXTPROC0)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "cuug" has 1 instance(s).
  Instance "cuug", status READY, has 1 handler(s) for this service...
Service "cuug_XPT" has 1 instance(s).
  Instance "cuug", status READY, has 1 handler(s) for this service...
The command completed successfully
&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;
[oracle&＃64;oms admin]$ lsnrctl status listener1

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 14-APR-2010 00:18:42

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (DESCRIPTION&＃61;(ADDRESS&＃61;(PROTOCOL&＃61;TCP)(HOST&＃61;oms)(PORT&＃61;1526)))
STATUS of the LISTENER
------------------------
Alias                     listener1
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                14-APR-2010 00:06:56
Uptime                    0 days 0 hr. 11 min. 45 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /oracle/product/10201/network/admin/listener.ora
Listener Log File         /oracle/product/10201/network/log/listener1.log
Listening Endpoints Summary...
  (DESCRIPTION&＃61;(ADDRESS&＃61;(PROTOCOL&＃61;tcp)(HOST&＃61;oms)(PORT&＃61;1526)))
Services Summary...
Service "guuc" has 1 instance(s).
  Instance "cuug", status UNKNOWN, has 1 handler(s) for this servi


五、配置本地的tnsnames.ora文件
LSNR2 &＃61;
  (DESCRIPTION &＃61;
    (ADDRESS_LIST &＃61;
      (ADDRESS &＃61; (PROTOCOL &＃61; TCP)(HOST &＃61; oms)(PORT &＃61; 1526))
    )
    (CONNECT_DATA &＃61;
      (SERVER &＃61; DEDICATED)
      (SERVICE_NAME &＃61; cuug)    #此名字可以自定义&＃xff0c;一般定义为实例的名字
    )
  )

六、动态更改local_listener的值&＃xff1a;
SQL> alter system set local_listener &＃61; lsnr2;

七、注意两个监听的变化&＃xff0c;默认的监听没有实例注册&＃xff0c;非默认的注册了一个实例&＃xff1a;
[oracle&＃64;oms admin]$ lsnrctl status listener

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 14-APR-2010 00:25:50

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (DESCRIPTION&＃61;(ADDRESS&＃61;(PROTOCOL&＃61;TCP)(HOST&＃61;oms)(PORT&＃61;1521)))
STATUS of the LISTENER
------------------------
Alias                     listener
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                14-APR-2010 00:07:35
Uptime                    0 days 0 hr. 18 min. 14 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /oracle/product/10201/network/admin/listener.ora
Listener Log File         /oracle/product/10201/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION&＃61;(ADDRESS&＃61;(PROTOCOL&＃61;tcp)(HOST&＃61;oms)(PORT&＃61;1521)))
  (DESCRIPTION&＃61;(ADDRESS&＃61;(PROTOCOL&＃61;ipc)(KEY&＃61;EXTPROC0)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;&＃xff1d;
[oracle&＃64;oms admin]$ lsnrctl status listener1

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 14-APR-2010 00:26:03

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (DESCRIPTION&＃61;(ADDRESS&＃61;(PROTOCOL&＃61;TCP)(HOST&＃61;oms)(PORT&＃61;1526)))
STATUS of the LISTENER
------------------------
Alias                     listener1
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                14-APR-2010 00:24:35
Uptime                    0 days 0 hr. 1 min. 28 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /oracle/product/10201/network/admin/listener.ora
Listener Log File         /oracle/product/10201/network/log/listener1.log
Listening Endpoints Summary...
  (DESCRIPTION&＃61;(ADDRESS&＃61;(PROTOCOL&＃61;tcp)(HOST&＃61;oms)(PORT&＃61;1526)))
Services Summary...
Service "cuug" has 1 instance(s).
  Instance "cuug", status READY, has 1 handler(s) for this service...
Service "cuug_XPT" has 1 instance(s).
  Instance "cuug", status READY, has 1 handler(s) for this service...
Service "guuc" has 1 instance(s).
  Instance "cuug", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

 

  注意&＃xff1a;发现实例注册到这个端口的监听上了&＃xff0c;至此&＃xff0c;终于明白local_listener参数的作用&＃xff0c;默认的值是数据库的global_name&＃xff0c;则注册到默认监听&＃xff1b;如果设置了新值&＃xff0c;比如lsnr2&＃xff0c;则根据tnsnames.ora的设置&＃xff0c;注册到指定的端口的监听&＃xff0c;该端口与某个监听指定的端口一致。

转载【ocp培训】