Oracle business intelligence application obia

Follow these instructions for installing and setting up Oracle Business Intelligence Applications ( Oracle BI Applications ).

Hardware Requirements

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.

Installation Prerequisites for Oracle BI Applications

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.

If you're planning to use Oracle Autonomous Transaction Processing (ATP), then you must also configure Oracle Autonomous Datawarehouse (ADW). On ATP, create the BI platform schema, ODI schema, and BI_COMP schema. Create rest of the schemas such as DW and SDS on ADW.

Install and Configure Oracle BI Applications

Use these instructions to install and configure Oracle BI Applications .

You must perform the following procedures in the order they are listed:

  1. Install JDK
  2. Install Oracle Fusion Middleware Infrastructure (WebLogic Server)
  3. Install Oracle Analytics Server
  4. Create Schemas Using RCU
  5. Install Oracle Data Integrator
  6. Install Oracle BI Applications
  7. Create Schemas for Oracle BI Applications
  8. Apply Mandatory Patches
  9. Configure Oracle Analytics Server
  10. Edit Your Input File
  11. Configure Oracle BI Applications
  12. Load Translation Data
  13. Configure Oracle Data Integrator Studio
  14. Use a RAC Database
  15. Use an External LDAP
  16. Configure Oracle BI Applications for High Availability
  17. Configure SSL

Install JDK

To install the recommended JDK version, refer to the Oracle BI Applications certification matrix on Oracle Technology Network.

Refer to the JDK installation document for detailed instructions.

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.

Install Oracle Fusion Middleware Infrastructure (WebLogic Server)

Oracle BI Applications requires Oracle Fusion Middleware Infrastructure 12.2.1.4.

  1. Download the Oracle Fusion Middleware Infrastructure Installer. See the Download page for Oracle Business Intelligence Applications.
  2. For Linux systems, review the general UNIX operating system requirements, and verify the locale and open file limit settings as described in Oracle® Fusion Middleware System Requirements and Specifications 12c (12.2.1.4.0). Oracle recommends a high value for ulimit. A low value of open file limit and the number of processes limit can cause installation failure. As the root user, do the following:
    1. Edit the /etc/security/limits.conf file and save the following values.

    * hard nofile 999999 * soft nofile 999999 * soft nproc 131072 * hard nproc 131072 * soft core unlimited * hard core unlimited

    The nofile values represent the open file limit; the nproc values represent the number of processes limit.

    fs.file-max = 26815744 cat /proc/sys/fs/file-max sudo vi /etc/pam.d/common-session

    Install Oracle Analytics Server

    Install Oracle Analytics Server .

    Refer to the Oracle BI Applications certification matrix in the in the Oracle Fusion Middleware Supported System Configurations page for the supported version of Oracle Analytics Server .

    For Linux: $JAVA_HOME/bin/java -jar Oracle_Analytics_Server_Linux_version-no .jar For Windows: $JAVA_HOME/bin/java -jar Oracle_Analytics_Server_Windows_version-no .jar Where Oracle_Analytics_Server_Linux_version-no is the name of the Oracle Analytics Server jar file downloaded from edelivery.

    Create Schemas Using RCU

    You must run the repository creation utility (RCU) to create schemas for Oracle Analytics Server .

    The RCU is available with the Oracle Fusion Middleware distribution files.

    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 commands.

    To create the BI schema on Oracle ATP, see Create BI Schema on Oracle ATP Database.

    To create the BI schema, perform the following steps.

    1. Start RCU using the command: $ ./ORACLE_HOME/oracle_common/bin/rcu .

    You see a sequence of dialogs. Follow the instructions provided on each of the dialogs to create the required schema.

    Caution: Don't use database SID while creating schemas; you must use only service name. Also, don't provide SID even in the connection string.

    Note: When you select Oracle Business Intelligence Platform, the RCU auto-selects other components like Common Infrastructure Services, Oracle Platform Security Services, Audit services, and Metadata Services. Don't select the ODI_REPO schema. This is created by the Oracle BI Applications RCU and is suffixed as BIA_ODI_REPO.

    When the schemas are created with no errors, you see the Completion Summary dialog.

    To create Oracle Business Intelligence schemas using the Oracle Business Intelligence RCU with a RAC database, see Creating BI Schemas Using RCU with a RAC Database.

    Install Oracle Data Integrator

    Install Oracle Data Integrator using the Oracle Data Integrator installer.

    1. Download Oracle Data Integrator 12.2.1.4 from the Download page for Oracle Business Intelligence Applications.
    2. Copy the Oracle Data Integrator 12.2.1.4 zip file to the middleware host, and unzip the file.
    3. Make sure you have set JAVA_HOME , and then run the following command to start Oracle WebLogic Server :

    $JAVA_HOME/bin/java -jar fmw_12.2.1.4.0_odi.jar

    Install Oracle BI Applications

    Install Oracle BI Applications 11.1.1.10.3 PS4 using the installer.

    You see two jar files. Ensure your keep both the jar files in the same directory. 
    [ENGINE] #DO NOT CHANGE THIS. Response File Version=1.0.0.0.0 [GENERIC] #provide oracle home location, where the product would be installed. ORACLE_HOME=/scratch/biapps/Oracle/Middleware/ORACLE_HOME
    $ java -jar obia.12c.distribution-11.1.1.10.PS4-generic.jar -silent -responseFile /tmp/biapps.resp

    Note: Ensure that the responseFile parameter value is an absolute file path and not a relative path. Use a command for the jar file which doesn’t have 2 in the filename of the responseFile .

    Create Schemas for Oracle BI Applications

    You must create and load the Oracle BI Applications schemas in the database using the Repository Creation Utility (RCU).

