Everything Oracle | Home | Everything Oracle |
Oracle | Exalytics | Installation | |||||
Single-Node Oracle Exalytics Installation |
Introduction |
This article describes the installation of Oracle Exalytics on a single-node machine (installation on a cluster – to support high availability, for example – requires additional steps). The Exalytics machine comes with a customized version of Oracle Enterprise Linux preinstalled. While there are many installation tasks, the installation process is partially scripted. The installation script:
Installs the Oracle WebLogic Server
Performs a Software-Only installation of Oracle Business Intelligence
Creates a BI Domain
Installs Oracle TimesTen
Configures the installed software
The configuration steps:
Enable the HardwareAcceleration MBean attribute (needed to use OBI with Exalytics hardware acceleration)
Points file “opmn.xml” to the Oracle TimesTen libraries
Configures file “sys.odbc.ini” for Oracle TimesTen
Configures file “odbc.ini” for Oracle Business Intelligence (with the TimesTen DSN)
Prerequisites |
Documentation
Review the latest release notes for any changes to the installation procedure that may impact Exalytics:
Oracle Fusion Middleware Release Notes
Oracle TimesTen In-Memory Database Release Notes
The “Software Only Install" section in the “Oracle Fusion Middleware Installation Guide for Oracle Business Intelligence” will be needed for the details of the RCU metadata database installation.
The “Oracle Exalytics In-Memory Machine Owner's Guide” may be helpful when confirming that the Exalytics hardware has been installed correctly and that network connectivity has been established.
Exalytics Installation
This Exalytics software installation assumes that Infrastructure Services have already racked and mounted the Exalytics Machine in the data centre. In particular, it assumes that they have run the network configuration script. Verify, based on the details supplied, that the Exalytics server is accessible across the network and that you have the information needed to logon as root.
Metadata Database
A database is required to hold the metadata schemas used by OBI and TimesTen. This database must:
Not be on the Oracle Exalytics server
Not be security hardened
Be accessible from the Exalytics Machine
Be up and running for the installation to proceed
Obtain the connection details (host, port, and service name) and an account with DBA privileges.
Installation Media
Unless the installation software has been made available on physical media, it will need to be downloaded from Oracle’s e-delivery site, so Internet access will be required.
Operating System Configuration |
Create Operating System User & Group
Log in as root and create an operating system user and group:
groupadd oinstall useradd -g oinstall oracle
Selecting “oracle” for the operating system user and “oinstall” for the group will minimize the amount of customized configuration required during the installation process.
Create TimesTen Inventory
Log in as root and create and permission the TimesTen Inventory file:
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
Set Resource Limits
Log in as root and modify file “/etc/security/limits.conf” to set the following generic resource limits:
* hard nofile 131072 * soft nofile 131072 * hard memlock unlimited * soft memlock unlimited * hard core unlimited * soft core unlimited * hard nproc 131072 * soft nproc 131072
Set Kernel Parameters
Modify file “/etc/sysctl.conf” to change the semaphores and shared memory kernel settings:
kernel.sem = 2048 64000 256 64 kernel.shmmax = 1099511627776 kernel.shmall = 4294967296 kernel.shmmni = 4096
Apply the changes made to the parameters:
/sbin/sysctl -p
Create, Mount, and Permission /u01
Log in as root and create a partition using GNU parted:
parted /dev/sdb (parted) mklabel msdos (parted) mkpart Primary/extended? Primary File system type? [ext2]? ext3 Start? 0 End? 1797GB (parted) quit
Format the file system:
mkfs.ext3 /dev/sdb1
Modify file “/etc/fstab” to specify the mounting characteristics:
/dev/sdb1 /u01 ext3 defaults 1 2
Create and mount “/u01”:
mkdir /u01 mount /dev/sdb1 /u01
Reboot.
Set the “oracle” user permissions for “/u01”:
chmod 775 /u01 chown oracle:oinstall /u01
Supporting Software Installation |
Download and Install Apache Ant
Download release 1.8.2 of Apache Ant. This is not the latest version of Apache Ant, but it can found in the archive.
Unzip the files to directory “/home/oracle/ANT/apache-ant-1.8.2”.
Download and Install the Java JDK
Download JDK 6 Update 29 for Linux 64-bit. Thus is not the latest version of the JDK, but it can be found in the archive.
Copy the JDK distribution installer to directory “/home/oracle/JDK”, and install the JDK with command: “./jdk-6u29-linux-x64.bin”.
Exalytics Software Staging |
Downloading Installation Media
Download from Oracle’s e-delivery web site:
Oracle BI Enterprise Edition Release 11g
Repository Creation Utility 11g
Oracle TimesTen Release 11g
Oracle WebLogic Server Release 10g
These are contained in the “Oracle Exalytics Software Media Pack for Linux x86-64” (in the “Media Pack Search” screen, select “Oracle Business Intelligence” for the “Product Pack” and “Linux x86-64” for the platform).
Stage the Software
Create the following staging directories:
/home/oracle/EXALYTICS_RCU /home/oracle/EXALYTICS_INSTALLERS/bi /home/oracle/EXALYTICS_INSTALLERS/tt /home/oracle/EXALYTICS_INSTALLERS/wls /home/oracle/EXALYTICS_INSTALL_LOG /u01/app/oracle/product/fmw” (called EXALYTICS_MWHOME) /home/oracle/EXALYTICS_INSTALL_TEMP”
Copy file “rcuHome.zip” to directory “/home/oracle/EXALYTICS_RCU”, and unzip it.
Copy the Oracle BI EE installation zip files to directory “/home/oracle/EXALYTICS_INSTALLERS/bi”. Unzip all files using “unzip -q '*.zip'”. Verify that subdirectory “bishiphome” is created with subdirectories named “Disk1” to “Disk5”.
Copy the “TimesTen for Exalytics” distribution file to directory “/home/oracle/EXALYTICS_INSTALLERS/tt”.
Extract file “wls1036_linux64.bin” from the “Oracle WebLogic Server on 64-bit Linux” zip file into directory “/home/oracle/EXALYTICS_INSTALLERS/wls”. Make it executable with “chmod +x wls1036_linux64.bin”.
Metadata Database Schema Creation |
The creation of metadata schemas to support Exalytics is no different than in the case of a standard OBI EE installation:
Select a database that meets the requirements (download the Excel spreadsheet at entry “System Requirements and Supported Platforms for Oracle Business Intelligence Suite Enterprise Edition 11gR1 (11.1.1.3.0-11.1.1.6.0)” on the Oracle Fusion Middleware Supported System Configurations web page.
Determine the host name, port number, and service name of the metadata database, and obtain a DBA account that allows you to login as SYSDBA.
Select a prefix to be used in creating the two RCU schemas (“PREFIX_BIPLATFORM” and “PREFIX_MDS”).
Create the schemas using the instructions in the Create Database Schemas Using the Repository Creation Utility (RCU) section of the “Oracle Fusion Middleware Installation Guide for Oracle Business Intelligence” document.
Record all details of hosts, ports, schema names, and passwords, as they will be required during subsequent steps.
Metadata Database Schema Creation |
Edit Installation Scripts Properties File
The behaviour of the run script is determined by the values set in a properties file – file “bim-setup.properties” in directory “/home/oracle/EXALYTICS_INSTALLERS/bi/bishiphome/Disk1/bimachine/scripts”:
######################################################### # Exalytics Machine Properties ######################################################### ######################################################### [Generic properties to be used across all the Oracle Products] #bim.installers.root=The directory should contain following directories [bi, rcu, tt, wls, patches]. #bim.mw.home=This directory has all the Oracle Software binaries installed such as bi, wlserver_10.3, tt and so on. #The directory of bim.mw.home should be a mounted drive so that Oracle bits can be moved to shared storage later for scale out. #bim.temp.dir=This directory is used for Oracle Software installation/configuration. #bim.orainst.loc=The location of oraInst.loc to use. If not set, /etc/oraInst.loc assumed. ######################################################### bim.installers.root=/home/oracle/EXALYTICS_INSTALLERS bim.mw.home=/u01/app/oracle/product/fmw bim.temp.dir=/home/oracle/EXALYTICS_INSTALL_TEMP bim.orainst.loc=/etc/oraInst.loc ######################################################### # [RCU/BI specific properties] #bim.db.connectionstring=Oracle Database connection string in the format of hostname:port:service #bim.db.bi.schema.user=Schema User for BIPLATFORM #bim.db.bi.schema.pwd=Password for the bim.db.bi.schema.user #bim.db.mds.schema.user=Schema User for MDS #bim.db.mds.schema.pwd=Password for the bim.db.mds.schema.user #bim.db.type=Database type. Specify one of ORACLE, SQLSERVER or IBMDB2. The default is ORACLE. ######################################################### bim.db.type= bim.db.connectionstring=IP-address bim.db.bi.schema.user=EX111111_BIPLATFORM bim.db.bi.schema.pwd=welcome1 bim.db.mds.schema.user=EX111111_MDS bim.db.mds.schema.pwd=welcome1 ######################################################### # [BI specific properties] #bim.bi.domain.host= #bim.bi.domain.admin.user= #bim.bi.domain.admin.pwd= #bim.bi.wls.admin.port= #bim.bi.wls.managed.port= ######################################################### bim.bi.domain.host=host-name bim.bi.domain.admin.user=biadmin bim.bi.domain.admin.pwd=welcome1 bim.bi.wls.admin.port=7001 bim.bi.wls.managed.port=9704 ######################################################### # [etc properties] #bim.install.log.dir=The location of log files being generated during installation. ######################################################### bim.install.log.dir=/home/oracle/EXALYTICS_INSTALL_LOG
Verify that the default values are correct (for example, directories exist) or modify them if required (for example, for an operating system user other than “oracle”). Supply the missing values based on the values selected during the RCU schemas creation step. In particular, set the values for the:
RCU database connect string “bim.db.connectionstring” in the format “hostname:port:service”.
BIPLATFORM and MDS prefixes in “bim.db.bi.schema.user” and “bim.db.mds.schema.user” if the default “EX111111” was not selected when creating the metadata schemas.
BIPLATFORM and MDS passwords in “bim.db.bi.schema.pwd” and “bim.db.mds.schema.pwd” as specified during RCU schema creation.
Exalytics host name for “bim.bi.domain.host”.
Set Path Variables
Log in as root, start a shell, and remain in that same session for the remainder of the installation process.
Set the ANT_HOME and PATH environment variables:
setenv ANT_HOME /home/oracle/ANT/apache-ant-1.8.2 setenv PATH $ANT_HOME/bin:$PATH
Set the JAVA_HOME and PATH variables:
setenv JAVA_HOME /home/oracle/JDK/jdk1.6.0_29 setenv PATH $JAVA_HOME/bin:$PATH
Create Oracle Inventory Directory
Create file “oraInst.loc”:
cd /etc touch oraInst.loc
Add the following lines to the oraInst.loc file:
inventory_loc=/home/oracle/oraInventory inst_group=oinstall
Save the file.
Change the file’s ownership:
chown oracle:oinstall oraInst.loc chmod 664 oraInst.loc
Run Script Execution |
As user “oracle”, navigate to directory:
/home/oracle/EXALYTICS_INSTALLERS/bi/bishiphome/Disk1/bimachine
and run:
./setup.sh /home/oracle/EXALYTICS_INSTALLERS/bi/bishiphome/Disk1/bimachine/scripts/bim-setup.properties
Note: there will be no output until shell prompt reappears.
Installation Verification |
As with a standard OBI EE installation, attempt to login to the following components in the order shown:
Oracle WebLogic Server Console: http://<hostname>:7001/console
Fusion Middleware Control: http://<hostname>:7001/em
Oracle BI Enterprise Edition: http://<hostname>:9704/analytics
Everything Oracle | Home | Everything Oracle |
Copyright © 2007-2015 PWG Consulting, All Rights Reserved