OBIEE 12c Silent Installation in CENTOS/RHEL

No comments
Share this post

Pre Requisites:

Oracle DB has to be setup and portable Database to be available before starting the process.

List of files to Download:

  • jdk-8u131-linux-x64.rpm
  • fmw_12.2.1.3.0_infrastructure_Disk1_1of1.zip   (Click on Web Logic Server Generic)
  • fmw_12.2.1.4.0_bi_linux64_Disk1_1of2.zip   (Click on Oracle Business Intelligence 12c (12.2.1.4.0 for Linux x86-64-bit  File1)
  • fmw_12.2.1.4.0_bi_linux64_Disk1_2of2.zip   (Click on Oracle Business Intelligence 12c (12.2.1.4.0 for Linux x86-64-bit  File2)

Installation Steps:

  1. Login into the new VM and ensure you have super user privileges, and run the below commands from root user.

The below are additional OS packages to be installed.

# OL6 and OL7.

yum update

yum install binutils compat-libcap1 compat-libstdc++-33 compat-libstdc++-33.i686 gcc gcc-c++ glibc glibc.i686 glibc-devel libaio libaio-devel libgcc
libgcc.i686 libstdc++ libstdc++.i686 libstdc++-devel ksh make sysstat numactl numactl-devel motif motif-devel -y

Additional Yum Updates just to be checked.
yum install compat-libcap1-1.10
yum install compat-libstdc++-33-3.2.3-x86_64
yum install libstdc++-devel-4.8.2-x86_64
yum install gcc-c++-4.8.2
yum install compat-libstdc++-33-3.2.3-x86_64
yum install compat-libstdc++-33
yum install libstdc++-devel
yum install gcc

# OL6 ONly. yum install libXext.i686 -y yum install libXtst.i686 -y yum install openmotif -y yum install openmotif22 -y

2. The “/etc/hosts” file must contain a fully qualified name for the server (Ensure the hostname does not exceeds 60 characters, else it creates error during running OBIEE configuration) .

<IP-address>  <fully-qualified-machine-name>  <machine-name>

For example.

192.168.122.1 oel7 oel7.biks.in

Set hostname

hostnamectl set-hostname oel7.biks.in --static

3. Create a user "oracle" and group "oinstall" from root user

groupadd oinstall
useradd oracle -g oinstall

#run the below commands for creating the ENV directories.

mkdir -p /u01/app/oracle/middleware
mkdir -p /u01/app/oracle/config/domains
mkdir -p /u01/app/oracle/config/applications
chown -R oracle:oinstall /u01
chmod -R 775 /u01/

Export the environment variables ( Update the Domain Name, and connection string according to your environment ) or Keep them in ~/.bash_profile for oracle user.

.bash_profile content below

# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
	. ~/.bashrc
fi

# User specific environment and startup programs
export JAVA_HOME="/usr/java/jdk1.8.0_311-amd64"

PATH=$PATH:$HOME/.local/bin:$HOME/bin:$JAVA_HOME/bin

export PATH

export DOMAIN_NAME=bi1
export DOMAINS_DIR=/u01/app/oracle/middleware/user_projects/domains
export ADMIN_PASSWORD=Admin123
export CONNECT_STRING=196.15.23.23:1521:BIKSORA19C1
export NEW_DB_PASSWORD=OraPasswd1
export NEW_DB_SCHEMA_PREFIX=BIKS_DEV_OBI1
export NEW_DB_SCHEMA_PASSWORD=BiksdevPasswd1
export ORACLE_HOME=/u01/app/oracle/middleware
export MW_HOME=/u01/app/oracle/middleware
export WLS_HOME=$MW_HOME/wlserver
export WL_HOME=$WLS_HOME
export DOMAIN_HOME=$MW_HOME/user_projects/domains/bi1

Ensure the below files are available under "/u01/software" directory, and you are switched to oracle user.

fmw_12.2.1.3.0_infrastructure_Disk1_1of1.zip
fmw_12.2.1.4.0_bi_linux64_Disk1_1of2.zip
fmw_12.2.1.4.0_bi_linux64_Disk1_2of2.zip
jdk-8u311-linux-x64.rpm

Install Java 8 First from root user and add the path to ~/.bash_profile file for all users and then set the java path accordingly

/u01/software:> yum localinstall jdk-8u311-linux-x64.rpm

Example to set PATH

$ which java
usr/sun/jdk/v1.6.0_16-64bit


You can see that JDK is installed on “/usr/sun/jdk/v1.6.0_16-64bit”.

2) Add the following line of your .bash_profile file if you want to set JAVA_HOME for yourself or /etc/profile if you want to set JAVA_HOME for all user

vim ~/.bash_profile
export JAVA_HOME=/usr/sun/jdk/v1.6.0_16-64bit/
export PATH = $JAVA_HOME/bin:$PATH

Unzip the weblogic and OBIEE directories under /u01/software location and then ensure to have the attached response files under same location

unzip -o fmw_12.2.1.3.0_infrastructure_Disk1_1of1.zip
unzip -o fmw_12.2.1.4.0_bi_linux64_Disk1_1of2.zip
unzip -o fmw_12.2.1.4.0_bi_linux64_Disk1_2of2.zip

oracle@host_name: > pwd
/u01/software

oracle@host_name: > ls -l


all response files are attached (Please refer attachments )

After ensuring the required response files under /u01/software location, run the Weblogic and OBIEE silent installation commands.

#Install Weblogic in Silent Mode
$JAVA_HOME/bin/java -Xmx1024m -jar /u01/software/fmw_12.2.1.3.0_infrastructure.jar -silent -responseFile /u01/software/weblogic.rsp -invPtrLoc /u01/software/oraInst.loc

#Install OBIEE in Silent Mode
./bi_platform-12.2.1.4.0_linux64.bin -silent -responseFile /u01/software/obiee.rsp -invPtrLoc /u01/software/oraInst.loc -ignoreSysPrereqs

#Configure OBIEE RCU
$MW_HOME/bi/bin/config.sh -silent -responseFile /u01/software/bi_config.rsp -invPtrLoc /u01/software/oraInst.loc

Once you run the OBIEE configure commands, you can disable firewall( If any firewall is enabled in the machine ) with below commands.

#Check if Firewall is enabled with below command

$:> sudo firewall-cmd --state

If found running, disable with root user with below command.

$:> systemctl stop firewalld

Congratulations, Weblogic and OBIEE is setup completely, use the below URL’s to access the pages.

http://<hostname>/:9500/console

http://<hostname>/:9500/em

http://<hostname>/:9502/analytics

All Response Files mentioned below

bi_config.rsp
[ENGINE]

#DO NOT CHANGE THIS.
Response File Version=1.0.0.0.0

[GENERIC]

#If false, omit the startup action at the end of the config assistant.
PERFORM_BI_STARTUP=true

#Set limit on number of BI Service Instances. Only used if SERVICE_INSTANCE_MODE = MULTI
SERVICE_INSTANCE_LIMIT=2

#Select to include Essbase.   Values are true or false.
CONFIGURE_ESSBASE=true

#Select to include BIEE.   Values are true or false.
CONFIGURE_BIEE=true

#Select to include BIP (BI Publisher).   Values are true or false.
CONFIGURE_BIP=true

#Install Exalytics In-Memory Software. If this is set to true and Exalytics hardware is NOT present an error will occur.
INSTALL_EXALYTICS_IN_MEMORY_SOFTWARE=false

#Set Single Service Instance vs Multi Service Instance Mode.
SERVICE_INSTANCE_MODE=SINGLE

#The domain to be created
DOMAIN_NAME=bi2

#The directory in which the domain home directory will be created
DOMAINS_DIR=/u01/app/oracle/middleware/user_projects/domains

#Specify the administrator username.
ADMIN_USER_NAME=weblogic

#Specify the administrator password.
ADMIN_PASSWORD=Admin123456

#Specify the administrator confirmation password
ADMIN_CONFIRM_PASSWORD=Admin123456

#Select the schema type. Supported types are SCHEMA_TYPE_NEW, SCHEMA_TYPE_EXISTING.  
SCHEMA_TYPE=SCHEMA_TYPE_NEW

#Select the new database type to connect to. Supported database types are ORACLE, SQLSERVER and IBMDB2.
DATABASE_TYPE=ORACLE

#Select the existing database type to connect to. Supported database types are ORACLE and SQLSERVER.
EXISTING_DATABASE_TYPE=ORACLE

#Format: hostname:port:servicename. For Application Cluster Database: host1:port1^host2:port2@servicename
CONNECT_STRING=196.15.23.23:1521:BIKSORA19C1

#Format: host1:port1^host2:port2
FAN_CONNECT_STRING=

#Username for account with privileges to create new schemas
NEW_DB_ADMIN_USERNAME=SYS

#Password for account with privileges to create new schemas.
NEW_DB_PASSWORD=BiksOracle19c#

#Prefix for newly created schemas
NEW_DB_SCHEMA_PREFIX=DEVANALYTICS

#Password to be used for all new schemas.
NEW_DB_SCHEMA_PASSWORD=Admin123456

#Password to be used for all new schemas.
NEW_DB_CONFIRM_SCHEMA_PASSWORD=Admin123456

#Enter the prefix used in RCU when the schemas were created.
EXISTING_DB_PREFIX=DEV

#Enter the password for the STB schema.
EXISTING_DB_PASSWORD=Admin123456

#The start port for the port range
PORT_RANGE_START=9500

#The end port for the port range
PORT_RANGE_END=9999

#Select type of initial application.  Supported types are APPLICATION_TYPE_SAMPLE_APP_LITE and APPLICATION_TYPE_BI_BUNDLE.
APPLICATION_TYPE=APPLICATION_TYPE_SAMPLE_APP_LITE

#Location of BI Bundle file to use as the initial application.  Only used if APPLICATION_TYPE is BI_BUNDLE. 
BI_BUNDLE_FILE=

#Password which secures existing BI archive file
BI_BUNDLE_PASSWORD=

#New password which will secure AppLite as it is modified with customer data
BI_APP_LITE_PASSWORD=

#Identifier of initial default service instance if pluggable modules is enabled
BI_DEFAULT_SERVICE_INSTANCE_KEY=ssi
bi_config_no_rcu.rsp
[ENGINE]

#DO NOT CHANGE THIS.
Response File Version=1.0.0.0.0

[GENERIC]

#If false, omit the startup action at the end of the config assistant.
PERFORM_BI_STARTUP=true

#Set limit on number of BI Service Instances. Only used if SERVICE_INSTANCE_MODE = MULTI
SERVICE_INSTANCE_LIMIT=2

#Select to include Essbase.   Values are true or false.
CONFIGURE_ESSBASE=true

#Select to include BIEE.   Values are true or false.
CONFIGURE_BIEE=true

#Select to include BIP (BI Publisher).   Values are true or false.
CONFIGURE_BIP=true

#Install Exalytics In-Memory Software. If this is set to true and Exalytics hardware is NOT present an error will occur.
INSTALL_EXALYTICS_IN_MEMORY_SOFTWARE=false

#Set Single Service Instance vs Multi Service Instance Mode.
SERVICE_INSTANCE_MODE=SINGLE

#The domain to be created
DOMAIN_NAME=bi1

#The directory in which the domain home directory will be created
DOMAINS_DIR=/u01/app/oracle/middleware/user_projects/domains

#Specify the administrator username.
ADMIN_USER_NAME=weblogic

#Specify the administrator password.
ADMIN_PASSWORD=Admin123456

#Specify the administrator confirmation password
ADMIN_CONFIRM_PASSWORD=Admin123456

#Select the schema type. Supported types are SCHEMA_TYPE_NEW, SCHEMA_TYPE_EXISTING.  
SCHEMA_TYPE=SCHEMA_TYPE_EXISTING

#Select the new database type to connect to. Supported database types are ORACLE, SQLSERVER and IBMDB2.
DATABASE_TYPE=ORACLE

#Select the existing database type to connect to. Supported database types are ORACLE and SQLSERVER.
EXISTING_DATABASE_TYPE=ORACLE

#Format: hostname:port:servicename. For Application Cluster Database: host1:port1^host2:port2@servicename
CONNECT_STRING=196.15.23.23:1521:BIKSORA19C1

#Format: host1:port1^host2:port2
FAN_CONNECT_STRING=

#Username for account with privileges to create new schemas
NEW_DB_ADMIN_USERNAME=SYS

#Password for account with privileges to create new schemas.
NEW_DB_PASSWORD=BiksOracle19c#

#Prefix for newly created schemas
NEW_DB_SCHEMA_PREFIX=DEV

#Password to be used for all new schemas.
NEW_DB_SCHEMA_PASSWORD=Admin123456

#Password to be used for all new schemas.
NEW_DB_CONFIRM_SCHEMA_PASSWORD=

#Enter the prefix used in RCU when the schemas were created.
EXISTING_DB_PREFIX=BI122130

#Enter the password for the STB schema.
EXISTING_DB_PASSWORD=BiksdevPasswd1

#The start port for the port range
PORT_RANGE_START=9500

#The end port for the port range
PORT_RANGE_END=9999

#Select type of initial application.  Supported types are APPLICATION_TYPE_SAMPLE_APP_LITE and APPLICATION_TYPE_BI_BUNDLE.
APPLICATION_TYPE=APPLICATION_TYPE_SAMPLE_APP_LITE

#Location of BI Bundle file to use as the initial application.  Only used if APPLICATION_TYPE is BI_BUNDLE. 
BI_BUNDLE_FILE=

#Password which secures existing BI archive file
BI_BUNDLE_PASSWORD=

#New password which will secure AppLite as it is modified with customer data
BI_APP_LITE_PASSWORD=

#Identifier of initial default service instance if pluggable modules is enabled
BI_DEFAULT_SERVICE_INSTANCE_KEY=ssi
OBIEE.rsp
[ENGINE]

#DO NOT CHANGE THIS.
Response File Version=1.0.0.0.0

[GENERIC]

#Set this to true if you wish to skip software updates
DECLINE_AUTO_UPDATES=true

#My Oracle Support User Name
MOS_USERNAME=

#My Oracle Support Password
MOS_PASSWORD=

#If the Software updates are already downloaded and available on your local system, then specify the path to the directory where these patches are available and set SPECIFY_DOWNLOAD_LOCATION to true
AUTO_UPDATES_LOCATION=

#Proxy Server Name to connect to My Oracle Support
SOFTWARE_UPDATES_PROXY_SERVER=

#Proxy Server Port
SOFTWARE_UPDATES_PROXY_PORT=

#Proxy Server Username
SOFTWARE_UPDATES_PROXY_USER=

#Proxy Server Password
SOFTWARE_UPDATES_PROXY_PASSWORD=

#The oracle home location. This can be an existing Oracle Home or a new Oracle Home
ORACLE_HOME=/u01/app/oracle/middleware

#Set this variable value to the Installation Type selected. e.g. BI Platform Distribution, BI Platform Distribution with Samples.
INSTALL_TYPE=BI Platform Distribution with Samples
weblogic.rsp
[ENGINE]

#DO NOT CHANGE THIS.
Response File Version=1.0.0.0.0

[GENERIC]

#Set this to true if you wish to skip software updates
DECLINE_AUTO_UPDATES=true

#My Oracle Support User Name
MOS_USERNAME=

#My Oracle Support Password
MOS_PASSWORD=

#If the Software updates are already downloaded and available on your local system, then specify the path to the directory where these patches are available and set SPECIFY_DOWNLOAD_LOCATION to true
AUTO_UPDATES_LOCATION=

#Proxy Server Name to connect to My Oracle Support
SOFTWARE_UPDATES_PROXY_SERVER=

#Proxy Server Port
SOFTWARE_UPDATES_PROXY_PORT=

#Proxy Server Username
SOFTWARE_UPDATES_PROXY_USER=

#Proxy Server Password
SOFTWARE_UPDATES_PROXY_PASSWORD=

#The oracle home location. This can be an existing Oracle Home or a new Oracle Home
ORACLE_HOME=/u01/app/oracle/middleware

#Set this variable value to the Installation Type selected. e.g. Fusion Middleware Infrastructure, Fusion Middleware Infrastructure With Examples.
INSTALL_TYPE=Fusion Middleware Infrastructure

#Provide the My Oracle Support Username. If you wish to ignore Oracle Configuration Manager configuration provide empty string for user name.
MYORACLESUPPORT_USERNAME=

#Provide the My Oracle Support Password
MYORACLESUPPORT_PASSWORD=

#Set this to true if you wish to decline the security updates. Setting this to true and providing empty string for My Oracle Support username will ignore the Oracle Configuration Manager configuration
DECLINE_SECURITY_UPDATES=true

#Set this to true if My Oracle Support Password is specified
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false

#Provide the Proxy Host
PROXY_HOST=

#Provide the Proxy Port
PROXY_PORT=

#Provide the Proxy Username
PROXY_USER=

#Provide the Proxy Password
PROXY_PWD=

#Type String (URL format) Indicates the OCM Repeater URL which should be of the format [scheme[Http/Https]]://[repeater host]:[repeater port]
COLLECTOR_SUPPORTHUB_URL=
oraInst.loc
inventory_loc=/u01/app/oraInventory
inst_group=oinstall
OBIEE_RCU_PARAMFILE.txt
BiksOracle19c#
BiksdevPasswd1

Yipieee….The work is done..


Share this post
Tags

Leave a Reply

Your email address will not be published. Required fields are marked *