Oracle Business Intelligence requires a repository database. Use the Repository Creation Utility that is provided with Oracle Business Intelligence to configure the databases schemas for the repository.
To configure the Oracle Business Intelligence repository:
Prepare a database installation for the repository. You must have a user account with system administrator permission for the database installation. For example, if you are using Oracle Database, make sure you can log into the SYS user account. The Repository Creation Utility will use this account to create additional user accounts, table spaces, and schemas.
Download the Repository Creation Utility from the Oracle Business Intelligence download Web page (http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/biee-111150-393613.html). Expand the utility zip file.
Invoke the
rcu
orrcu.bat
program in thercuHome\BIN
directory.Follow the prompts in the utility to configure a connection to the repository database and create the database schemas that Oracle Business Intelligence requires. Keep a record of the database account names and passwords that you create. You will need these when you configure the Oracle Business Intelligence server.
Note: See comprehensive information about the Repository Creation Utility and Oracle Business Intelligence in the documentation for that product (http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/documentation/bi-ee-087853.html).