配置toad远程连接oracle
在oracle服务器上:
C:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN目录
文件:listener.ora(10.144.118.12是oracle服务器地址)
# 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")
)(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = C:\app\Administrator\product\11.2.0\dbhome_1)
(SID_NAME = ORCL)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.144.118.12)(PORT = 1521))
)
)
ADR_BASE_LISTENER = C:\app\Administrator
文件:tnsnames.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 = (PROTOCOL = TCP)(HOST = 10.144.118.12)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
配好后重启服务:
客户端需要安装oracle client 和 toad软件,登录界面
最新文章
- Nginx与tomcat组合的简单使用
- 复星昆仲杨光:VR行业四大痛点
- apache 访问出现403 Forbidden
- 使用JDBC进行批处理
- XSS高级实战教程
- careercup-数组和字符串1.8
- Beta 第五天
- 第5章 令牌自省端点(Token Introspection Endpoint) - IdentityModel 中文文档(v1.0.0)
- 中文命名之Hibernate+MySQL演示
- Java基础9:解读Java回调机制
- Python面向对象基础知识
- ceph mimc版本ceph-deploy安装与配置
- foreach 引发的值类型与引用类型思考
- maven的profile详解
- 使用css实现移动端导航条滚动
- 关于Maven项目build时出现No compiler is provided in this environment的处理(转)
- C#基础复习(2) 之 装箱拆箱
- Windows系统虚拟内存文件和休眠缓存大小优化
- windows安装sqlite
- Iconfont在移动端遇到问题的探讨
热门文章
- C++中的空类,编译器默认可以产生哪些成员函数
- 【Asp.net入门3-02】使用jQuery-jQuery 入门
- Service Fabric —— Stateful Service 概念
- navicat链接mysql
- python常用模块(3)
- bzoj千题计划163:bzoj1060: [ZJOI2007]时态同步
- CSS3实战之resize
- ASP.NET项目与IE10、IE11不兼容的解决办法
- jetty 热部署
- 【CC2530强化实训03】定时器间隔定时实现按键长按与短按