Topics:
Regarding the hardware and performance requirements for Oracle BI Applications, refer to the Oracle BI Applications certification matrix on Oracle Technology Network.
For additional information about hardware requirements for Oracle Analytics Server and Oracle Data Integrator (ODI), see Oracle Fusion Middleware Supported System Configurations on Oracle Technology Network.
You must install certain components before you can install Oracle BI Applications.
Prior to installing an Oracle database, refer to the Oracle BI Applications certification matrix on Oracle Technology Network for the certified Oracle databases. While installing the database, ensure that you don’t select a container database.
Use these instructions to install and configure Oracle BI Applications.
You must perform the following procedures in the order they are listed:
To install the recommended JDK version, refer to the Oracle BI Applications certification matrix on Oracle Technology Network.
Note:
Ensure that you remove any other version of Java present in the system before installing JDK on your local machine and not in any NFS path.You may set JAVA_HOME
as the environment variable for further use. You may set JAVA_HOME as the environment variable for further use. Add $JAVA_HOME/bin
in your PATH variable. You may use /usr/sbin/alternatives --config java
to configure the recommended version as the default version of Java.
Oracle BI Applications requires Oracle Fusion Middleware Infrastructure 12.2.1.4.
JAVA_HOME
, and then start the Oracle WebLogic Server installation by using this command: $JAVA_HOME/bin/java -jar fmw_12.2.1.4.0_infrastructure.jar
/scratch/biapps/installation/InvWLS
and click OK
./scratch/biapps/Oracle/Middleware/NEW_ORACLE_HOME
and click Next.You must run the repository creation utility (RCU) to create schemas for Oracle Analytics Server.
Note:
Ensure that the password is the same for all Oracle Fusion Middleware schemas such as the MDS, BIPLATFORM, STB, OPSS, IAU, and WLS schemas. Not all special characters are allowed in the schema password. It can contain #, underscore but shouldn't contain $, parenthesis ( ), or @. A database service might enforce special characters, so use only underscore. The password you provide in RCU can't be changed by SQL command.Install Oracle Data Integrator using the Oracle Data Integrator installer.
You must create and load the Oracle BI Applications schemas in the database using the Repository Creation Utility (RCU).
/dbhost/dumps
. These dumps are available under ORACLE_HOME/oracle_common/rcu/integration/biapps/schema
.Oracle recommends that you ensure that the database password for all BIAPPS
schema users doesn’t expire. Resetting the database password might lead to failure in the BIAPPS
components operations.
After the software-only install, you must apply patches on the NEW_ORACLE_HOME
location where you installed Oracle Fusion Middleware Infrastructure 12.2.1.4.
Use Configuration Assistant to configure Oracle Analytics Server.
The configuration script expects details about your environment. You must copy the ORACLE_HOME/bi/biapps/scripts/input.txt
file to a location and edit the input.txt
file to update the properties for your environment.
input.txt
file, ensure that you've decided your configuration plan, such as:
Based on your choices, you need to modify the properties in your input.txt
file. Ensure that you don't delete or comment out any of the properties.
Note:
Ensure that you edit theinput.txt
file only in Linux using the Visual Editor (Vi Editor). Don't edit the file in the Windows machine and copy to Linux. Editing in Windows causes the configuration to fail.Property | Property Value |
---|---|
biprov.jdk_home.dir |
Provide the JDK directory, under which the bin folder must exist. |
biprov.oracle_home.dir |
Provide the absolute path where you'd install Oracle BI Applications, such as /u01/installation/Middleware/Oracle_home . The configuration process creates a directory and you must ensure that the users have write permission on that path. |
biprov.db.schema.prefix |
Provide the schema prefix used during the Oracle Analytics Server RCU run. |
biprov.odi.db.schema.prefix |
Provide the schema prefix for the ODI schema created using the RCU. |
biprov.fa.admin.user |
Provide the administrator username for Oracle Weblogic Server. Choose any name without special characters. |
biprov.fa.admin.pwd |
Provide the password of the Oracle Weblogic Server administrator. |
biprov.odi.port |
Provide port for ODI managed server or retain the default value. |
biprov.odi.ssl.port |
Keep blank (SSL not supported in Oracle BI Applications). |
biprov.odi.is.ssl.configured |
Keep as false (SSL not supported in Oracle BI Applications). |
biprov.odi.user.name |
Provide username of Oracle BI Applications administrator. This user can access Oracle WebLogic Server, Oracle Analytics Server, Oracle Business Intelligence Applications Configuration Manager, and Oracle Data Integrator. |
biprov.odi.console.user.pwd |
Provide the password for the Oracle BI Applications administrator. Don't include special characters. |
biprov.odi.cluster.name |
Provide the cluster name for the ODI managed server or retain the default value. |
biprov.isRac |
Provide the value as false (even for scan URL). |
[DW_DATABASE] DW_DATABASE_CONNECTION_STRING |
Provide the connection string in host:port/service format for the data warehouse schema. |
DW_DATABASE_SCHEMA_USER_NAME |
Provide the data warehouse schema username. |
DW_DATABASE_SCHEMA_PASSWORD |
Provide the password for the data warehouse schema user. |
DW_DATABASE_TYPE |
Don’t change the value. |
biprov.ldap.external.user |
Keep blank. |
biprov.ldap.pwd |
Provide a password for the LDAP administrator and note the value for future reference. The password of the embedded LDAP administrator is reset to this value. |
biprov.ldap.external.url |
Keep blank. |
biprov.ldap.external.user_prefix |
Keep blank. |
biprov.ldap.external.group_prefix |
Keep blank. |
biprov.adw.env |
Ensure that the value is set to False to disable the autonomous data warehouse configuration. In case you're planning to configure the autonomous data warehouse, refer to Configure Oracle BI Applications with Oracle Autonomous Data Warehouse. |
There are other schemas, like BIACOMP, ODI_REPOSITORY, MDS, and STB. You need to fill similar sections for those schemas. After that, depending on which source you want to use, enable the appropriate SDS schemas. For example, if you're using Oracle Fusion source, then fill in the [FUSION11_SDS_DATABASE] section. For Oracle E Business Suite source, fill in [EBS122_SDS_DATABASE].
After the input.txt
file is ready, go to $ORACLE_HOME/bi/biapps/scripts
directory and run the following command:
java –jar obia.config.jar <path of edited input.txt>/input.txt
Connect Oracle BI Applications to Oracle Autonomous Data Warehouse to access the data warehouse schemas.
You can configure Oracle BI Applications with Oracle Autonomous Data Warehouse to access the data warehouse schemas. My Oracle Support provides detailed instructions for obtaining the latest patches, applying the patches, and provisioning. See My Oracle Support note Doc ID 2808444.1 for instructions and details of the patch set.
Load translation data into the BIACOMP
schema of Oracle BI Applications.
Note:
You must complete all the steps listed in Installing and Setting Up Oracle BI Applications without any errors prior to loading the translation data.BIACOMP
schema is available.C_RPD_MSGS
, C_RPD_MSGS_REL
, and C_RPD_MSGS_TL
tables exist in the BIACOMP
schema.Oracle Data Integrator Studio (ODI Studio) is the interface that you use to manage and configure Oracle Data Integrator (ODI)
ODI Studio is installed as part of the standalone or enterprise option under the specified ORACLE_HOME
directory. ODI Studio provides four graphical navigators for managing ODI artifacts: Designer, Operator, Topology, and Security. ODI Studio can also directly execute jobs on demand, and you can use it for development and testing.
Use these instructions to configure authentication.
DOMAIN_HOME/odi-client-config/embedded
directory. In case you're using Oracle Internet Directory as LDAP, then browse the DOMAIN_HOME/odi-client-config/external
directory.cwallet.sso
and jps-config.jse.xml
to ORACLE_HOME/odi/studio/bin
.DOMAIN_HOME/config/fmwconfig/System-jazn-data.xml
to the ORACLE_HOME/odi/studio/bin
directory.Use these instructions to set the location of the JPS Config
file.
ORACLE_HOME/odi/studio/bin
directory.odi.conf
file in an editor.AddVMOption -Doracle.security.jps.config=./jps-config-jse.xml
.Use these instructions to start ODI Studio.
ORACLE_HOME/odi/studio
directory../odi.sh -clean -initialize
.If you're planning to use a real application cluster (RAC) database to configure Oracle BI Applications, then follow these additional steps.
Note:
Oracle recommends that you use the SCAN URL for the RAC database. You can directly use the SCAN URL in the configuration.Instead of using Oracle Weblogic’s embedded LDAP, you can use Oracle Internet Directory as an external LDAP for users.
Note:
Oracle BI Applications only supports Oracle Internet Directory.If you want to configure Oracle BI Applications with Oracle Internet Directory, first configure Oracle BI Applications to use embedded LDAP, and then see the instructions in My Oracle Support Doc ID 2818769.1 to switch from embedded LDAP to Oracle Internet Directory.
You can configure Oracle BI Applications in high availability mode or horizontal scale-out mode. Two physical hosts support in domain and both installs have Oracle WebLogic Server running. The Oracle HTTP server is the load balancer.
Note:
You can perform steps 3 and 4 either manually or by using automated scripts./etc/hosts
file on each host must have entry of the other host./etc/hosts
file must be the same./u01/middleware
then node2 should also have ORACLE_HOME in /u01/middleware
. But ORACLE_HOME mustn't be the common drive between these hosts. See Add New Computers.Use these steps to configure high availability with automated scripts.
Use these steps to configure high availability manually.
For Oracle Analytics Server high availability steps, see About Scaling Oracle Analytics Server and for Oracle Data Integrator high availability steps, see the Oracle Support document "How To Create And Deploy a High Availability ODI 12c Java EE Agent to a Cluster on WebLogic Server" (Doc ID 1676176.1).
Use these steps to configure Oracle HTTP server (OHS) for high availability.