Oracle客户端的安装与远程连接配置方法分享
来源:互联网 发布:java api 中文 编辑:程序博客网 时间:2024/05/30 23:27
一、Oracle客户端与服务器端的通讯机制
二、监听器配置
# listener.ora Network Configuration File: E:\Oracle\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 = E:\Oracle\product\11.2.0\dbhome_1) (PROGRAM = extproc) (ENVS = "EXTPROC_DLLS=ONLY:E:\Oracle\product\11.2.0\dbhome_1\bin\oraclr11.dll") ) (SID_DESC = (GLOBAL_DBNAME = ORCL) (ORACLE_HOME = E:\Oracle\product\11.2.0\dbhome_1) (SID_NAME = ORCL) ) (SID_DESC = (GLOBAL_DBNAME = Oracle8) (SID_NAME = ORCL) ) )LISTENER = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = WIN-FQVGDAF1BRL)(PORT = 1521)) )ADR_BASE_LISTENER = E:\Oracle
三、客户端工具的安装与网络服务的配置
# tnsnames.ora Network Configuration File: D:\oracle\product\11.2.0\client_1\network\admin\tnsnames.ora# Generated by Oracle configuration tools.ORCL.COM = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 183.61.183.152)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = orcl.com) ) )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 = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) )
ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) )
- Oracle客户端的安装与远程连接配置方法分享
- Oracle客户端的安装与远程连接配置
- Oracle客户端的安装与远程连接配置
- Oracle客户端的安装与远程连接配置
- Oracle客户端的安装与远程连接配置
- Oracle客户端的安装与远程连接配置
- Oracle Instant Client(即时客户端)pl/SQL连接远程oracle客户端 安装与配置
- oracle客户端的远程连接配置
- 使用Oracle绿色客户端(InstantClient)连接远程Oracle的配置方法
- 免安装oracle客户端,直接配置plsql连接远程数据库
- asp.net远程连接oracle数据库不用安装oracle客户端的方法
- 绝对正确的不用安装oracle客户端用plsql连接远程oracle方法
- PLSQL Developer连接远程Oracle方法(非安装客户端)
- 记录一下oracle客户端与远程服务器的连接配置过程
- 远程连接ORACLE-免安装oracle客户端
- oracle基础(数据库名,实例名,操作系统环境变量Oracle_Sid,全局数据库名,服务名等概念)以及Oracle客户端的安装与远程连接配置
- oracle客户端与服务器端连接的配置
- oracle客户端的安装和plsql的远程连接教程
- iOS项目开发实战——使用手势识别判断用户操作
- 常用网址
- 0914Android基础网络技术之XUtils
- .NET基础--结构体
- 导出短信
- Oracle客户端的安装与远程连接配置方法分享
- 坏小子军团Stary造了一块电动滑板,想帮你用最低的代价去耍(zhuang)酷(bi)
- LeetCode_jump-game
- 个人链接获取
- 九大内置对象四大作用域
- display:inline-block/text-align:justify下列表的两端对齐布局
- hdu 1850 Being a Good Boy in Spring Festival(Nim博弈)
- 使用xcode编译webkit
- android textview自动换行问题