注意:Toad DBA Suite for Oracle 12.6 64-bit Commercial安装包推荐去官网下载,中文版的最好不要使用绿色免安装版,不然连接会报各种错误
1.安装:双击下载好的安装包进行安装,安装比较简单,这里直接跳过
2.使用:双击桌面快捷方式
3.等待打开,注意时间可能比较长,耐心等待
4.配置tnsnames.ora:
tnsnames.ora内容如下:(自己根据需求修改)
# TNSNAMES.ORA Network Configuration File: D:\oracle\ora81\network\admin\tnsnames.ora
# Generated by Oracle configuration tools. ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.222.129)(PORT = ))
)
(CONNECT_DATA =
(SID = orcl)
)
) LINUX =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.222.130)(PORT = ))
)
(CONNECT_DATA =
(SID = orcl)
)
)
5.配置tns_admin环境变量:
6.登陆测试:有TNS了就直接连接,注意还要输入用户名和密码
7.登陆成功: