EdgeCore version: 4.2.2

As an official authentication database, Oracle is used to store:

• accounts
• provisioning
• sessions

Note: the Authentication database cannot be shared if you are using two different versions of EdgeCore.

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.auth.url=jdbc:oracle:thin:@//<host>:<port>/<SID>
   db.auth.username=<oracleUser>
   db.auth.password=<oraclePassword|will be encrypted on first run>
   db.auth.driver=oracle.jdbc.pool.OracleDataSource
   db.auth.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, select Oracle as Auth DB mode.
5. Create and grant the following:

   CREATE TABLESPACE edgeconfig
   DATAFILE  SIZE 65M AUTOEXTEND ON NEXT 10M MAXSIZE 2048M;

   CREATE USER econfig IDENTIFIED BY edgeAuth2020 DEFAULT tablespace edgeconfig
   quota unlimited on edgeconfig;

   create role edge_conf not identified;
   grant alter session, create cluster, create database link, create sequence, create session, create synonym, create table, create view, create procedure, create trigger, query rewrite to edge_conf;
   grant edge_conf to econfig;