Supported Oracle Versions Artifactory supports Oracle versions 12.2, 18, and 19. You can choose between two configurations to set up your Oracle Database Artifactory privileges Artifactory creates all tables automatically first time it is run. When performing a software upgrade Artifactory may have to alter tables and indices, so make sure you grant the configured connection the appropriate user permissions to perform such actions. Recommendation With both of the above options ( Reclaiming BLOB space For efficiency, Artifactory uses a checksum to ensure that only one copy of any binary data is stored, however, you may want to reclaim deleted BLOB space from time to time by shrinking the BLOB table space as follows: Download and install the Copy the libaio directory to the Artifactory tomcat lib directory, for example: Permissions Make sure your driver has the same permissions as the rest of the files in the Set the LD_LIBRARY_PATH, in the Artifactory System YAML, to point to the extracted Oracle Instant Client directory. Set the DB connection details in the Artifactory System YAML .Creating the Artifactory Oracle Database
DB-F
ilesystem
This configuration stores metadata in Oracle Database and artifact binary data is stored on the file system (under $JFROG_HOME/artifactory/var/data/artifactory/filestore
). This option has the advantage of being very lightweight on the Oracle database.Full DB
This configuration stores both metadata and BLOBs in Oracle Database. This option requires minimal maintenance and allows you to rely solely on Oracle for failover and backup procedures, since all data is in the database.
When using this option, make sure you have created a table space big enough to accommodate your binaries.Full DB and DB-Filesystem
), it is recommended to create a dedicated table space and use AL32UTF8
encoding.{schema}.binary_blobs modify lob (data) (shrink space cascade);
Configuring Artifactory to use Oracle
libaio
Library.#For example, on Ubuntu:
apt-get install libaio1
#For example, on Redhat:
rpm install libaio
cp -rp /usr/lib64/libaio.so $JFROG_HOME/artifactory/var/bootstrap/artifactory/tomcat/lib
ojdbc.jar
to the $JFROG_HOME/artifactory/var/bootstrap/artifactory/tomcat/lib
directory.$JFROG_HOME/artifactory/var
directory.shared:
env:
LD_LIBRARY_PATH: <path Oracle Instant Client directory, for ex: /usr/lib64>
shared:
database:
type: oracle
driver: oracle.jdbc.OracleDriver
url: jdbc:oracle:thin:@<your db server url, for example: localhost:1521>:ORCL
username: artifactory
password: password
Reclaiming Deleted BLOB Space
For example
For example