oracle 11g listener.ora和tnsname.ora配置模板（IP地址方式）

来源：互联网发布：linux rc0.d 编辑：程序博客网时间：2024/05/20 14:17

本文主要介绍oracle 11g 以IP地址方式（非localhost方式）配置listener.ora和tnsname.ora模板。

listener.ora文件：

---------------------------------------------------------------------------------------------------------------------------------------------------------

# listener.ora Network Configuration File: C:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = orcl)
(ORACLE_HOME = C:\app\Administrator\product\11.2.0\dbhome_1)
(ENVS = "EXTPROC_DLLS=ONLY:C:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.7)(PORT = 1521))
)
)

ADR_BASE_LISTENER = C:\app\Administrator

---------------------------------------------------------------------------------------------------------------------------------------------------------

tnsname 文件:

---------------------------------------------------------------------------------------------------------------------------------------------------------

# listener.ora Network Configuration File: C:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = orcl)
(ORACLE_HOME = C:\app\Administrator\product\11.2.0\dbhome_1)
#(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
#(ADDRESS = (PROTOCOL = IPC)(KEY = orcl))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.7)(PORT = 1521))
)
)

ADR_BASE_LISTENER = C:\app\Administrator

---------------------------------------------------------------------------------------------------------------------------------------------------------

0 0