This section consists of the following topics:
The following prerequisites must be met before installing Oracle Business Intelligence on the Exalytics Machine:
The Oracle Exalytics Release 2.2 version of the Oracle Exalytics Base Image (2.0.0.2.el6) is running on the Exalytics Machine or later.
The Exalytics Machine has been racked and mounted in a data center.
The Exalytics Machine is configured with the base operating system at the factory.
If you need assistance, then Oracle provides Advanced Customer Services for installing software on the Exalytics Machine.
Network configuration is complete and the computer is accessible from the network.
A supported database is available and accessible from the Exalytics Machine to host the schemas that are required by the software installation and that you create as part of the installation process. Ensure that the database is running during the installation and that the database is not hardened for security purposes. Installing Oracle Business Intelligence against a hardened database is not supported.
For information about hardened databases, see Oracle Database Vault Administrator's Guide.
You have access to the internet from a computer (not necessarily the Exalytics Machine) to download required packages.
Parent topic: Installing Software on Exalytics Machine
Before you install software on the Exalytics Machine, you must run configuration scripts to verify the software and network configurations of the Exalytics Machine.
This section consists of the following topics:
Parent topic: Installing Software on Exalytics Machine
You run the exalytics_CheckSWProfile
script to verify the current Exalytics software and storage configurations.
To verify Exalytics software and storage configurations:
Parent topic: Verifying Configuration of the Exalytics Machine
To verify the Exalytics image information:
Log on the Exalytics Machine as a root user.
Navigate to the /opt/exalytics/bin directory.
Enter the following command:
./exalytics_imageinfo
Verify that the output displayed is similar to the following:
Image version : 2.0.0.2_el6
Creation timestamp : Wed-10-Jan-2018 04:53:35 PM EST
Kernel version: 4.1.12-94.5.9.el6uek.x86_64
RPM versions:
kernel-uek-4.1.12-124.17.2.el6uek.x86_64
exalytics-container-bm-2.0.0.2-2_el6.x86_64
exalytics-scripts-2.0.0.2-13_el6.noarch
exalytics-flash-2.0.0.2-6_el6.x86_64
exalytics-domain-configure-2.0.0.2-4_el6.noarch
exalytics-deps-exact-2.0.0.2-2_el6.x86_64
exalytics-deps-minimum-2.0.0.2-2_el6.x86_64
Note:
Even though the build numbers may be different than the ones listed above, ensure that the updated kernel version is the same as the one displayed above.
Parent topic: Verifying Configuration of the Exalytics Machine
Installing software on the Exalytics Machine involves a combination of manual steps and automated scripts. The manual steps are to install Oracle WebLogic Server and Oracle BI EE while the installation script provides an automated way of installing Oracle TimesTen In-Memory Database and configuring communication with Oracle BI EE (a Software-Only Installation).
Note:
For information on installing Oracle Business Intelligence 11.1.1.6.x, see , Exalytics X2-4 Release 1 (1.0).
The steps in the process are:
Parent topic: Installing Software on Exalytics Machine
On the operating system, create a user with a name such as "oracle" and an appropriate password and a group with a name such as "oinstall". The following are sample commands for creating this user and group:
groupadd oinstall useradd -g oinstall oracle
The procedures throughout this section assume a user named "oracle" and a group named "oinstall".
Parent topic: Installing the Software
Create the inventory for Oracle TimesTen after you log in as the root user by entering the following commands:
mkdir /etc/TimesTen chmod 770 /etc/TimesTen chgrp oinstall /etc/TimesTen touch /etc/TimesTen/instance_info chmod 770 /etc/TimesTen/instance_info chgrp oinstall /etc/TimesTen/instance_info
Ensure that the group who runs the script has write access to the /etc/TimesTen directory.
Parent topic: Installing the Software
To set the resource limits for Oracle TimesTen:
Parent topic: Installing the Software
Confirm if a /u01 partition exists on the hard disk.
If a /u01 partition exists, you can ignore this section.
If a /uo1 partition does not exists on the hard disk, then create and mount a /u01 partition on the machine by performing the following tasks:
Note:
Create the partition equal to the maximum space available on the disk partition.
To create and mount a /u01 partition:
After logging in as the root user, configure the /u01 directory on the hard disk using commands such as the following ones:
Depending on the configuration of the Exalytics Machine, perform one of the following actions:
To create a partition on an X2-4 Exalytics Machine, enter the following commands:
# parted /dev/sdb
(parted) mklabel msdos
(parted) mkpart
Primary/extended? Primary
File system type? [ext2]? ext4
Start? 0
End? 1797GB
(parted) quit
To create a partition on an X3-4 Exalytics Machine, enter the following commands:
# parted /dev/sdb
(parted) mklabel msdos
(parted) mkpart
Primary/extended? Primary
File system type? [ext2]? ext4
Start? 0
End? 2697GB
(parted) quit
To create logical volume, enter the following commands:
lvm pvcreate /dev/sdb1
lvm vgcreate VolGroup01 /dev/sdb1
lvcreate --name LogVol00 --size 2400G VolGroup01
To create a file system, enter the following command:
mkfs.ext4 /dev/VolGroup01/LogVol00
Add the following line to the /etc/fstab file:
/dev/VolGroup01/LogVol00/u01 ext4 defaults 0 0
To create and mount a /u01 directory, enter the following commands:
# mkdir -p /u01
mount -a
Restart the computer.
Verify that the partition has been created by entering the following command:
df –lh
Note:
Check permissions for the "oracle" user. If you cannot write to the /u01 directory, then enter the following commands to change permissions:
chown oracle:oinstall /u01
chmod 775 /u01
Parent topic: Installing the Software
Before installing the software, you must download the required files into an organized directory structure. Note that the directory structures detailed in Step 3 below and Staging the Middleware Home are not mandatory, but is just an example. You can choose any structure to organize the files.
Note:
You must reference the same chosen directory structure in the properties files when editing the install script.
To download files into the directory structure:
Parent topic: Installing the Software
Create a directory structure such as the following for staging the Middleware Home:
/u01/app/oracle/product/fmw
The installation scripts use this directory as the target directory for the Oracle BI EE installation, which is known as the Middleware Home. In this guide, this directory is referred to as EXALYTICS_MWHOME.
Parent topic: Installing the Software
Follow the instructions in the "Create Database Schemas Using the Repository Creation Utility (RCU)" section in Installing and Configuring Oracle Business Intelligence.
You must first create required Oracle Business Intelligence schemas in a database (note that the database must not be hardened). You use a tool called the Repository Creation Utility (RCU) to create these schemas with the appropriate permissions and data.
Before you begin using RCU, review the "Repository Creation Utility (RCU) Requirements" section in the Oracle Fusion Middleware System Requirements document:
http://docs.oracle.com/html/E18558_01/fusion_requirements.htm
This section contains important information about your system and component-specific database requirements that should be met before you run RCU.
Ensure that you record the following details, because you use them later in the installation process:
The database connection details in the following form:
host-name:port-number:service-name
The names and passwords of the schemas that you create, which have names such as prefix_BIPLATFORM and prefix_MDS.
Parent topic: Installing the Software
If not already installed, install Oracle WebLogic Server.
To install Oracle WebLogic Server
For more information on installing Oracle WebLogic Server, including custom installations, see Installing and Configuring Oracle WebLogic Server and Coherence.
Parent topic: Installing the Software
The Software Only Install type enables you to install Oracle Business Intelligence software binary files in an Oracle home for later configuration.
To perform a Software Only Install:
For more information, see "Software Only Install" in Installing and Configuring Oracle Business Intelligence.
Parent topic: Installing the Software
After completing the Software Only Install, you must create an Oracle BI EE instance using the Configuration Assistant.
To create a new Oracle BI EE instance:
Parent topic: Installing the Software
Edit carefully the properties file that contains values that the installation scripts use. The file is named bim-setup.properties and is stored in the following directory:
/EXALYTICS_MWHOME/Oracle_BI1/bifoundation/exalytics/properties
Keep the following points in mind as you edit the file:
Ensure that you use proper spelling and capitalization in the lines of the file.
The file contains comments that provide details on how to edit the values to be appropriate for your system.
The following is the contents of the properties file:
######################################################### # BI Machine Properties ######################################################### ######################################################### [Generic properties to be used across all the Oracle Products] # [Generic properties to be used across all the Oracle Products] #bim.tt.installer.root=The directory location where the timesten installer zips are present #bim.tt.install.dir=The directory location where the timesten needs to be installed #bim.tt.daemon.port=The daemon port for timesten,if value is not provided default value of port is used as 53396. For multiple install of timesten this property is mandatory. The port number specified should be a number between 1024 and 65527. #bim.tt.server.port=The server port used to configure timesten,if value is not provided default value of port is used as 53397. For multiple install of timesten this property is mandatory. The port number specified should be a number between 1024 and 65527. #bim.tt.instance.name=The instance name for timesten,if value is not provided default value used is tt1122. For multiple install of timesten this property is mandatory. ######################################################### bim.tt.installer.root=/home/oracle/EXALYTICS_INSTALLERS/tt bim.tt.install.dir=/u01/TT1 bim.tt.daemon.port=53396 bim.tt.server.port=53397 bim.tt.instance.name=tt1122 ######################################################### [BI specific properties] #bim.bi.host=The host name where BI is installed. #bim.mw.home=This directory location BI Middleware home #bim.bi.admin.user=The admin username of BI #bim.bi.wls.admin.port=The port where AdminServer is running of BI ######################################################### bim.bi.host=<hostname> bim.mw.home=/u01/INSTANCE1 bim.bi.admin.user=biadmin bim.bi.wls.admin.port=7001
Parent topic: Installing the Software
Before running the installation script, ensure that you verify the items in the following checklist:
TimesTen install file is present.
You carefully edited the properties file for the script and ensured that it contains no errors.
Parent topic: Installing the Software
To run the installation script:
The installation script for Oracle Exalytics performs the following tasks:
Prompts you to enter the Oracle BI Administration password when it runs.
Enables the HardwareAcceleration MBean attribute.
If you must modify the attribute, then you can update it as described in Manually Setting the HardwareAcceleration MBean Attribute.
Installs Oracle TimesTen.
Makes configuration changes in the opmn.xml file to point to the Oracle TimesTen libraries.
Configures the sys.odbc.ini file for Oracle TimesTen and the odbc.ini file for Oracle Business Intelligence with DSN details for Oracle TimesTen.
Parent topic: Installing the Software
To verify that the installation is successful, you open a web browser and attempt to display the following URLs. If you can display and interact with the pages at the following URLs, then the installation succeeded.
Oracle BI Enterprise Edition:
http://server-name:9704/analytics
Oracle WebLogic Server Console:
http://server-name:7001/console
Fusion Middleware Control:
http://server-name:7001/em
Parent topic: Installing the Software
This section provides the following information on troubleshooting:
Parent topic: Installing Software on Exalytics Machine
If you have any issues installing software on the Exalytics Machine, check the following items:
Ensure that the database in which you ran the Repository Creation Utility to create the schemas is running.
Check the networking configuration of the machine including the /etc/hosts file.
Check the contents of the bim-setup.properties file to ensure that all entries are accurate with no misspellings.
If the installation scripts fail, then perform the following steps:
Deinstall the Oracle TimesTen software.
Verify the contents of the bim-setup.properties file, as described in Editing the Properties File.
Restart the installation process.
After installing the software, you can check the log files for Oracle WebLogic Server, Oracle Business Intelligence, and Oracle TimesTen in the MW_HOME/Oracle_BI1/bifoundation/exalytics/logs directories. The files have names such as tt_install.log for Oracle TimesTen.
You might want to reinstall the software. The installer does not allow reinstallation of Oracle Business Intelligence in a directory that contains another Oracle Business Intelligence installation on an Exalytics Machine.
To reinstall Oracle Business Intelligence in the same directory as before:
The HardwareAcceleration MBean attribute specifies whether you are using the Exalytics Machine, as described in the following procedure. This MBean attribute is turned on automatically when you run the script to install Oracle Business Intelligence on the Exalytics Machine. The MBean attribute sets the ORACLEHARDWAREACCELERATION parameter in the NQSConfig.ini file and the OracleHardwareAcceleration element in the instanceconfig.ini file.
To specify the use of the Exalytics Machine using the System MBean Browser:
In Fusion Middleware Control, in the Navigator window, expand the WebLogic Domain folder and the bifoundation_domain node.
Right-click the AdminServer node and select System MBean Browser.
Expand Application Defined MBeans, then expand oracle.biee.admin, then expand Domain: bifoundation_domain.
Lock the domain, as follows:
Expand BIDomain and select the BIDomain MBean where group=Service.
Display the Operations tab.
Click the lock link.
Display the Attributes tab for the same MBean.
Ensure that the HardwareAcceleration attribute is set to true.
After applying your changes, release the lock on the domain by displaying the Operations tab and clicking one of the commit operations.
Restart Oracle Business Intelligence.
Each Oracle Exalytics Machine is configured with 4 CPUs, each CPU containing 10 active core processors. This configuration provides 40 active core processors. Of these, 20% are reserved for on-demand use when additional computing processing is needed. For example, you use 32 cores most of the time and enable the other 8 cores only when needed, such as to run reports and queries at quarter end. You can then continue using 80% of the active core processors until the next quarter end.
Note:
When you change the number of active core processors, you do not have to restart the Exalytics Machine.
You use the exalytics_resourceControl.sh utility to configure the Oracle Exalytics operating system to change capacity on demand. Table A-1 shows the parameters for the capacity_on_demand command. The command is part of the exalytics_resourceControl.sh utility.
Table A-1 Parameters for the capacity_on_demand Command in the exalytics_resourceControl.sh Utility
Parameter | Description |
---|---|
Display |
Displays number of active core processors currently in use. |
Disable |
Disables core processors that are reserved for additional on-demand processing. |
Enable |
Enables core processors that are reserved for additional on-demand processing. |
Update |
Enables any number of core processors. Can only be used in force mode. |
If you do not specify any parameters, the utility displays all capacity on demand arguments. For example, if you navigate to the /opt/exalytics/bin directory, and enter the following command:
./exalytics_resourceControl.sh
The following output is displayed:
Usage: ./exalytics_resourceControl.sh [-show | -capacity_on_demand args] -show: Displays the number of logical cores active -capacity_on_demand [display|disable|enable|update -cores <noOfCoresPerSocket>] [-force] display: displays the number of cores in use. disable: disables the cores reserved for additional on-demand capacity. enable: enables the cores reserved for additional on-demand capacity. update -cores <numCoresPerSocket> -force: can be used in force mode, to enable any number (min 2) of cores on a socket.
To configure the Exalytics operating system to change capacity on demand:
Note:
After running the utility, you can check the log and the trace files in the /var/log/oracleexa/systemconfig.log file and the /var/log/oracleexa/resctl directory respectively.