Artifactory 4.x

Using Artifactory 5.x ?
JFrog Artifactory 5.x User Guide

Expand all Collapse all

Have a question? Want to report an issue?Contact JFrog support

Skip to end of metadata
Go to start of metadata

Overview

通过使用Oracle可以受益于Oracle infrastructure such as backup, restore and high availability.

For Artifactory to run with Oracle you must create a dedicated Oracle database instance and then configure Artifactory to use it as described in the following sections.

Before You Continue

Before proceeding with the steps below, please make sure you have read and followed the steps described inConfiguring the Database.

Upgrading the Database?

To avoid a regression of performance while upgrading the Oracle database (as a result of changes in the execution plans), make sure to preserve the optimizer's behavior from the previous version. For more details, please refer to Oracle documentation onInfluencing the Optimizer.

Page Contents

Creating the Artifactory Oracle Database

Supported Oracle Versions

Artifactory supports Oracle v10g and above.

You can choose between two configurations to set up your Oracle Database

  1. DB-Filesystem
    这个配置将元数据存储在Oracle Database andartifact 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.

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

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 (Full DB and DB-Filesystem), it is recommended to create a dedicated table space and useAL32UTF8encoding.

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:

Reclaiming Deleted BLOB Space 
{schema}.binary_blobs modify lob (data) (shrink space cascade);

Configuring Artifactory to use Oracle

  1. Copy$ARTIFACTORY_HOME/misc/db/oracle.propertiesto$ARTIFACTORY_HOME/etc/storage.properties
    (If you do not have this file you can take it from the standalone zip distribution or directly from theJFrog domain). For a full explanation on the contents of this file please refer toThe Bundled Storage Configurations.

  2. Adjust the connection definitions in the$ARTIFACTORY_HOME/etc/storage.propertiesfile to match the attributes of the Artifactory database you created.
    You must configure the database URL and username/password to use. The schema and tables are created first time Artifactory is run using the new database.

  3. Download the JDBC driver corresponding to your Oracle version from theJDBC/UCP Download Pageand copy theojdbc6.jarfile into the server's shared lib directory.
    For example$TOMCAT_HOME/libwhen installed as a service or$ARTIFACTORY_HOME/tomcat/libin the standalone version.

    Permissions

    Make sure your driver has the same permissions as the rest of the files in the shared lib directory.


  4. Start Artifactory.



  • No labels