Use Oracle OLAP with Autonomous AI Database

Describes the steps to use Oracle OLAP on Autonomous AI 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 AI Database instance.
   See Restart Autonomous AI 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