Artifactory Oracle Database Configuration

1. Download and install the libaio library. For example:

   • On Ubuntu 24.04: sudo apt install libaio1t64

   • On Redhat: yum install libaio

2. Copy the libaio directory to the Artifactory Tomcat lib directory, $JFROG_HOME/artifactory/var/bootstrap/artifactory/tomcat/lib.

   Create the Tomcat lib directory if it does not exist.

   The libaio directory name varies between environments. The following example shows an RHEL environment.

   Bash

   cp -rp /usr/lib64/libaio.so.1 $JFROG_HOME/artifactory/var/bootstrap/artifactory/tomcat/lib

3. Download the Oracle Instant Client lib for the environment in which your Artifactory runs.

   For example, if Artifactory runs on a Docker environment on MacOS, download the Oracle Instant Client lib for Linux.

📘

Note

Oracle Instant Client is required because the JFrog metadata service is a Go application and does not use the JDBC driver. To support the connection between Artifactory and the database, install the thin client (type 4) and the OCI (type 2).

4. Extract the Oracle Instant Client and copy the OJDBC jar file to the $JFROG_HOME/artifactory/var/bootstrap/artifactory/tomcat/lib directory.

   The name of the OJDBC jar file varies between environments. In RHEL 8, the OJDBC jar file is ojdbc8.jar.

📘

Permissions

Assign the driver the same permissions as the rest of the files in the $JFROG_HOME/artifactory/var directory.

5. Set the LD_LIBRARY_PATH variable in the system.yaml configuration file to point to the extracted Oracle Instant Client directory.

   YAML

   shared:  
     env:
       LD_LIBRARY_PATH: <Path to Artifactory Tomcat lib directory>:<Oracle Instant Client directory path>

   For example:

   YAML

   shared:  
     env:
       LD_LIBRARY_PATH: /opt/jfrog/artifactory/var/bootstrap/artifactory/tomcat/lib:/opt/jfrog/artifactory/var/bootstrap/artifactory/instant_client

6. Set the database connection details in the system.yaml configuration file. For example:

   YAML

   shared:
     database:
       allowNonPostgresql: true
       type: oracle
       driver: oracle.jdbc.OracleDriver
       url: jdbc:oracle:thin:@<your db server URL>/DBName #For example: localhost:1521/arty
       username: artifactory
       password: password

7. Start Artifactory.

Performance Optimization

Enable the artifactory.shift.events.oracledb.use.pkey.for.delete.temp.events system property to optimize DELETE operations on temporary node events and reduce database load during shift events cleanup.

When to Enable:

• Slow shift events processing
• High database load during node events cleanup
• Performance degradation during shift events operations

📘

Note

This optimization only affects Oracle database environments. Restart the Artifactory service for changes to take effect.

Configuration: Add the following to your system.yaml:

shared:
  extraJavaOpts: "-Dartifactory.shift.events.oracledb.use.pkey.for.delete.temp.events=true"