Win Oracle 监听文件配置参考代码实例

2020-07-26 13:26:38

字体：大中小

来源：转载

供稿：网友

这篇文章主要介绍了Win Oracle 监听文件配置参考代码实例,文中通过示例代码介绍的非常详细，对大家的学习或者工作具有一定的参考学习价值,需要的朋友可以参考下

Win lister.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 = CLRExtProc)   (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 = TCP)(HOST = 192.168.125.134)(PORT = 1521))  )  (DESCRIPTION =   (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))  ) )ADR_BASE_LISTENER = C:/app/Administrator

Win tsnames.ora配置参考

# tnsnames.ora Network Configuration File: C:/app/Administrator/product/11.2.0/dbhome_1/NETWORK/ADMIN/tnsnames.ora# Generated by Oracle configuration tools.LISTENER_ORCL = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))ORACLR_CONNECTION_DATA = (DESCRIPTION =  (ADDRESS_LIST =   (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))  )  (CONNECT_DATA =   (SID = CLRExtProc)   (PRESENTATION = RO)  ) )ORCL = (DESCRIPTION =  (ADDRESS_LIST =   (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))   (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.125.134)(PORT = 1521))   (ADDRESS = (PROTOCOL = TCP)(HOST = WIN-LOPIL4J1KK4)(PORT = 1521))   (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))  )  (CONNECT_DATA =   (SERVER = DEDICATED)   (SERVICE_NAME = orcl)  ) )

以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持武林网。

上一篇：Oracle 两个逗号分割的字符串,获取交集、差集(sql实现过程解析)

下一篇：oracle实现按天，周，月，季度，年查询排序方法