Make sure Oracle Database is installed and running. If Oracle Database contains a previous deployment of Oracle Business Intelligence, or if the database installation previously failed or was interrupted, follow the instructions in Uninstalling Oracle Business Intelligence Schemas from Oracle Database.
Extract the following from the installation file archive in the same file structure. Do not extract the files to a folder structure that contains spaces.
/RCU/
DBInstall.exe
Double-click DBInstall.exe to launch the database installation wizard.
On the Choose Installation or Upgrade page, select whether you are upgrading an existing database or installing a new shell database.
If you are installing a new shell database, install a clean Oracle Database server with no Reporting and Analytics objects.
On the Choose Install Set page, select myMicros.
On the MyMicros Database Information page:
To set up the Enterprise Back Office database, select Oracle, enter the network port used by the database server, and then enter the database SID in Database SID. By default, Oracle Database uses port 1521.
Fill out the rest of the form. For new installations, the form allows you to create passwords for the database users. For upgrades, you must enter the existing passwords.
On the Oracle Agg DB Config page, set up the Enterprise Back Office aggregation database:
Enter the hostname, port, and SID of the aggregation database server.
For new installations, create a password for the aggregation database. For upgrades, enter the existing aggregation database password.
For new installations:
On the Additional Users page, create passwords for the database users.
On the Sys Admin Password page, create a password for the sys admin account for the M super organization.
On the Tablespace Locations page, enter the path to the folder for storing the database tablespace files.
On the Tablespace location - SAML page, enter the path to the folder for storing the SAML database tablespace file.
If you are upgrading the database, the installation wizard does not show this page if you did not perform the versionnum prerequisite.
On the MyMicros Database Information - Master page, enter the database administrator (DBA) login credentials for the Enterprise Back Office database.
On the MyMicros Database Information - Aggregation Master page, enter the database administrator (DBA) login credentials for the aggregation database.
For new installations:
On the Get 6.2 Oracle Tokens page, create a password for an Online Analytical Processing (OLAP) user account.
On the Repository Creation Utility page, create a password for the MDS and BIPLATFORM database schema.
This screen shows during upgrades if you deleted or set OPTIONVALUE=true for the record in the CORE_OPTIONS table containing MODULENAME=obieeRcu.
On the Aggregation Users page, create passwords for the Aggregate_DB users.
If you are installing the Aggregate_DB schema with the Enterprise Back Office database, enter the same password for the SA, RPT, and UTIL users.
On the Get Oracle Aggregation tokens page, enter the path to the folder for storing the aggregation database tablespace and the aggregation database index tablespace.
On the Pre-Installation Summary page, click Install and allow the database installation or upgrade to complete.
After installation completes, increase the OPEN_CURSORS parameter for Oracle Database to at least 30,000.