Perform these steps to create the BIApps schema on Oracle Autonomous Transaction Processing (ATP).
  1. Set the TNS_ADMIN environment variable to map it to the directory where the tnsnames.ora file is available.
For example, in Linux, 
export TNS_ADMIN=/scratch/wallet
Where /scratch/wallet is the ATP wallet extract folder. 
ORACLE_HOME/oracle_common/bin/rcu -compInfoXMLLocation /scratch/user/installation/Middleware/Oracle_Home/oracle_common/rcu/config/ComponentInfo_biapps_adw.xml -storageXMLLocation /scratch/user/installation/Middleware/Oracle_Home/oracle_common/rcu/config/Storage_biapps.xml
Note: The name of the component info XML file must be ComponentInfo_biapps_adw.xml.

Description of schema_adw_select_components.png follows

It might take some time to navigate to the next page.
Description of the illustration schema_adw_select_components.png

It might take some time to navigate to the next page.

Set the BIAPPS Schema User Password as Unlimited

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.

  1. Log in to the database as sys user.
  2. Create a profile with password-related attributes set to unlimited using the following SQL script:

CREATE PROFILE BIAPPS LIMIT PASSWORD_LIFE_TIME UNLIMITED PASSWORD_GRACE_TIME UNLIMITED PASSWORD_REUSE_TIME UNLIMITED PASSWORD_REUSE_MAX UNLIMITED FAILED_LOGIN_ATTEMPTS UNLIMITED PASSWORD_VERIFY_FUNCTION NULL PASSWORD_LOCK_TIME UNLIMITED;
ALTER USER PROFILE BIAPPS; For example, ALTER USER BIAPPS_DW PROFILE BIAPPS;

Upgrade OPatch

Upgrade Opatch to the latest release on the ORACLE_HOME location where you installed Oracle Fusion Middleware Infrastructure .

  1. Download the latest patches from the same location where you downloaded the Oracle BI Applications software, save the latest patches to a location, and unzip them.
  2. Set ORACLE_HOME as the parent of product home.

For example, setenv ORACLE_HOME /scratch/biapps/Middleware/ ORACLE_HOME PATH

For example, java -jar path_to_opatch_generic.jar /opatch_generic.jar -silent oracle_home= ORACLE_HOME PATH

Apply Mandatory Patches

After the software-only install, you must apply patches on the ORACLE_HOME location where you installed Oracle Fusion Middleware Infrastructure 12.2.1.4.

All patches are available in the same place from where you downloaded the Oracle BI Applications software.

  1. Copy the patches to a location, unzip them, and apply them using the instructions in the patch README file.
  2. Set ORACLE_HOME as the parent of product home.

For example, setenv ORACLE_HOME/scratch/biapps/Middleware/ ORACLE_HOME Don't set it as /scratch/biapps/Middleware/Oracle_home/odi .

Configure Oracle Analytics Server

Use Configuration Assistant to configure Oracle Analytics Server .

Oracle recommends to follow About Oracle Analytics Server Installation.

