Oracle Database

To use Artifactory with an Oracle database, it is required to instant client library files, libaio must be copied to the tomcat lib (Refer to NOTE 1 below). In addition, you will need to set the LD_LIBRARY_PATH env variable (Refer to NOTE 2 below).

NOTE:

Pre-start command downloads the driver and places it in /opt/jfrog/artifactory/var/bootstrap/artifactory/tomcat/lib/ and copies the files to tomcat lib so it can be used by the Artifactory.
We also use extraEnvironmentVariables to override the LD_LIBRARY_path in the system.yaml to point to the instant client.

The example below which can be added to the values.yaml:

 postgresql:
   enabled: false
 waitForDatabase: true
 database:
   type: oracle
   driver: oracle.jdbc.OracleDriver
   url: 'jdbc:oracle:thin:@database-ip:1521/ORCL'
   user: artifactory
   password: password
 artifactory:

   preStartCommand: "mkdir -p /opt/jfrog/artifactory/var/bootstrap/artifactory/tomcat/lib; cd /opt/jfrog/artifactory/var/bootstrap/artifactory/tomcat/lib && curl -o instantclient-basic-linux.x64-21.8.0.0.0dbru.zip https://download.oracle.com/otn_software/linux/instantclient/218000/instantclient-basic-linux.x64-21.8.0.0.0dbru.zip && unzip -jn instantclient-basic-linux.x64-21.8.0.0.0dbru.zip && cp /opt/jfrog/artifactory/app/artifactory/libaio/* . && ln -s /usr/lib64/libnsl.so.2 /opt/jfrog/artifactory/var/bootstrap/artifactory/tomcat/lib/libnsl.so.1 && ls -lah && rm /opt/jfrog/artifactory/var/bootstrap/artifactory/tomcat/lib/instantclient-basic-linux.x64-21.8.0.0.0dbru.zip&& cp * /opt/jfrog/artifactory/app/artifactory/libaio/"

   extraEnvironmentVariables:

   - name: LD_LIBRARY_PATH

     value: /opt/jfrog/artifactory/var/bootstrap/artifactory/tomcat/lib