oracle监听文件listener.ora for 10g/11g

----------------------oracle 11g---------------------- SID_LIST_LISTENER =   (SID_LIST =     (SID_DESC =       (SID_NAME = nms)       (ORACLE_HOME = /u01/oracle/product/10.2.0/db_1/)       (PROGRAM = extproc)     ) ) LISTENER =   (DESCRIPTION_LIST =     (DESCRIPTION =       (ADDRESS = (PROTOCOL = TCP)(HOST = TJ-NMS-DB)(PORT = 1523))       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1523))     )   ) ADR_BASE_LISTENER = /u01/oracle 用非默认端口时需要改local_listener参数 SQL> alter system set local_listener="(address=(protocol=tcp)(host=192.168.0.100)(port=1523))"; ----------------------oracle 10g---------------------- SID_LIST_LISTENER =   (SID_LIST =     (SID_DESC =       (GLOBAL_DBNAME = ydwg)       (ORACLE_HOME = /oracle/oracle10/product/10.2.0/db_1)       (SID_NAME = ydwg)     )  ) LISTENER =   (DESCRIPTION_LIST =     (DESCRIPTION =       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.151)(PORT = 1521))     )   )