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. 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>;
```