Oracle Database Drivers

In addition to the following recommendations, be sure and follow vendor documentation for driver installation best practices.

Table 1.
Component	Required Driver Version	Notes
Web application	v11.2.0.4 OCI (ojdbc6.jar)	Type the following from a command line as the jive user: jive set webapp.custom_ld_library_path_additions path/to/driver jive set webapp.custom_classpath_additions path/to/your_JDBC_Driver.jar where `path/to/driver` is the path to the Oracle JDBC driver and `your_JDBC_Driver.jar` is the name of the JAR file.
Activity Engine	v11.2.0.4 (THIN) (ojdbc6.jar)	Type the following from a command line as the jive user: jive set eae.custom_ld_library_path_additions path/to/driver jive set eae.custom_classpath_additions path/to/your_JDBC_Driver.jar where `path/to/driver` is the path to the Oracle JDBC driver and `your_JDBC_Driver.jar` is the name of the JAR file.

Additional Configuration for Oracle 11gR2 and 12

Customers using Oracle 11gR2 and 12 need to add a fetchSizeSupported entry in the database element of the jive_startup.xml file as shown: <jive> <setup>true</setup> <temp/> <locale> <characterEncoding>UTF-8</characterEncoding> </locale> <database> <defaultProvider> <password encrypted="true"></password> <connectionTimeout>60</connectionTimeout> <maxConnections>50</maxConnections> <username>username</username> <driver>oracle.jdbc.driver.OracleDriver</driver> <minConnections>25</minConnections> <serverURL>jdbc:oracle:oci:@host:1521/db</serverURL> </defaultProvider> <fetchSizeSupported>false</fetchSizeSupported> </database> <connectionProvider> <className>com.jivesoftware.base.database.DefaultConnectionProvider</className> </connectionProvider> </jive>

Required Libraries for RHEL7

Note that distributions based on RHEL7 do not always install libaio.so by default. This library is required to use the Oracle driver. On app servers running Red Hat 7 or CentOS 7 that use Oracle as a database, make sure to run the following command:

 # apt-get update && apt-get install libaio1</codeblock>