Configure Artifactory to use Oracle

Download and install the libaio library.

#For example, on Ubuntu:
apt-get install libaio1
#For example, on Redhat: 
yum install libaio

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 doesn't exist.
The libaio directory name varies between environments. The following example shows an RHEL environment.
```
cp -rp /usr/lib64/libaio.so.1 $JFROG_HOME/artifactory/var/bootstrap/artifactory/tomcat/lib
```
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 a mandatory requirement because the JFrog metadata service does not use the JDBC driver since its a Go application and not Java. Therefore, to support the connection between Artifactory and database, you would need to install the thin client (type 4) and the OCI (type 2).
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 files varies between environments. In RHEL 8, the the OJDBC jar file ojdbc8.jar.
Permissions
Make sure your driver has the same permissions as the rest of the files in the $JFROG_HOME/artifactory/var directory.

Set the LD_LIBRARY_PATH, in the Artifactory System YAML, to point to the extracted Oracle Instant Client directory.

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

For example

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

Set the DB connection details in the Artifactory System YAML .

For example

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

Start Artifactory.

Note

Permissions