No Results
Oracle Authentication Database

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;

Terms | Privacy