Use Oracle OLAP with Autonomous Database

Oracle OLAP is available on Autonomous Database. Oracle OLAP supports uses such as planning, forecasting, budgeting, and analysis.

Enable Oracle OLAP on Autonomous Database

Describes the steps to use Oracle OLAP on Autonomous Database.

  1. Run DBMS_CLOUD_ADMIN.ENABLE_FEATURE to enable Oracle OLAP.
    EXEC DBMS_CLOUD_ADMIN.ENABLE_FEATURE('OLAP');

    Running this command also enables Java, if it is not already enabled.

    See ENABLE_FEATURE Procedure for more information.

  2. Restart the Autonomous Database instance.
    See Restart Autonomous Database for more information.
  3. After the restart operation completes, wait for about 20 minutes to allow the Oracle OLAP installation jobs to complete.
  4. Verify that Oracle OLAP is installed.

    For example:

    SELECT comp_name, version, status FROM dba_registry
                 WHERE comp_id IN ('APS','XOQ','JAVAVM');
              
    COMP_NAME                    VERSION    STATUS 
    ---------------------------- ---------- ------ 
    JServer JAVA Virtual Machine 19.0.0.0.0 VALID  
    OLAP Analytic Workspace      19.0.0.0.0 VALID  
    Oracle OLAP API              19.0.0.0.0 VALID 
  5. Verify that Oracle OLAP is working.
    set serveroutput on 
    EXEC dbms_aw.execute('show eversion');

    This should show results like:

    Oracle OLAP Release 19.23.0.1.0

For more information, see the following: