OBIEE 12c - RCU - Create Repository

There are a few dependencies when running the OBIEE 12c RCU, one of which is that the database must be at least 11.2.0.4.

After that the next thing you notice after starting the RCU is the options available.

You now have the ability to generate the RCU scripts and pass them on to a DBA to run in seperately, rather than beg for admin access, organise meetings etc... just to run the RCU.

If you have the permissions already then nothing has changed and the top option System Load and Product Load is for you.

The remaining two options are to generate scripts and then load in the product information

• Select Prepare Scripts for System Load if you are unable to provide login credentials for a user with DBA privileges. RCU will create the necessary SQL scripts for creating the component schema and also update schema_version_registry entry for selected components and change the status to "LOADED." Once the scripts are generated, another user with DBA privileges can run the scripts using SQL*Plus to complete the system load phase. 
• Select Perform Product Load only after the system load phase scripts have been run to update the schema_version_registry and set the status to "VALID." Users with non-DBA privileges are able to select and execute this option. During the system load phase, some components will generate an additional post-data load script that requires DBA permissions. These scripts will also be run during the product load phase.

This means that the DBA gets to keep control, and you get your repository without ruffling too many feathers.

Sharing Schemas Required by Oracle Business Intelligence

The Repository Creation Utility (RCU) creates the BIPLATFORM and MDS schemas that are used when you install OBIEE 11g.

Now if you run a multi-node system what do you do, can you use the same RCU created schemas, or do you have to create parallel ones?

This extract from the Oracle OBIEE documentation (http://docs.oracle.com/cd/E23943_01/bi.1111/e10539/c3_requrmnts.htm#BABBICDA) provides the answer, which states that:

If you scale out a system from a primary node, the new nodes share the same RCU schemas as the primary.
A new OBIEE system needs separate RCU schemas.

------------------- extract ---------------------
If your organization has an MDS schema installed in a supported database, you do not need to install the MDS schema again with the RCU. You can use the existing MDS schema for your Oracle Business Intelligence installation. For this option, deselect the Metadata Services schema in the Select Components screen of the RCU. Then, when you install Oracle Business Intelligence, specify the details for the existing MDS schema in the MDS Schema screen.

However, each Oracle Business Intelligence system (BI domain) requires its own BIPLATFORM schema. Two or more systems cannot share the same BIPLATFORM schema, although they can share the same database. Therefore, you must run the RCU and install the BIPLATFORM schema and the MDS schema (if no MDS schema exists) before installing each distinct Oracle Business Intelligence system (BI domain). For example, if you plan to install two Oracle Business Intelligence systems, you must run the RCU and install the required schemas twice, or once for each system.

This requirement does not apply when you scale out an Oracle Business Intelligence system. In a scaled-out (clustered) system, you only run the RCU and install the database schemas once, before installing the primary node of the Oracle Business Intelligence cluster (the BI domain for the cluster is created at that time). Additional Oracle Business Intelligence nodes that you install during the scale-out process become members of that domain and, therefore, use the same set of schemas.

Installing OBIEE 11.1.1.6 RCU on Windows Server 2008 64bit.

The Repository Creation Utility

Copy across the Repository Creation Utility RCU and the 5 zipped disks for the OBIEE install to a directory on E:

Creating the repository.

Unpack the RCU and navigate to /rcuHome/bin and run rcu.bat

Select Create

Enter the server and connection details 

You will then have a confirmation box with all prerequisites ticked.

Create an new prefix for your install and select Oracle Business Intelligence from the boxes below.

Another confirmation box

Set the schema passwords

Either allow the default tablespace creation or remap to existing tablespaces.

Another confirmation box

Click create.

Click close and you’re done.