Windows 7 64bit下配置Oracle客户端

1. 下载

instant client 32bit www.oracle.com/technetwork/cn/topics/winsoft-085727.html‎

instant client 64bit www.oracle.com/technetwork/topics/winx64soft-089540.html

2. 解压

D:/instantclient121_32bit

D:/instantclient121_64bit

3. 添加环境变量

TNSADMIN D:/instantclient12164bit

4. 配置PL/SQL

D:/instantclient121_32bit/TNSNAMES.ORA

1
2
3
4
5
6
7
8
9
10
your_config_name =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = your_server_ip)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = your_sid)
      (SERVER = DEDICATED)
    )
  )

PL/SQL->Tools->Perferences->Oracle->Connection

Oracle Home=D:/instantclient12132bit OCILibrary=D:/instantclient121_32bit/oci.dll

5. 配置Navicat(64bit)

Navicat自带的oracle客户端有问题,需要手工指定路径。

Tools->Options->OCI

D:\instantclient121_64bit\oci.dll