1. Weblogic Configuration
  2. Resource Administration
  3. Creating Data Source
  4. Prerequisites

7.2.1.1 Prerequisites

You need to create the data source with OCI enabled. For this, download Oracle Instant Client and install it. The details are given below.
Package Download Location Remarks
Oracle Instant Client Package https://www.oracle.com/database/technologies/instant-client/downloads.html Install Oracle Instant Client in a local directory. While configuring Weblogic for Windows or Unix/Linux box, you need to provide the directory path where Instant Client is installed.
You need to do the data source configuration with OCI driver enabled. The configurations are given below.
  • Oracle Weblogic on Windows Box:
    • Set {ORACLE_HOME} in the environment variable.
    • Update the Environment Variable Path as {ORACLE_HOME}/Instance Client.
    This is required to load all the .dll files.
    • Ensure that the ojdbc*.jar file in {WL_HOME}/server/lib/ojdbc*.jar is the same as the file {ORACLE_HOME}/jdbc/lib/ojdbc*.jar. This is required for ensuring compatibility.
    • Update PATH in StartWebLogic.bat or in setDomainEnv.bat. This must be the path of directory where Oracle Instant Client is installed.
  • Oracle Weblogic on Unix/Linux Box:
    • Set {ORACLE_HOME} in the environment variable.
    • Update the environment variable LD_LIBRARY_PATH as {ORACLE_HOME}/lib. This is to load all the .so files.
    • Ensure that the ojdbc*.jar file in {WL_HOME}/server/lib/ojdbc*.jar is the same as the file {ORACLE_HOME}/jdbc/lib/ojdbc*.jar. This is to ensure compatibility.
    • Update LD_LIBRARY_PATH in StartWeblogic.sh or in setDomainEnv.sh. This must be the path of directory where Oracle Instant Client is installed.
  • If you are still not able to load the .so files, then you need to update the EXTRA_JAVA_PROPERTIES by setting Djava.library.path as {ORACLE_HOME}/lib in StartWebLogic.sh or in setDomainEnv.sh.

Parent topic: Creating Data Source