1,去oracle官网下载软件包:仅30m左右
(注:本次本载的就是windows 32bit支持各种oci,jbdc,obdc的软件包)
2,解压软件包
(注:我解压在 D:\instantclient_10_2)
3,在windows的系统变量配置:PATH,TNS_ADMIN,NLS_LANG,ORACLE_HOME
诸多参数值分别为:软件包解压后形成的目录
NLS_LANG根据oracle 10.2.0.4上面的配置进行调整
3,手工编写一个TNSNAMES.ORA文件:
(注:必须正确配置TNS_ADMIN,不然plsql developer打开登陆提示,找不到tnsnames.ora文件,在此配置为客户端软件解压后的目录)
only_192.168.125.3=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.125.3)(PORT = 1521))
)
(CONNECT_DATA =
(SID = only)
(SERVER = DEDICATED)
)
)
4,打开plsql developer(本次采用8.0.5)
tools/preferences,配置oci及oracle_home,path等变量值,对应上面第3步的参数配置
5,连接oracle 10.2.0.4