Archive for April 17th, 2010
Config PL/SQL Developer without installing Oracle client
Follow the following steps to config your PL/SQL Developer without installing Oracle client:
- download instant client package http://download.oracle.com/otn/nt/instantclient/112010/instantclient-basic-win32-11.2.0.1.0.zip
- extract it to C:\Oracle\instantclient_11_2
- add C:\Oracle\instantclient_11_2 to %PATH%
- set %LD_LIBRARY_PATH%, %SQLPATH% and %TNS_ADMIN% as C:\Oracle\instantclient_11_2
- set OCI Library as “C:\Oracle\instantclient_11_2\oci.dll” in PL/SQL Developer (Tools->Preferences->Connection)
- done
I verified it on Windows 7, it works.
[ad]