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

Windows  /  管理员 发布于 4年前   303

这篇文章主要介绍了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)  ) )

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