In Windows, make sure that the machine name doesn't include an underscore character (_). If you edit the machine name to remove the underscore character, reboot the machine before you run Configuration Assistant.

  1. Read and follow the step-by-step instructions in Configure Oracle Analytics Server Domain Using Configuration Assistant.

Note: In Windows, when you configure the Oracle Analytics Server domain, provide the ATP connect string in the format below. Use "\\" as the path separater.

CONNECT_STRING=midtier_biplatform?TNS_ADMIN=ATP_WALLET_HOME>

For example, CONNECT_STRING=biaoas2023_tp?TNS_ADMIN=C:\\biapps\\instantclient_19_14\\network\\admin\\atp_wallet

  1. cd DOMAIN_HOME/bitools/bin
  2. ./status.sh

After you configure Oracle Analytics Server , run the datamodel.sh (linux) or datamodel.cmd (Windows) command.

  1. Change the directory to DOMAN_HOME/bitools/bin .
  2. Run the following command:
./datamodel.sh listconnectionpool -SI Service Instance> -U WebLogic User> -S Host Name> -N BI Server Port> -V true
For example: ./datamodel.sh listconnectionpool -SI < biainstance >-U -S -N -V true Output example: 
Post listconnectionpool REST with url: http://localhost:8003/bi-lcm/v1/si/biainstance/rpd/listconnectionpool < "Title":"List Connection Pools", "Conn-Pool-Info":[ < "uid":"c0000000-c929-1508-ac27-0ae4a1690000", "connPool":"DUMMY_CP", "parentName":"\"DUMMY\"", "user":"admin1", "password":"706F87F7847C7A8EFED6E3F0AB261ADE 7C2E35213306F12832914CBE7A9DD95561D771DED06484112B1FC6F27B6D0D58", "dataSource":"testDb", "appServerName":"AppServer1", "externalizedConnection":"" >], "Variables-In-Conn-Pool":[ ] >

Edit Your Input File

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.

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.

Ensure that you edit the input.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. For Windows, use the file path separator as \\ or / . For example, biprov.oracle_home.dir=c:\\Oracle\\Middleware\\Oracle_Home or biprov.oracle_home.dir=c:/Oracle/Middleware/Oracle_Home. All the paths in input.txt should use the same format.

biprov.jdk_home.dir
biprov.oracle_home.dir
biprov.db.schema.prefix
biprov.odi.db.schema.prefix
biprov.fa.admin.user
biprov.fa.admin.pwd
biprov.odi.port
biprov.odi.ssl.port
biprov.odi.is.ssl.configured
biprov.odi.user.name
biprov.odi.console.user.pwd
biprov.odi.cluster.name
biprov.isRac
[DW_DATABASE]
DW_DATABASE_CONNECTION_STRING
DW_DATABASE_SCHEMA_USER_NAME
DW_DATABASE_SCHEMA_PASSWORD
DW_DATABASE_TYPE
biprov.ldap.external.user
biprov.ldap.pwd
biprov.ldap.external.url
biprov.ldap.external.user_prefix
biprov.ldap.external.group_prefix
biprov.adw.env

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].

For Oracle Autonomous Transaction Processing (ATP), add the database connection string in the following format:

For example in Windows, ODI_REPOSITORY_DATABASE_CONNECTION_STRING=biaatp_tp?TNS_ADMIN=C:\\biapps\\instantclient_19_14\\network\\admin\\atp_wallet

For example in Linux, ODI_REPOSITORY_DATABASE_CONNECTION_STRING=biaatp_tp?TNS_ADMIN=/scratch/instantclient_19_14/network/admin/atp_wallet

Use the same format for all the applicable schemas that you've created on ATP.

Configure Oracle BI Applications

Use Java archive obia.config.jar to configure Oracle BI Applications .

If you want to configure Oracle BI Applications on Oracle Autonomous Data Warehouse, see Configure Oracle BI Applications with Oracle Autonomous Data Warehouse.

In Windows, to run the Java archive (obia.config.jar), launch the command prompt in Administrators Mode.

  1. Edit the input.txt file.
  2. After the input.txt file is ready, in the $ORACLE_HOME/bi/biapps/scripts directory, run the following command:
java –jar obia.config.jar /input.txt

Configure Oracle BI Applications with Oracle Autonomous Data Warehouse

Connect Oracle BI Applications to 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.

