Install oracle oci driver

Finally, the Instant Client is easy to install. Installation involves copying a small number of files or installing a package, for example the Linux RPM packages. The Oracle Database client-side number of required files and the total disk storage are significantly reduced.

It describes the version, date and time, and the operating system the Instant Client was generated on. The following tables shows the Oracle Database client-side files required to deploy an OCI application:. The libraries libclntsh.

On Microsoft Windows, a. When the. Fault Diagnosability in OCI. Oracle Database 12 c Release 2 When to Use Instant Client. SDK for Instant Client. Choose the Basic package. Set the operating system shared library path environment variable to the directory from Step 1. In this way, there is no dependency on the Oracle home and none of the other code and data files provided in the Oracle home are needed by OCI except for the tnsnames.

If you did a complete client installation by choosing the Admin option in Oracle Universal Installer , the Instant Client shared libraries are also installed. The locations of the Instant Client shared libraries in a full client installation are:. To enable running the OCI application using Instant Client, copy the preceding libraries to a different directory and set the operating system shared library path to locate this directory.

All the libraries must be copied from the same Oracle home and must be placed in the same directory. Co-location of symlinks to Instant Client libraries is not a substitute for physical co-location of the libraries. There should be only one set of Oracle libraries on the operating system Library Path variable.

That is, if you have multiple directories containing Instant Client libraries, then only one such directory should be on the operating system Library Path. Place all libraries in the Instant Client directory. In general, all OCI functionality is available to an application being run using the Instant Client, except that the Instant Client is for client-side operation only. Therefore, server-side external procedures cannot use Instant Client libraries.

Because Instant Client is a deployment feature, the number and size of files client footprint required to run an OCI application has been reduced. Hence, all files needed to patch Instant Client shared libraries are not available in an Instant Client deployment.

A complete client installation based on Oracle home is needed for patching. Use the opatch utility for patching. This information can be retrieved by the following command:. The process to regenerate the data shared library and the zip and RPM files changed in Oracle Database 12 c Release 1 Separate make file targets are used to create the data shared libraries, zip, and RPM files either individually or all at once.

In previous releases, one target, ilibociei , was provided to build the data shared libraries, zip, and RPM files. Now ilibociei builds only the zip and RPM files. Note that the location of the regenerated Data Shared Library, libociei. In particular, the connection string can be specified in the following formats:. The empty connection string is not supported. Consider that the listener.

The connection string can also be stored in the tnsnames. For example, consider that the tnsnames. If this tnsnames. If tnsnames. However, if the variable is set, then it does not have an impact on the operation of the OCI driver. That is:. Instant Client Light is the short name. Instant Client Light is a significantly smaller version of Instant Client. This reduces the disk space requirements of the client installation by about 63 MB. This is achieved by the lightweight Data Shared Library, libociicus.

The lightweight data shared library supports only a few character sets and error messages that are only in English. Therefore, the name Instant Client Light English. Globalization Settings. Installing Instant Client Light English. This section lists the names of the data shared libraries for Instant Client and Instant Client Light English on different platforms. The following table specifies the size of each data shared library in parentheses following the library file name.

In Instant Client Light, language can only be American , territory can be any that is supported, and characterset can be any one of the following:. With Instant Client Light, the error messages obtained are only in English.

If this library is found, then the application uses the Instant Client Light. Otherwise, a non-Instant Client is used. This section describes the ways to install Instant Client Light. For Instant Client Light, instead of downloading and expanding the Basic package, download and unzip the Basic Light package. Check the Installed Directories and Files. I have eclipse and j developer,I am more comfortable with eclipse.

My database is Oracle express edition. For example, Oracle Database