下载Toad绿色版(X64)Toad for Oracle 12.1(X64)
注意:必须X64,因为与之对应instant client版本是x64
1)配置环境变量
TNS_ADMIN=C:\instantclient_11_2\network\admin(必须)上章节中已配置
PATH=%PATH%;C:\instantclient_11_2(必须)
ORACLE_HOME=C:\instantclient_11_2(必须)
LD_LIBRARY_PATH=C:\instantclient_11_2(必须)
PS :重新启动电脑,使用环境变量重新加载
2)登录
单击connect ,弹出SQL执行窗口,查看当前默认用户的表空间
select username,default_tablespace from user_users;
如下:
说明,Toad(X64)远程成功登录服务器上Oracle11g数据库orcl
3)从Toad(X64)软件来查看TNS,如下
4)Toad(X64)对Instant Client - 11.2.0.4 (11.2.0.4) 解析参数,如下
ORACLE_HOME:C:\instantclient_11_2
ORACLE_HOME_NAME:C:\instantclient_11_2
ORACLE_HOME_KEY:
ORACLE_SID:
NLS_LANG:AMERICAN_AMERICA.AL32UTF8
SQLPATH:
LOCAL:
Client DLL:C:\instantclient_11_2\oci.dll
TNSNames.ora:C:\instantclient_11_2\network\admin\tnsnames.ora
SQLNet.ora:
LDAP.ora:
Login.sql:
GLogin.sql:
In system PATH:Yes
Home is valid:Yes