欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

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

程序员文章站 2022-06-24 23:01:00
这篇文章主要介绍了win oracle 监听文件配置参考代码实例,文中通过示例代码介绍的非常详细,对大家的学习或者工作具有一定的参考学习价值,需要的朋友可以参考下 win liste...

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

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