Stop the database and restart upgrade restricted mode

414Oracle Essbase & Oracle OLAP: The Guide to Oracle’s Multidimensional Solution

If any of these elements are missing or invalid, you need to reinstall Oracle OLAP. Before reinstalling it, you should ensure that the Java Virtual Machine (JVM), Oracle Database Java packages, Oracle XML Developer Kit (XDK), and Oracle XML DB are installed and valid. Sometimes the installation can be done using the Database Configuration Assistant (DBCA), but this is not usually the case, especially if the database instance is a custom installation. The simplest way to reinstall Oracle OLAP is to run a manual installation.

2. Go to command mode and change to the ORACLE_HOME directory.

3. Start SQL*Plus in SYSDBA mode (sqlplus / as SYSDBA).

@?/xdk/admin/initxml.sql;

@?/xdk/admin/xmlja.sql;

Check the logs to make sure that this procedure properly installed or reinstalled Oracle OLAP. You can verify the installation by rerunning the validation query.

Setting Database Parameters
You can set parameters to improve the performance of Oracle OLAP. Some of these are Oracle Database parameters; others are specific to Oracle OLAP.

	Setting

JOB_QUEUE_PROCESSES

25% of physical memory (increase up to 50% for builds and major query operations). If using MEMORY_TARGET in Oracle Database 11g, set this value to 0.

SGA_TARGET 50% of physical memory. If using MEMORY_TARGET in Oracle Database 11g, set this value to 0.

TAbLE 8-1. Initial Settings for Database Parameter Files