Update $ORACLE_HOME/bi/biapps/scripts/input.txt, along with the [GENERIC] and [DATABASE] sections, and update these parameters:

biprov.adw.env=If new configuration run with ADW, then TRUE Else FALSE> biprov.wallet.location=Unzipped ADW wallet location> adw.wallet.trustStorePassword=ADW wallet password> instant.client.location=Unzipped Instant client path>adw.service.name= adw.admin.user=ADW admin user Ex: ADMIN> adw.admin.pwd=ADW admin password> adw.default.cred.user=Credential Name. Default text: BIAPPS_ADW_AUTO_CREDENTIAL.>adw.default.user.name= adw.auth.token=Generate an Authentication Token. This token is required for importing dump from Object storage> REMAP_SCHEMA=BIAPPS_DW:ADW schema name for DW Ex: BIAPPS_DW:ADW_DW> DUMP_FILE=/obia.dmp Ex: default_credential:https://Server Name/p/77Eo_TV2rtL/n/biappsdev/b/BIAPPSD_BUCKET/o/obia.dmp>

Make sure that the ADW wallet extracted folder contains all the files such as cwallet.sso, tnsnames.ora, and sqlnet.ora.

In the [DATABASE] section, update the database connection string for all schemas in the following format:

DW_DATABASE_CONNECTION_STRING=ADW service name from tnsnames.ora>? TNS_ADMIN=ADW wallet extract folder>

Autonomous data warehouse provides various services consumer groups. Oracle recommends to always use “LOW” ADW service name while configuring Oracle BI Applications .

For example, DW_DATABASE_CONNECTION_STRING=biappsd3_low?TNS_ADMIN=/scratch/wallet

Also, update the required SDS schema details.

Use the following commands to run the configuration:

In Windows, to run the Java archive (obia.config.jar), launch the command prompt in Administrators Mode.

cd $ORACLE_HOME/bi/biapps/scripts/ java -jar obia.config.jar input.txt

Load Translation Data

Load translation data into the BIACOMP schema of Oracle BI Applications .

You must complete all the steps listed in Installing and Setting Up Oracle BI Applications without any errors prior to loading the translation data.

  1. In your middleware host, navigate to /bi/nls .
  2. Copy the file rpd_translations.zip to the database host.
  3. In your database host, complete the following:
  1. Unzip the translations file rpd_translations.zip in your database host and navigate to the rpd_translations directory.
  2. Run the script:
  3. For Linux/Unix:

loadOtbiSeeddataSqlldr.sh thrice to load translations data into three tables using the following command:

sh loadOtbiSeeddataSqlldr.sh For example: 
sh loadOtbiSeeddataSqlldr.sh BIAPPS_BIACOMP welcome1 dbhost.mycomany.com:1616/DBServiceName importcrpdmsgs.ctl /u01/logs c_rpd_msgs_delim.csv /scratch/db/DB_Home
sh loadOtbiSeeddataSqlldr.sh BIAPPS_BIACOMP welcome1 dbhost.mycomany.com:1616/DBServiceName rpd_translations/importcrpdmsgsrel.ctl /u01/logs c_rpd_msgs_rel_delim.csv /scratch/db/DB_Home
 sh loadOtbiSeeddataSqlldr.sh BIAPPS_BIACOMP welcome1 dbhost.mycomany.com:1616/DBServiceName importcrpdmsgstl.ctl /u01/logs c_rpd_msgs_tl_delim.csv /scratch/db/DB_Home
/bin/sqlldr /@ data=\c_rpd_msgs_delim.csv control=\importcrpdmsgs.ctl log=c:\temp\crpdmsgs.log
/bin/sqlldr /@ data=\c_rpd_msgs_rel_delim.csv control=\importcrpdmsgsrel.ctl log=c:\temp\crpdmsgsrel.log
/bin/sqlldr /@ data=\c_rpd_msgs_tl_delim.csv control=\importcrpdmsgstl.ctl log=c:\temp\crpdmsgstl.log

Load Translation Data on Oracle Autonomous Transaction Processing (ATP)

Load translation data into the BIACOMP schema of Oracle BI Applications .

    Before you load translation data into the BIACOMP schema of Oracle BI Applications , make sure that:

