Setup Required for OCI Driver
Data sources are created with OCI enabled. For this, Oracle Instant Client
is required, below steps needs to be followed
- Download Oracle Instant Client corresponding to the used Oracle DB
and java (x64 or
x32):
https://www.oracle.com/database/technologies/instant-client/downloads.html
- 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: Data Source creation and JDBC Configuration