1、下载32位Oracle InstantClient,并展开到某目录,例如D:\app\sony\product\instantclient_11_2;
2、建立子目录:D:\app\sony\product\instantclient_11_2\network\admin ,将系统的tnsnames.ora拷贝到该目录下;
3、配置环境变量
path=C:\instantclient-basic-nt-11.2.0.2.0
ORACLE_HOME=C:\instantclient-basic-nt-11.2.0.2.0
TNS_ADMIN=C:\instantclient-basic-nt-11.2.0.2.0\network\admin
NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK
4、在PLSQL Developer中配置