Using Oracle Database Instant Client Lite

If you are only accessing Oracle in the development environment, it is recommended to use the Oracle Database Instant Client (Lite), which is relatively small and does not require a green portable installation.

Official download Instant Client, finding download links on the Oracle Web site is a very painful thing to find. For convenience, here is a Instant Client download page for all platforms:

Select the version according to your system environment, unzip it after downloading is complete.

Here are two points to note:

1, Plsql developer use, because Plsql developer does not support 64-bit Oracle client, you must download the 32-bit instant client version.

Create a new system environment variable first:

Variable name: Nls_lang; variable value: Simplified Chinese_china. Zhs16gbk

Variable name: tns_admin; variable value (Instant client directory path, for example): C:\app\Administrator\product\11.2.0\client_1\network\admin

Then open plsql developer–> tools–> preferences,oracle Home, OCI Library Enter the instant client directory path.

2. In the recent use of a SharePoint project, it was found that if you use the 32-bit instant Client, an exception is thrown:

System.InvalidOperationException: BadImageFormatException is raised when attempting to load the Oracle client library. This problem occurs if you are running in 64-bit mode with the 32-bit Oracle client component installed.

WORKAROUND: You need to download the 64-bit instant Client, unzip it, and then add the directory path of the 64-bit lite in the system environment variable's path argument.

Using Oracle Database Instant Client Lite