4 Configuring Oracle Business Intelligence
This chapter walks you through a step-by-step process to configure Oracle BI standard topology using the Oracle Business Intelligence 12c Configuration Assistant.
- About the Oracle Business Intelligence Configuration Assistant
The Oracle Business Intelligence 12c Configuration Assistant is a multi-functional utility that helps you to create database schemas, specify a port range, create system components, and start the application servers in addition to configuring the BI standard topology. Oracle strongly recommends that you to use the Configuration Assistant to configure the BI domain. - Configuration Assistant Prerequisites
It is important to make sure that you meet the criteria listed in this topic for a smooth, error-free domain configuration by using the Configuration Assistant. - Creating the Database Schemas
Before you can configure an Oracle Business Intelligence domain, you must install required schemas on a certified database for use with this release of Oracle Fusion Middleware. - Configuring the BI Domain with the Configuration Assistant
The Oracle BI 12c Configuration Assistant is a.sh
(UNIX) or.cmd
(Windows) file. Start the Configuration Assistant by starting the config executable from thebi/bin
directory inside the Oracle home. Follow the procedure in this topic to complete the configuration step-by-step.
About the Oracle Business Intelligence Configuration Assistant
The Oracle Business Intelligence 12c Configuration Assistant is a multi-functional utility that helps you to create database schemas, specify a port range, create system components, and start the application servers in addition to configuring the BI standard topology. Oracle strongly recommends that you to use the Configuration Assistant to configure the BI domain.
Oracle recommends you to create the Domain home and Application home directories under /home/oracle/config
. But if you use the Configuration Assistant to configure the domain, the Application home is created under /home/oracle/product
directory. To achieve the recommended directory structure, configure the domain using the Configuration Wizard by following the procedure described in Configuring the BI Domain in Enterprise Deployment Guide
for Oracle Business Intelligence.
Parent topic: Configuring Oracle Business Intelligence
Configuration Assistant Prerequisites
It is important to make sure that you meet the criteria listed in this topic for a smooth, error-free domain configuration by using the Configuration Assistant.
To verify whether the required conditions are met, see that:
- You have correctly installed the BI product binary files.
- You have the latest supported JDK installed on your system.
- You have access to any one of the Oracle certified databases: Oracle, DB2, SQLServer, or RAC.
- (Optional) You have connection details of existing RCU schema prefix (STB) and you have already created BIPLATFORM, IAU, OPSS, MDS, STB, and WLS schemas in a single session.
Note:
You can, alternatively, generate a schema prefix (STB) and create the BIPLATFORM, IAU, OPSS, MDS, STB, and WLS schemas while you run the BI Configuration Assistant, provided you have the DBA credentials.
Note:
The database schemas are required to store internal housekeeping information. These schemas are different from any data sources which you plan to analyze by using Oracle BI.Parent topic: Configuring Oracle Business Intelligence
Creating the Database Schemas
Before you can configure an Oracle Business Intelligence domain, you must install required schemas on a certified database for use with this release of Oracle Fusion Middleware.
- Installing and Configuring a Certified Database
Before you create the database schemas, you must install and configure a certified database, and verify that the database is up and running. - Starting the Repository Creation Utility
Start the Repository Creation Utility (RCU) after you verify that a certified JDK is installed on your system. - Navigating the Repository Creation Utility Screens to Create Schemas
Enter required information in the RCU screens to create the database schemas.
Parent topic: Configuring Oracle Business Intelligence
Installing and Configuring a Certified Database
Before you create the database schemas, you must install and configure a certified database, and verify that the database is up and running.
Parent topic: Creating the Database Schemas
Starting the Repository Creation Utility
Start the Repository Creation Utility (RCU) after you verify that a certified JDK is installed on your system.
To start the RCU:
Parent topic: Creating the Database Schemas
Navigating the Repository Creation Utility Screens to Create Schemas
Enter required information in the RCU screens to create the database schemas.
- Introducing the RCU
The Welcome screen is the first screen that appears when you start the RCU. - Selecting a Method of Schema Creation
Use the Create Repository screen to select a method to create and load component schemas into the database. - Providing Database Connection Details
On the Database Connection Details screen, provide the database connection details for the RCU to connect to your database. - Specifying Schema Passwords
On the Schema Passwords screen, specify how you want to set the schema passwords on your database, then enter and confirm your passwords. - Completing Schema Creation
Navigate through the remaining RCU screens to complete schema creation.
Parent topic: Creating the Database Schemas
Introducing the RCU
The Welcome screen is the first screen that appears when you start the RCU.
Click Next.
Selecting a Method of Schema Creation
Use the Create Repository screen to select a method to create and load component schemas into the database.
-
If you have the necessary permissions and privileges to perform DBA activities on your database, select System Load and Product Load. This procedure assumes that you have SYSDBA privileges.
-
If you do not have the necessary permissions or privileges to perform DBA activities in the database, you must select Prepare Scripts for System Load on this screen. This option generates a SQL script that you can give to your database administrator. See About System Load and Product Load in Creating Schemas with the Repository Creation Utility.
-
If the DBA has already run the SQL script for System Load, select Perform Product Load.
Providing Database Connection Details
On the Database Connection Details screen, provide the database connection details for the RCU to connect to your database.
Note:
If you are unsure of the service name for your database, you can obtain it from the SERVICE_NAMES
parameter in the initialization parameter file of the database. If the initialization parameter file does not contain the SERVICE_NAMES
parameter, then the service name is the same as the global database name, which is specified in the DB_NAME
and DB_DOMAIN
parameters.
For example:
- Database Type: Oracle Database
- Host Name: examplehost.exampledomain.com
- Port: 1521
- Service Name: Orcl.exampledomain.com
- User Name: sys
- Password: ******
- Role: SYSDBA
Click Next to proceed, then click OK in the dialog window that confirms a successful database connection.
Specifying Schema Passwords
On the Schema Passwords screen, specify how you want to set the schema passwords on your database, then enter and confirm your passwords.
You must make a note of the passwords you set on this screen; you will need them later on during the domain creation process.
Completing Schema Creation
Navigate through the remaining RCU screens to complete schema creation.
On the Map Tablespaces screen, the Encrypt Tablespace check box appears only if you enabled Transparent Data Encryption (TDE) in the database (Oracle or Oracle EBR) when you start the RCU. Select the Encrypt Tablespace check box if you want to encrypt all new tablespaces that the RCU creates.
When you reach the Completion Summary screen, click Close to dismiss the RCU.
Configuring the BI Domain with the Configuration Assistant
The Oracle BI 12c Configuration Assistant is a .sh
(UNIX) or .cmd
(Windows) file. Start the Configuration Assistant by starting the config executable from the bi/bin
directory inside the Oracle home. Follow the procedure in this topic to complete the configuration step-by-step.
Note:
Oracle recommends that you use the Oracle BI 12c Configuration Assistant to configure your 12c system.Important:
If you are extending the WebLogic domain with Oracle Business Intelligence by using the Configuration Assistant, make sure that the Administration Server for the domain is named AdminServer. Other names for the Administration Server are not supported.Note:
Context-sensitive help is available on each screen as you navigate through the Configuration Assistant. Click Help to seek more information about the elements on that screen.Parent topic: Configuring Oracle Business Intelligence