Artifactory supports Oracle v10g and above.
You can choose between two configurations to set up your Oracle Database
ilesystemThis configuration stores metadata in Oracle Database and artifact binary data is stored on the file system (under
$ARTIFACTORY_HOME/data/filestore). This option has the advantage of being very lightweight on the Oracle database.
Full DBThis 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.
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.
With both of the above options (
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:
$ARTIFACTORY_HOME/etc/db.properties(If you do not have this file you can take it from the standalone zip distribution or directly from the JFrog domain). For a full explanation on the contents of this file please refer to The Bundled Storage Configurations.
$ARTIFACTORY_HOME/etc/db.propertiesfile to match the attributes of the Artifactory database you created.
Download the JDBC driver corresponding to your Oracle version from the and copy the
ojdbc6.jar file into the server's shared lib directory.
$TOMCAT_HOME/lib when installed as a service or
$ARTIFACTORY_HOME/tomcat/lib in the standalone version.
Make sure your driver has the same permissions as the rest of the files in the shared lib directory.