oracle监听host配置,监听器listener.ora中HOST参数配置

4、Host使用IP地址

下面使用IP地址配置Host的情况，修改listener.ora文件。

[Oracle@SimpleLinux admin]$ cat listener.ora

# listener.ora Network Configuration File: /u01/app/oracle/network/admin/listener.ora

# Generated by Oracle configuration tools.

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.100)(PORT = 1521))

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

)

)

ADR_BASE_LISTENER = /u01/app

启动监听器。

[oracle@SimpleLinux admin]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 02-JAN-2014 15:06:15

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.100)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

The listener supports no services