oracle10.2.0.4 動態註冊監聽配置_摘自小荷

  配置動|靜態註冊監聽

 

 

要點:

  1,對於動態註冊

       a,不用配置listener.ora

       b,lsnrctl services

-bash-3.2$ lsnrctl services

LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 17-JUN-2010 14:08:02

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
Services Summary...
Service "orcl" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:1 refused:0 state:ready
         LOCAL SERVER
Service "orclXDB" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
    Handler(s):
      "D000" established:0 refused:0 current:0 max:1022 state:ready
         DISPATCHER
         (ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=35356))
Service "orcl_XPT" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:1 refused:0 state:ready
         LOCAL SERVER
The command completed successfully

 

         c,lsnrctl status其status資訊為ready,而非unknown(靜態註冊)

         d,一定要配置service_names及instance_name

 

 

2,靜態註冊與上面相反