1. 下载toad软件和oracle的instantclient包(管方下载,如:instantclient-basic-win32-11.2.0.1.0.zip)
2. 安装完后toad后,将Oracle Instatnt Client解压。如:D:/instantclient_11_2
3. 环境变量配置: "控制面板"-"系统"-"高级"-"环境变量"-"系统变量"添加
NLS_LANG = AMERICAN_AMERICA.ZHS16GBK
TNS_ADMIN = D:\instantclient_11_2
LD_LIBRARY_PATH = D:\instantclient_11_2
SQLPATH = D:\instantclient_11_2
Path变量结尾添加D:\instantclient_11_2
4. 在D:\instantclient_11_2中用添加如下内容的文件,文件名为tnsnames.ora(也可将ORACLE里的复制过来)
5. 附ORA文件内容与格式
tnsnames.ora
#D:/instantclient_11_2/tnsname.ora
mydb1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =192.168.0.11)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = dedicated)
(SERVICE_NAME =ORCL)
)
)