配置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软件,登录界面
相关推荐
Toad for Oracle 中文使用指南(权威版),清晰版 ,涵软件安装
SN of Toad 9.5 for ORACLE SN of Toad 9.5 for ORACLE SN of Toad 9.5 for ORACLE TOAD9.5注册码 可以用的
Toad For Oracle使用教程详细讲解了如何使用Toad For Oracle工具操作数据库。
Toad for Oracle key Toad for Oracle 12.msi 应用的Key
toad for oracle 11.6 64bit 注册码 for oracle license key
简体中文语言包,适用于Toad for Oracle 12.8(32位/64位版),覆盖同名文件之后即是简体中文版,适合喜欢中文环境的同学,可用来汉化我发布的Toad for oracle 12.8.0.49 Development Suite X86/X64(32位/64位)安装...
Toad for Oracle 12.8简体中文语言包,挺好的,有需要的小伙伴可以下载使用
toad for oracle11 注册码
http://us-downloads.quest.com/Repository/support.quest.com/Toad for Oracle/12.1/Software/Toad for Oracle 12.1.msi http://us-downloads.quest.com/Repository/support.quest.com/Toad for Oracle/12.1/...
oracle toad汉化包
如果本地没有安装32位oracle,是无法使用toad的(无论连接32位还是64位oracle),即使安装了64位oracle也不识别64位oracle客户端,办法是下载32位客户端。下载完,解压到d盘根目录,执行里面的注册表文件,如果要改...
TOAD注册码 for oracle 全。
免安装不需要注册码直接使用,对于经常操作oracle数据库直观好用bug少
toad for oracle 12 注册码
toad oracle管理软件破解
toad for oracle 13.0最新版,
Toad for Oracle 12 各 个 版 本 注 册 码,非常好用。
Toad for Oracle 9.7.2 Toad for Oracle 9.7.2 Toad for Oracle 9.7.2
Toad由Oracle开发专家专门为开发人员而设计,是一个功能强大、结构紧凑的专业化PL/SQL开发环境。该文档以截图形式形象介绍toad工具的基础使用。
Toad9.6.1 for oracle 破解文件同时支持