1, 到ORACLE官网下载oracle instantclient: instantclient-basic-win32-11.2.0.1.0.zip
2, 在C盘创建目录c:/oracleclient
3, 将instantclient-basic-win32-11.2.0.1.0.zip解压到 c:/oracleclient
4, 在c:/oracleclient/instantclient_11_2下创建目录network,并在network下创建目录admin,在admin下创建文件tnsnames.ora
5, tnsnames.ora的内容为如下格式:
databasename =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ip address)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = database name)
)
)
如:
orcl =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.3.124)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
6, 创建系统环境变量nls_lang,值为AMERICAN_AMERICA.ZHS16GBK(该值应和服务器端字符集一致)
7, 进入PL/SQL DEVELOPER(点取消进入即可),打开TOOLS/PREFERENCE 将ORACLE HOME设置为C:/OracleClient/instantclient_11_2 , 将OCI library设置为C:/OracleClient/instantclient_11_2/oci.dll
8, 退出PL/SQL DEVELOPER,重新登录