当前位置: 技术问答>linux和unix
如何配置 linux 下 oracle 的 listener .ora 和
来源: 互联网 发布时间：2014-12-03
本文导语: tnsnames.ora? | # LISTENER.ORA Network Configuration File: E:OracleOra81networkadminlistener.ora # Generated by Oracle configuration tools. 服务端listener.ora LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRES...
tnsnames.ora?
|
# LISTENER.ORA Network Configuration File: E:OracleOra81networkadminlistener.ora
# Generated by Oracle configuration tools.
服务端listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostaddress)(PORT = 1521))
)
)
)
客户端tnsnames.ora
ORASRV_SID =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostaddress)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ora816)
)
)
注意调整相关HOST，PORT，SID参数
# Generated by Oracle configuration tools.
服务端listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostaddress)(PORT = 1521))
)
)
)
客户端tnsnames.ora
ORASRV_SID =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostaddress)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ora816)
)
)
注意调整相关HOST，PORT，SID参数
|
请看实例：
已知ORACLE服务器在192.168.0.4的1521端口监听，SID=ORAC
要在一安装了ORACLE客户端的机器上为它配置一个连接串CONNECT_TO_4。
那么，修改tnsnames.ora，加入以下内容。
CONNECT_TO_4 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.4)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ORAC)
)
)
已知ORACLE服务器在192.168.0.4的1521端口监听，SID=ORAC
要在一安装了ORACLE客户端的机器上为它配置一个连接串CONNECT_TO_4。
那么，修改tnsnames.ora，加入以下内容。
CONNECT_TO_4 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.4)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ORAC)
)
)
您可能感兴趣的文章:
本站(WWW.)旨在分享和传播互联网科技相关的资讯和技术，将尽最大努力为读者提供更好的信息聚合和浏览方式。
本站(WWW.)站内文章除注明原创外，均为转载、整理或搜集自网络。欢迎任何形式的转载，转载请注明出处。
本站(WWW.)站内文章除注明原创外，均为转载、整理或搜集自网络。欢迎任何形式的转载，转载请注明出处。