EdgeCore version: 4.2.2

EdgeCore is able to use Oracle to store its cache. As a result, the memory footprint of your equipment will be reduced, and your servers can be smaller and less expensive.

Prerequisites

• Minimum required Oracle version: Oracle Database 12c Release 2 (12.2)
• Recommended Oracle versions: Oracle Database 18c, Oracle Database 19c
• Minimum 8 GB RAM
• At least 100 GB of disk storage space

Note: The cache database needs to be unique per server.

Setup

1. 1. Download and install Oracle.
   2. Download the JDBC Thin driver (ojdbc8.jar) and copy the JAR file to [INSTALL_HOME]/lib/
   3. Manually set the following settings in local.properties or custom.properties:

      db.cache.url=jdbc:oracle:thin:@//<host>:<port>/<SID>
      
      db.cache.username=<oracleUser>
      
      db.cache.password=<oraclePassword|will be encrypted on first run>
      
      db.cache.driver=oracle.jdbc.pool.OracleDataSource
      
      db.cache.dialect=org.hibernate.dialect.Oracle12cDialect

      Note: If configure.sh is run (preferred), these settings are already set in local.properties.

   4. If you are running configure.sh, take the necessary steps:
      a) Select Oracle as Cache DB mode.
      b) Decide whether or not to use Kerberos authentication.
      c) Provide the following information: cache db host, cache db port, cache db name, cache db options, cache db user, and cache db pass.
      
   5. Grant the following permissions to the user:

      GRANT CREATE SESSION TO <user>;
      
      GRANT CREATE TABLE TO <user>;
      
      GRANT UNLIMITED TABLESPACE TO <user>;