Oracle Database 21c Express Edition

Follow these instructions to install, setup, and configure VoiceConsole to use Oracle Database 21c Express Edition (XE).

1. Download Oracle Database 21c Express Edition from www.oracle.com.

2. Open a Command Prompt window as an administrator, and run the following commands:

   1. Type the command below to connect to the database:

      sqlplus / as sysdba

   2. From the SQL> prompt type:

      Copy

      ALTER SESSION SET CONTAINER = xepdb1;

   3. {{TABLESPACE_NAME}} is to replaced with the name assigned to the database in the following command.

      Copy

      CREATE TABLESPACE {{TABLESPACE_NAME}} DATAFILE '{{TABLESPACE_NAME}}.dbf' SIZE 100M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED ONLINE;

   4. {{USER_NAME}} and {{PASSWORD}} are to be replaced with the credentials to be used to access the database in the following command.

      Copy

      CREATE USER {{USER_NAME}} IDENTIFIED BY {{PASSWORD}} DEFAULT TABLESPACE {{TABLESPACE_NAME}} QUOTA UNLIMITED ON {{TABLESPACE_NAME}};

   5. {{USER_NAME}} to be replaced with the credential from the earlier command

      Copy

      GRANT CONNECT, RESOURCE, DBA TO {{USER_NAME}};

   6. {{USER_NAME}} to be replaced with the credential from the earlier command

      Copy

      GRANT ALL PRIVILEGES TO {{USER_NAME}};

3. During VoiceConsole installation, make the following entries on the select Database Configuration tab:

   • Database Server: Oracle

   • Select Basic Settings

   • Database Hostname: IP address of the host machine, which can be determined by running ipconfig at a command prompt

   • Database Port: 1521 (default)

   • SID / Service Name: is xepdb1 (default)

   • Database Username: as configured above

   • Database Password: as configured above