Configure APEX to support ORDS database - Version 2020 (10.0) - Hexagon

Smart Materials Web Installation (10.1)

Smart Materials/Smart Reference Data Version
  1. Login with the local administrator account.

  2. Open a Command Prompt window as an administrator.

  3. Change your working directory to the apex directory where you unzipped the Oracle Application Express (APEX) installation software (for example, c:\tmp\apex).

  4. Set the following Oracle parameters:


  5. Launch SQL*Plus and connect to the database (where APEX is installed) as SYS specifying the SYSDBA role.

  6. Run the apex_rest_config.sql script passing the file system path to the base directory where the Oracle Application Express software was unzipped as shown in the following example (Windows OS).

    Configure APEX to support ORDS Database

    Configure APEX to support ORDS Database - 2