先下载instantclient-basiclite-nt-11.2.0.2.0.zip解压到你想要放到的任何目录,如:D:\oracle\instantclient_11_2,在..../NETWORK/ADMIN/目录下有个tnsnames.ora的文件,里面加入下面的配置:
myDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.7.23)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = testdb)
)
)
注:
myDB为连接数据库别名
HOST = 192.168.7.23为你连接的数据库ip
PORT = 1521 为你数据的端口
SERVICE_NAME = testdb 为你数据库实例名
右击我的电脑选”属性”->“高级”->“环境变量”->”系统变量”
新增下面两个变量
TNS_ADMIN D:\oracle\instantclient_11_2
NLS_LANG SIMPLIFIED CHINESE_CHINA.ZHS16GBK
软件上的设置
打开pl sql,在PLSQL Developer选择Tools > Preferences >connection,在右侧的 "Oracle Home" and "OCI Library"中填入以下内容,如下(如下图片配置的路径只是示例,具体路径看你自己存放的路径):
D:\oracle\instantclient_11_2
D:\oracle\instantclient_11_2\oci.dl