sh loadOtbiSeeddataSqlldr.sh DB user name> DB password> atp_service_name> Control File> Log Directory> CSV File Location> Instant Client loc>
For example: 
rpd translation unzip path>/rpd_translations/loadOtbiSeeddataSqlldr.sh DEV_BIACOMP DB password> biaatp_tp rpd translation unzip path>/rpd_translations/importcrpdmsgs.ctl /u01/biapps/log_msgs rpd translation unzip path>/rpd_translations/c_rpd_msgs_delim.csv /u01/biapps/instantclient_21_4
rpd translation unzip path>/rpd_translations/loadOtbiSeeddataSqlldr.sh DEV_BIACOMP DB password> biaatp_tp rpd translation unzip path>/rpd_translations/importcrpdmsgsrel.ctl /u01/biapps/log_msgs_rel rpd translation unzip path>/rpd_translations/c_rpd_msgs_rel_delim.csv /u01/biapps/instantclient_21_4 
rpd translation unzip path>/rpd_translations/loadOtbiSeeddataSqlldr.sh DEV_BIACOMP DB password> biaatp_tp rpd translation unzip path>/rpd_translations/importcrpdmsgstl.ctl /u01/biapps/log_msgs_tl rpd translation unzip path>/rpd_translations/c_rpd_msgs_tl_delim.csv /u01/biapps/instantclient_21_4
DB_OH>/bin/sqlldr BIACOMP USER>/BIACOMP password>@atp_service_name> data=path of file>\c_rpd_msgs_delim.csv control=path of ctl>\importcrpdmsgs.ctl log=c:\temp\crpdmsgs.log 
DB_OH>/bin/sqlldr BIACOMP USER>/BIACOMP password>@atp_service_name> data=path of file>\c_rpd_msgs_rel_delim.csv control=path of ctl>\importcrpdmsgsrel.ctl log=c:\temp\crpdmsgsrel.log 
DB_OH>/bin/sqlldr BIACOMP USER>/BIACOMP password>@atp_service_name> data=path of file>\c_rpd_msgs_rel_delim.csv control=path of ctl>\importcrpdmsgsrel.ctl log=c:\temp\crpdmsgstl.log

Configure Oracle Data Integrator Studio

Use Oracle Data Integrator Studio (ODI Studio) 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.

Configuring Authentication

Use these instructions to configure authentication.

  1. If you're using embedded LDAP, then go to 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.
  2. Copy cwallet.sso and jps-config.jse.xml to ORACLE_HOME/odi/studio/bin .
  3. Copy DOMAIN_HOME/config/fmwconfig/System-jazn-data.xml to the ORACLE_HOME/odi/studio/bin directory.
Setting the JPS Config File Location

Use these instructions to set the location of the JPS Config file.

  1. Navigate to the ORACLE_HOME/odi/studio/bin directory.
  2. Open the odi.conf file in an editor.
  3. At the bottom of the file, add the following:

AddVMOption -Doracle.security.jps.config=./jps-config-jse.xml AddVMOption -Dexclude.technology.refresh.seeded.objects=true
Starting Oracle Data Integrator Studio

Use these instructions to start ODI Studio.

  1. Navigate to the ORACLE_HOME/odi/studio directory.
  2. Enter the command for Linux ./odi.sh -clean -initialize .
Connecting to the Master Repository

Use these instructions to create an ODI Repository Login and connect to the master repository using the newly created login in Oracle Data Integrator .

  1. Sign in to ODI Studio, from the menu, select File , then select New .
  2. In the New Gallery dialog, select ODI under Categories in the left pane, select Create a New ODI Repository Login under Items in the right pane, and then click OK .
  3. In the Repository Connection Information dialog, provide the following details:

Description of repository_connection_info.png follows

  1. In the Oracle Data Integrator Connection section, enter:
  2. In the Database Connection (Master Repository) section, enter:
  3. In the Work Repository section, select Master Repository Only .

Description of the illustration repository_connection_info.png

After you have successfully created a new login, you are returned to ODI Studio. After you provide your wallet password, you see the Oracle Data Integrator Login dialog.
  1. Select the name of the new login that you created from the list of values.
  2. Specify a user who has supervisor privileges.
  3. Provide the password for the user who has supervisor privileges.
After successfully signing into ODI, you see the ready-to-use ODI repository artifacts.
Regenerating the Security Files

Administrator must regenerate the security files and redistribute the files to all instances of ODI Studio if there’s a change in the password of Oracle BI Applications administrator or any Oracle Data Integrator user.

    Execute the wlst.sh script.

