免安装Oracle运行pl/sql developer
时间:2010-08-30 来源:情缘鸟
1, 从http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html中 下载:instantclient-basic-win32-10.1.0.5-20060419.zip.
2,在磁盘创建上目录,解压过去,最终解压文件会在同一个目录下。比如解压到c:\oracleclient
3,在目录c:\oracleclient\下创建文件tnsnames.ora 内容如下
oracledata =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle数据库安装机器的IP)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = yourSID )
)
)
4、配置环境变量,在PATH变量中加入c:\oracleclient
5、注册表加入下面键值
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\Environment]
"LD_LIBRARY_PATH"="d:\OracleInstantClient"
"NLS_LANG"="AMERICAN_AMERICA.ZHS16GBK"
"TNS_ADMIN"="d:\OracleInstantClient"
6,设置pl/sql Developer的perference,主要填二个文本框 OCI Library:“c:\oracleclient\oci.dll”, Oracle_home: "c:\oracleclient\"
完成!