Toad DBA Suite for Oracle 12.6 64-bit Commercial 简单连接

时间:2021-06-01 04:30:48

注意:Toad DBA Suite for Oracle 12.6 64-bit Commercial安装包推荐去官网下载,中文版的最好不要使用绿色免安装版,不然连接会报各种错误

1.安装:双击下载好的安装包进行安装,安装比较简单,这里直接跳过

Toad DBA Suite for Oracle 12.6 64-bit Commercial 简单连接

2.使用:双击桌面快捷方式

Toad DBA Suite for Oracle 12.6 64-bit Commercial 简单连接

3.等待打开,注意时间可能比较长,耐心等待

Toad DBA Suite for Oracle 12.6 64-bit Commercial 简单连接

4.配置tnsnames.ora:

Toad DBA Suite for Oracle 12.6 64-bit Commercial 简单连接

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环境变量:

Toad DBA Suite for Oracle 12.6 64-bit Commercial 简单连接

6.登陆测试:有TNS了就直接连接,注意还要输入用户名和密码

Toad DBA Suite for Oracle 12.6 64-bit Commercial 简单连接

7.登陆成功:

Toad DBA Suite for Oracle 12.6 64-bit Commercial 简单连接