ORACLE_HOME/oracle_common/common/bin/wlst.sh ORACLE_HOME/bi/biapps/scripts/createJPSArtifactsODI.py embedded --ADMIN_USER_NAME WebLogic Server Admin User> --DOMAIN_HOSTNAME Hostname> --DOMAIN_PORT WebLogic Port> --DOMAIN_HOME_PATH DOMAIN_HOME

The updated JPS configuration file and credential wallet are created in the DOMAIN_HOME/odi-client-config/embedded directory.

The odi.conf file is located in the ORACLE_HOME/odi/studio/bin directory. See Setting the JPS Config File Location.

Use a RAC Database

If you're planning to use a real application cluster (RAC) database to configure Oracle BI Applications , then follow these additional steps.

The configuration flow is largely the same whether you're using a non-RAC database or a RAC database. The instructions to install Oracle Fusion Middleware Infrastructure , Oracle Business Intelligence , creating Oracle Business Intelligence schemas, installing Oracle Data Integrator , and installing Oracle BI Applications are the same whether you're using a non-RAC database or a RAC database. For creating schemas using the Oracle Business Intelligence RCU when you've a RAC database, see Creating BI Schemas Using RCU with a RAC Database.

Oracle recommends that you use the SCAN URL for the RAC database. You can directly use the SCAN URL in the configuration.

  1. While editing the input file:
  1. Keep the value of biprov.isRAC parameter as False .
  2. Provide the SCAN URL for all the database schemas in the input file.
  3. Keep DATABASE_TYPE as Oracle Database .

Use an External LDAP

Instead of using Oracle Weblogic’s embedded LDAP, you can use Oracle Internet Directory as an external LDAP for users.

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.

Configure Oracle BI Applications for High Availability

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.

  1. Install and configure Oracle BI Applications on Node1. Ensure all components are up and running.
  2. Install Oracle BI Applications on Node2. Perform software only installation including prerequisite patches and don't run config.
  3. Configure high availability for Oracle Analytics Server .
  4. Configure high availability for Oracle Data Integrator .
  5. Configure DSN for high availability on Windows.
  6. Perform post-configure steps for high availability.
  7. Configue Oracle HTTP Server (OHS) for high availability.

You can perform steps 3 and 4 either manually or by using automated scripts.

