这篇文章主要介绍了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】Oracle11.2.0.4迁移到oracle12.2.0.1-原服务器上新装12c+expdp
荐 Oracle Data Guard(三)Oracle Data Guard补充技术
Windows10安装Oracle19c数据库详细记录(图文详解)
Oracle用decode函数或CASE-WHEN实现自定义排序
Oracle利用errorstack追踪tomcat报错ORA-00903 无效表名的问题
网友评论