Configure Artifactory to use Oracle

JFrog Installation & Setup Documentation

Content Type
Installation & Setup
ft:sourceType
Paligo
  1. Download and install the libaio library.

    #For example, on Ubuntu:
    apt-get install libaio1
    #For example, 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 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
  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 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).

  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 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.

  5. 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
  6. Set the DB connection details in the Artifactory System YAML .

    For example

    shared:
      database:
        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.