Machine or host name longer than 32 characters isn't supported. Specify a shorter name.

  1. Set up shared files and directories. For data sharing, you need a common mount point where both host can read/write (this isn't ORACLE_HOME). See Set Up Shared Files and Directories.
  2. Node1 and Node2 hosts are reachable from each other. You must be able to ping the hosts from one another.
    1. The /etc/hosts file on each host must have entry of the other host.
    2. The IP address obtained with a ping command and the IP entry in the /etc/hosts file must be the same.
    Configure High Availability with Automated Scripts

    Use these steps to configure high availability with automated scripts.

      Update your input.txt file available at /bi/biapps/scripts/input.txt with these sample parameters:

    /bi/biapps/scripts/configure_HA_primary.sh . /bi/biapps/scripts/configure_HA_secondary.sh . /bi/biapps/scripts/configure_HA_primary_ODI.sh .
    Configuring High Availability with Manual Steps

    Use these steps to configure high availability manually.

    1. Install and configure Oracle BI Applications on Node1. Ensure all components are up and running.
    2. Install Oracle BI Applications on Node2. Don't run config. You must perform the software-only install.

    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).

    1. On Node 1, complete the following steps to change the Singleton Data Directory (SDD). See Change the Singleton Data Directory (SDD).
    Note: Be sure install and config is completed in node1, and node1 is up and running.
    1. Export the $ORACLE_HOME and $DOMAIN_HOME environment variables. For example, export ORACLE_HOME=/u01/Middleware/Oracle_Home and export DOMAIN_HOME=/u01/user_projects/domains/biadomain .
    2. Open a shell session in node 1 and stop all components using the stop.sh command.
    3. Navigate to the $DOMAIN_HOME/config/fmwconfig/bienv/core directory.
    4. Make a backup of the bi-environment.xml file and edit it to change the Singleton Data Directory (SDD). Ensure that the new SDD points to a shared directory that can be accessed by both nodes of the cluster. Your mount point or share must persist through reboots;. For example, /shared_mount/nfs_shared/bidata .
    5. Copy the bidata directory to the new SDD location. For example,
    cd cp -R bidata /shared_mount/nfs_shared/bidata
    1. Sign in to Oracle Enterprise Manager Fusion Middleware Control .
    2. Click Target Navigation , expand Business Intelligence , select biinstance , click the Configuration tab, and then the Performance subtab.
    3. Click Lock & Edit available under Lock icon and provide the global cache path and size.
    4. Click Apply button and then Activate Changes available under the Lock icon.
    Note: Oracle BI Applications is installed on Node2 but config isn't yet executed.
    1. Create the domain directory, as it exists in the node. Use the same directory and naming structure such as mkdir -p /u01/user_projects/domains/biadomain . Ensure that the DOMAIN_HOME in both nodes specifies the same path name.
    2. Export the $ORACLE_HOME and $DOMAIN_HOME environment variables.
    3. Unpack the domain by using the template jar that you created using the command: ORACLE_HOME/oracle_common/common/bin/unpack.sh -template=[location of copied jar file from primary computer] –domain=DOMAIN_HOME -nodemanager_type=PerDomainNodeManager For example:
    Oracle_Home/oracle_common/common/bin/unpack.sh -template=/refresh/home/oracle/nfs_shared/clone/demobi2.jar -domain=/../../Oracle_Home/user_projects/domains/bi -nodemanager_type=PerDomainNodeManager
    1. Start the components AdminServer, bi_server1, ODI_server1, obis1, obips1, obiccs1, obijh1, obisch1, and bi_server2 using the $DOMAIN_HOME/bitools/bin/start.sh -i "AdminServer,bi_server1,ODI_server1,obis1,obips1,obiccs1,obijh1,obisch1,bi_server2" command.
    2. Start the components obis2, obips2, obiccs2, obijh2, and obisch2 using the $DOMAIN_HOME/bitools/bin/start.sh -i "obis2,obips2,obiccs2,obijh2,obisch2" command.
    3. Re-synchronize the data source on the new computer. On the new computer, run the following script: DOMAIN_HOME/bitools/bin/sync_midtier_db.sh
    4. On the primary computer, start the new system components for the new computer: Change directory to DOMAIN_HOME/bitools/bin/ . Enter: ./start.sh -i obis2,obips2,obiccs2,obijh2,obisch2 If you're configuring high availability in Windows, then you must create and configure DSN. Refer to the DSN Creation section to complete those steps and then continue to configuring ODI for high availability.
    Configuring High Availability for ODI

    Use these steps to configure high availability for ODI.

      On Node 1 complete the following steps:

    1. Create ODI_server2 and assign it to the machine and cluster using these wlst commands:
    $ORACLE_HOME/oracle_common/common/bin/wlst.sh connect('', '', ':') edit() startEdit() cd('/') cmo.createServer("ODI_server2") cd('/Servers/' + "ODI_server2") cmo.setListenAddress() cmo.setListenPort() activate()
    Bring down all components by executing stop.sh and then connect to wlst in offline mode using: 
    $ORACLE_HOME/oracle_common/common/bin/wlst.sh readDomain() assign('Server', 'ODI_server2', 'Machine', ) assign('Server', 'ODI_server2', 'Cluster', ) cd('/Server/ODI_server2') set('ListenPort', int("")) updateDomain() closeDomain()
    Configuring Oracle HTTP Server for High Availability

    Use these steps to configure Oracle HTTP server (OHS) for high availability.

    Install and configure the latest available supported version of Oracle HTTP Server on a separate machine. After installing and configuring OHS, configure the Oracle BI Applications URL in OHS.

    1. Stop OHS using the command:
    cd /u02/installation/OHS/Oracle_Home/user_projects/domains/ohs_domain/bin ./stopComponent.sh ohs1 Add this content to the mod-wl_ohs.conf file: 
    #odi agent WebLogicCluster :,: SetHandler weblogic-handler # ODI Console WebLogicCluster :,: SetHandler weblogic-handler # analytics WebLogicCluster :,: SetHandler weblogic-handler # biacm WebLogicCluster :,: SetHandler weblogic-handler #bi-security-login WebLogicCluster :,: SetHandler weblogic-handler
    cd /u02/installation/OHS/Oracle_Home/user_projects/domains/ohs_domain/bin ./startComponent.sh ohs1
    Performing Post-Configure Steps for High Availability

    Perform these steps after configuring Oracle BI Applications for high availability.

      Log in to the Admin console in node1 and perform the following steps:

    1. Navigate to Environment and then Servers .
    2. Click Admin Server and then click the General tab.
    3. Click Lock & Edit .
    4. Update Listen Address field with the admin server host.
    5. If default port is other than the default listen port, then update the Listen Port field with the appropriate port number.
    6. Click Save and then click Activate Change .
    1. /biapps/logs/etl
    2. /biapps/logs/healthcheck/log
    3. /biapps/logs/process
    4. /biapps/shared/healthcheck/report
    1. Log into ODI Studio. Navigate to Topology Manager, click Technology , and then click File .
    2. Expand the BIAPPS_DW_FILE data server and double-click to open the physical schema.
    3. In the Definition pane, for the Directory (Schema) and Directory (Work Schema) properties, specify the shared location where you copied the source files. Update the shared location in ODI Studio for the following by clicking Topology , then Technologies , and then File for:
      • BIAPPS_DW_FILE
      • BIAPPS_DW_LOG_FILE
      • BIAPPS_DW_SHARED_FILE
      • EXT_STORAGE_FUSION_11_0__215
      • BIAPPS_DW_FILE - Copy all the files/folders from ORACLE_HOME/bi/biapps/etl/data_files/src_files/BIA_11 to SHARED_LOCATION/BIA_11.
      • BIAPPS_DW_LOG_FILE - Copy all the files/folders from DOMAIN_HOME/biapps/logs to SHARED_LOCATION/logs.
      • BIAPPS_DW_SHARED_FILE - Copy all the files/folders from DOMAIN_HOME/biapps/shared to SHARED_LOCATION/shared.
      • EXT_STORAGE_FUSION_11_0_215 - Source registration may happen in any of the physical nodes. Hence, you must look into DOMAIN_HOME of node1 and node2 to locate the folders mentioned in the following instructions: Copy all the files/folders from DOMAIN_HOME/biapps/shared/215/ReplStg to SHARED_LOCATION/shared/215/ReplStg. Copy all the files/folders from DOMAIN_HOME/biapps/shared/215/download to SHARED_LOCATION/shared/215/download. Copy all the files/folders from DOMAIN_HOME/biapps/shared/215/srcFiles to SHARED_LOCATION/shared/215/srcFiles. Copy all the files/folders from DOMAIN_HOME/biapps/shared/215/upload to SHARED_LOCATION/shared/215/upload.
    Creating BI Schemas Using RCU with a RAC Database

    Follow these steps for a successful configuration while creating Oracle Analytics Server schemas with the Repository Creation Utility (RCU) with a RAC database.

      Install Oracle Fusion Middleware Infrastructure and Oracle Analytics Server as described in Install Oracle Fusion Middleware Infrastructure (WebLogic Server) and Install Oracle Analytics Server.

    Don't run Oracle Data Integrator and Oracle BI Applications yet. You see all the schemas with data created in the database.

    Configure SSL

    You can configure Oracle BI Applications with SSL for secured connections.

    See My Oracle Support note Doc ID 2943320.1 for instructions and details.

    Uninstalling Oracle BI Applications

    Use the following steps to uninstall Oracle BI Applications .

    1. Stop all running Oracle WebLogic services using this command: $DOMAIN_HOME/bitools/bin/stop.sh .
    2. Drop all schemas by following these steps:

    1. Run the RCU by entering ./ORACLE_HOME/oracle_common/bin/rcu .
    2. Select Drop Schema for each schema to drop and exit.
    3. Invoke RCU again using the command:
    ORACLE_HOME/oracle_common/bin/rcu –compInfoXMLLocation ORACLE_HOME/oracle_common/rcu/config/ComponentInfo_biapps.xml –storageXMLLocation ORACLE_HOME/oracle_common/rcu/config/Storage_biapps.xml

    Ensure that you drop the schemas using the RCU; don't use any other SQL command.

    For example, if your Domain home directory is /u01/biapps/Middleware/user_projects , then use the command

    cd /u01/biapps/Middleware rm -rf user_projects

    If there is another user_project directory within Oracle_home like /u01/biapps/Middleware/Oracle_Home/user_projects , then delete that using the following command:

    cd /u01/biapps/Middleware/Oracle_Home rm -rf user_projects