1、首先到Oracle网站,或到我的资源中下载Instant Client :
http://www.oracle.com/us/solutions/index-097480.html
2、在instantclient_10_2目录下新建目录network,在network目录下再建admin目录,在admin目录下新建文件tnsnames.ora,打开写入如下内容:
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
3、添加一个环境变量,名为TNS_ADMIN,值为tnsnames.ora文件所在路径。
4、配置navicat的oci路径instantclient_10_2/oci.dll
配置pl/sql的Oracle Home路径instantclient_10_2,oci路径instantclient_10_2/oci.dll