ORACLE 11gR2静态监听

 ORACLE 11g监听增加了scan，直接配置静态监听（SID_LIST_LISTENER）是无法生效的。

 可以采用特殊方法避过scan，使用ORACLE 11g的静态监听。

gird中的listener.ora

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = orcl)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
      (SID_NAME = orcl1)
    )
  )

oracle中的tnsnames.ora

ORCL1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.21.201)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
      (INSTANCE_NAME = orcl1)
    )
  )