1. 下载instantclient-basic-win32-11.2.0.1.0(oracle官网下载地址:http://www.oracle.com/technetwork/topics/winsoft-085727.html , 下载地址2:)
2. 解压instantclient-basic-win32-11.2.0.1.0并放置在oracle安装目录(非oracle安装目录也行)
3.将F:/app/lenovo/product/11.2.0/dbhome_1/NETWORK/ADMIN/tnsnames.ora复制到F:/app/lenovo/instantclient_11_2下; 4. 打开PLSQL Developer,选择Tools -> perference -> Connection,配置其中的Oracle Home和OCI Library项,如下图所示:
5.配置环境变量:变量名设置为"TNS_ADMIN", 变量值设置为"F:\app\lenovo\instantclient_11_2"变量名设置为"NLS_LANG", 变量值设置为"AMERICAN_AMERICA.UTF8" (安装oracle时我指定的是UTF8)