8i | 9i | 10g | 11g | 12c | 13c | 18c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Articles » 11g » Here

Oracle Business Intelligence 11g Silent Installation on Oracle Linux 7 (OL7)

This article demonstrates how to perform a silent installation of Oracle Business Intelligence 11g on Oracle Linux 6 and 7 (OL6 and OL7) using Oracle Database 12c Release 1 (12.1) for the repository created by the Repository Creation Utility (RCU).

Thanks to Gianni Ceresa and Christian Berg for their advice.

Related articles.

Assumptions

To keep this article as brief as possible I'm going to make the following assumptions.

I don't work with OBIEE, but I do have to provide basic support of some infrastructure that runs it (database and WebLogic).

Downloads

There is a lot of software to download before you can begin. I've purposely not included the latest critical updates.

Response Files

The following response files are necessary for the silent installations shown below. The values you may need to amend are shown in bold.

weblogic-silent.xml

<?xml version="1.0" encoding="UTF-8"?>
   <bea-installer> 
     <input-fields>
       <data-value name="BEAHOME" value="/u01/app/oracle/middleware" />
       <data-value name="WLS_INSTALL_DIR" value="/u01/app/oracle/middleware/wlserver_10.3" />
       <data-value name="COMPONENT_PATHS"
        value="WebLogic Server/Core Application Server|WebLogic Server/Administration Console|WebLogic Server/Configuration Wizard and Upgrade Framework|WebLogic Server/Web 2.0 HTTP Pub-Sub Server|WebLogic Server/WebLogic JDBC Drivers|WebLogic Server/Third Party JDBC Drivers|WebLogic Server/WebLogic Server Clients|WebLogic Server/WebLogic Web Server Plugins|WebLogic Server/UDDI and Xquery Support|Oracle Coherence/Coherence Product Files" />
       <data-value name="INSTALL_NODE_MANAGER_SERVICE" value="yes" />
       <data-value name="NODEMGR_PORT" value="5556" />
       <data-value name="INSTALL_SHORTCUT_IN_ALL_USERS_FOLDER" value="no"/>
       <data-value name="LOCAL_JVMS" value="/u01/app/oracle/jdk1.7.0_80"/>
   </input-fields> 
</bea-installer>

obiee.rsp

[ENGINE]

#DO NOT CHANGE THIS.
Response File Version=1.0.0.0.0

[GENERIC]

#Set this to true if you wish to specify a directory where latest updates are downloaded. This option would use the software updates from the specified directory
SPECIFY_DOWNLOAD_LOCATION=false

#Set this to true to skip the Software updates
SKIP_SOFTWARE_UPDATES=true

#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
SOFTWARE_UPDATES_DOWNLOAD_LOCATION=

#Install Software and Configure Components for Express Install. Installs and Configures components with default settings. Installs the light-weight WebLogic Server and creates a new domain.
INSTALL_FOR_DEVELOPMENT_TYPE=false

#Install and Configure Software Components and Applications. Installs binaries in an ORACLE_HOME and configures working instances in an INSTANCE_HOME.
INSTALL_AND_CONFIGURE_TYPE=false

#Install Software Components and Applications. Installs binaries in an ORACLE_HOME, but do not configure working instances of installed components.
INSTALL_AND_CONFIGURE_LATER_TYPE=true

#Set this to true if you want to create a new BI System, all other required variables need to be provided. If this is set to true then variables "SCALEOUT_BISYSTEM" and "EXTEND_BISYSTEM" must be set to false, since the variables are mutually exclusive.
CREATE_BISYSTEM=true

#Set this to true if you want to scale out an existing BI System, all other required variables need to be provided. If this is set to true then variables "CREATE_BISYSTEM","EXTEND_BISYSTEM" and "UPDATE_BIDOMAIN" must be set to false, since the variables are mutually exclusive. In order to scale out an existing BI system, the domain in the system must be running
SCALEOUT_BISYSTEM=false

#Set this to true if you want to configure BI System in an existing exmpty domain in the localhost, all other required variables need to be provided. If this is set to true then variables "CREATE_BISYSTEM","SCALEOUT_BISYSTEM" and "UPDATE_BIDOMAIN" must be set to false, since the variables are mutually exclusive.
EXTEND_BISYSTEM=false

#Set this to true if you want to update an existing BI System running on the localhost, all other required variables need to be provided. If this is set to true then variables "CREATE_BISYSTEM","EXTEND_BISYSTEM" and "SCALEOUT_BISYSTEM" must be set to false, since the variables are mutually exclusive.
UPDATE_BIDOMAIN=false

#Write the name of the domain you want to create. Domain name may only contain alphanumeric characters, or the underscore (_) or hyphen (-) characters.
DOMAIN_NAME=bi

#Write the name of the cell you want to create. Cell name may only contain alphanumeric characters, or the underscore (_) or hyphen (-) characters.
CELL_NAME=unknown

#Write the name of the host to which you want to connect. It should have an already existing domain configured.
DOMAIN_HOSTNAME=ol7-obiee.localdomain

#Give the port number at which the host should be connected.
DOMAIN_PORT=

#Give an administrator user name for the domain if you are creating a new one otherwise give the administrator user name for the domain configured at the host.
ADMIN_USER_NAME=weblogic

#Give an administrator password for the domain if you are creating a new one otherwise give the administrator password for the domain configured at the host.
ADMIN_PASSWORD=Admin123

#Write the administrator password again to confirm.
ADMIN_CONFIRM_PASSWORD=Admin123

#Is Single Server Install.
WLS_SINGLE_SERVER_INSTALL=false

#Write the complete path to a valid Middleware Home.
MW_HOME=/u01/app/oracle/middleware

#Give the complete path to a valid WebLogic Server Home.
WEBLOGIC_HOME=/u01/app/oracle/middleware/wlserver_10.3

#Give the name of the Oracle Home directory. The Oracle Home directory name may only contain alphanumeric , hyphen (-) , dot (.) and underscore (_) characters, and it must begin with an alphanumeric character.
ORACLE_HOME=/u01/app/oracle/middleware/bi_home1

#Give the complete path for an Oracle Instance directory to be created. This is the location where the software configuration files and runtime processes will reside.
INSTANCE_HOME=/u01/app/oracle/middleware/bi_inst1

#Give a name for Oracle Instance corresponding to the Instance Home. The Oracle Instance name may only contain alphanumeric and underscore (_) characters, it must begin with an alphabetic (a-z or A-Z) character, and must be from 4 to 30 characters in length.
INSTANCE_NAME=bi_inst1

#Give the complete path for a domain home to be created.
DOMAIN_HOME_PATH=/u01/app/oracle/middleware/user_projects/domains/bi

#Format: hostname:port:servicename. For Application Cluster Database: host1:port1^host2:port2@servicename
DATABASE_CONNECTION_STRING_BI=ol7-obiee.localdomain:1521:repdev

#Enter the BIPLATFORM schema username.
DATABASE_SCHEMA_USER_NAME_BI=DEV_BIPLATFORM

#Enter the BIPLATFORM schema password.
DATABASE_SCHEMA_PASSWORD_BI=BiPlatformPasswd1

#Select the database type in which the BIPLATFORM schema exists. Supported database types are Oracle Database, Microsoft SQL Server, IBM DB2.
DATABASE_TYPE_BI=Oracle Database

#Format: hostname:port:servicename. For Application Cluster Database: host1:port1^host2:port2@servicename
DATABASE_CONNECTION_STRING_MDS=ol7-obiee.localdomain:1521:repdev

#Enter the MDS schema username.
DATABASE_SCHEMA_USER_NAME_MDS=DEV_MDS

#Enter the MDS schema password.
DATABASE_SCHEMA_PASSWORD_MDS=MdsPasswd1

#Select the database type in which the MDS schema exists. Supported database types are Oracle Database, Microsoft SQL Server, IBM DB2.
DATABASE_TYPE_MDS=Oracle Database

#
AUTOMATIC_PORT_DETECT=true

#
STATICPORT INI FILE LOCATION=

#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=


[SYSTEM]


[APPLICATIONS]

#Set to true to configure Oracle Business Intelligence Enterprise Edition. Otherwise set to false.
CONFIGURE_BI=true

#Set to true to configure Oracle Business Intelligence Publishing and Reporting. Otherwise set to false.
CONFIGURE_BIP=true

#Set to true to configure Oracle Real-Time Decisions. Otherwise set to false.
CONFIGURE_RTD=true

#Set to true to select all Oracle Essbase Components. Otherwise set to false.
CONFIGURE_ESSBASE_SUITE=true


[RELATIONSHIPS]

oraInst.loc

inventory_loc=/u01/app/oraInventory
inst_group=oinstall

obiee_rcu_paramfile.txt

SysPasswd1
BiPlatformPasswd1
MdsPasswd1

Additional OS Packages

Install the following package for the Fusion Middleware prerequisites to be met. Many of them will already be present because of the database prerequisites.

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

# OL7 Only.
yum install motif -y
yum install motif-devel -y

# OL6 Only.
yum install libXext.i686 -y
yum install libXtst.i686 -y
yum install libXi.i686 -y
yum install openmotif -y
yum install openmotif22 -y
yum install redhat-lsb -y

Database Software Installation

Assuming you have completed all the OS prerequisites for a database installation, you can install the database software as follows.

Unzip the software.

cd /u01/software
unzip -o linuxamd64_12102_database_1of2.zip
unzip -o linuxamd64_12102_database_2of2.zip

Install the database software in silent mode.

cd database

./runInstaller -ignoreSysPrereqs -showProgress -silent \
  -responseFile /u01/software/database/response/db_install.rsp \
  oracle.install.option=INSTALL_DB_SWONLY \
  ORACLE_HOSTNAME=ol7-obiee.localdomain \
  UNIX_GROUP_NAME=oinstall \
  INVENTORY_LOCATION=/u01/app/oraInventory \
  SELECTED_LANGUAGES=en,en_GB \
  ORACLE_HOME=/u01/app/oracle/product/12.1.0.2/db_1 \
  ORACLE_BASE=/u01/app/oracle \
  oracle.install.db.InstallEdition=EE \
  oracle.install.db.DBA_GROUP=dba \
  oracle.install.db.BACKUPDBA_GROUP=dba \
  oracle.install.db.DGDBA_GROUP=dba \
  oracle.install.db.KMDBA_GROUP=dba \
  SECURITY_UPDATES_VIA_MYORACLESUPPORT=false \
  DECLINE_SECURITY_UPDATES=true

When prompted, run the root scripts.

# Run root scripts as directed.
#
# As a root user, execute the following script(s):
#         1. /u01/app/oraInventory/orainstRoot.sh
#         2. /u01/app/oracle/product/12.1.0.2/db_1/root.sh

Database Creation

Start the listener.

lsnrctl start

Create the database using the Database Creation Assistant (DBCA) in silent mode.

#dbca -silent -deleteDatabase -sourceDB repdevcdb -sysDBAUserName sys -sysDBAPassword SysPasswd1

dbca -silent -createDatabase \
 -templateName General_Purpose.dbc \
 -gdbname repdevcdb -sid repdevcdb -responseFile NO_VALUE \
 -characterSet AL32UTF8 \
 -sysPassword SysPasswd1 \
 -systemPassword SysPasswd1 \
 -createAsContainerDatabase true \
 -numberOfPDBs 1 \
 -pdbName repdev \
 -pdbAdminPassword PdbPasswd1 \
 -databaseType MULTIPURPOSE \
 -automaticMemoryManagement false \
 -totalMemory 1536 \
 -storageType FS \
 -datafileDestination "/u01/app/oracle/oradata/" \
 -redoLogFileSize 500 \
 -emConfiguration NONE \
 -ignorePreReqs

Set minimum parameter levels and make sure the pluggable database starts when the instance starts.

sqlplus / as sysdba <<EOF
ALTER SYSTEM SET shared_pool_size=150M SCOPE=SPFILE;
--ALTER SYSTEM SET sga_target 150M SCOPE=SPFILE;
ALTER SYSTEM SET session_cached_cursors=100 SCOPE=SPFILE;
ALTER SYSTEM SET processes=500 SCOPE=SPFILE;
ALTER SYSTEM SET open_cursors=800 SCOPE=SPFILE;
ALTER SYSTEM SET db_files=600 SCOPE=SPFILE;

ALTER SESSION SET CONTAINER = repdev;
ALTER PLUGGABLE DATABASE SAVE STATE;

CONN / AS SYSDBA
SHUTDOWN IMMEDIATE;
STARTUP;
EXIT;
EOF

WebLogic Installation

Set the required environment variables.

export MW_HOME=/u01/app/oracle/middleware
export WLS_HOME=$MW_HOME/wlserver_10.3
export WL_HOME=$WLS_HOME
export DOMAIN_HOME=$MW_HOME/user_projects/domains/bi
# Set to the appropriate JAVA_HOME.
export JAVA_HOME=/u01/app/oracle/jdk1.7.0_80
export PATH=$JAVA_HOME/bin:$PATH

Install JDK7.

cd /u01/app/oracle/
tar -xvzf /u01/software/jdk-7u80-linux-x64.tar.gz

Create the middleware location.

mkdir -p /u01/app/oracle/middleware

Install WebLogic in silent mode.

$JAVA_HOME/bin/java -Xmx1024m -jar /u01/software/wls1036_generic.jar -mode=silent -silent_xml=/u01/software/weblogic-silent.xml

Repository Configuration Utility (RCU) Installation

Install the Fusion Middleware (FMW) RCU in a temporary location.

mkdir -p $MW_HOME/bi_rcu
cd $MW_HOME/bi_rcu
unzip /u01/software/rcuHome.zip

Repository Configuration Utility (RCU)

Use the following command to run the RCU in silent mode.

$MW_HOME/bi_rcu/bin/rcu -silent -createRepository \
  -connectString ol7-obiee.localdomain:1521/repdev -dbUser SYS -dbRole SYSDBA \
  -schemaPrefix DEV \
  -component BIPLATFORM -component MDS -f < /u01/software/obiee_rcu_paramfile.txt

OBIEE Installation

Unzip the software.

cd /u01/software
unzip -o obi_LINUXX64_11.1.1.9.0_disk1of5.zip
unzip -o obi_LINUXX64_11.1.1.9.0_disk2of5.zip
unzip -o obi_LINUXX64_11.1.1.9.0_disk3of5.zip
unzip -o obi_LINUXX64_11.1.1.9.0_disk4of5.zip
unzip -o obi_LINUXX64_11.1.1.9.0_disk5of5.zip

The installation and configuration can be done in a single step if the following parameters are set in the response file.

INSTALL_AND_CONFIGURE_TYPE=true
INSTALL_AND_CONFIGURE_LATER_TYPE=false

The response file used in this example does an installation with no configuration. Install the OBIEE software in silent mode.

cd /u01/software/bishiphome/Disk1

./runInstaller -silent -responseFile /u01/software/obiee.rsp -invPtrLoc /u01/software/oraInst.loc

OBIEE Configuration

All the information to configure OBIEE is present in the response file we used for the installation. The following command runs the OBIEE configuration in silent mode.

$MW_HOME/bi_home1/bin/config.sh -silent -responseFile /u01/software/obiee.rsp -invPtrLoc /u01/software/oraInst.loc

OBIEE URLs

Once configured, the main URLs you will need are as follows.

Startup/Shutdown

The database is started and stopped in the normal way.

export ORAENV_ASK=NO
export ORACLE_SID=repdevcdb
. oraenv
export ORAENV_ASK=YES

dbstart $ORACLE_HOME
dbshut $ORACLE_HOME

Make sure you have the environment set correctly.

export MW_HOME=/u01/app/oracle/middleware
export WLS_HOME=$MW_HOME/wlserver_10.3
export WL_HOME=$WLS_HOME
export DOMAIN_HOME=$MW_HOME/user_projects/domains/bi
# Set to the appropriate JAVA_HOME.
export JAVA_HOME=/u01/app/oracle/jdk1.7.0_80
export PATH=$JAVA_HOME/bin:$PATH

Create a "boot.properties" file for each of the servers, so we don't need to manually enter credentials on startup/shutdown. This only has to be done once.

# AdminServer
echo "username=weblogic" > $DOMAIN_HOME/servers/AdminServer/security/boot.properties
echo "password=Admin123" >> $DOMAIN_HOME/servers/AdminServer/security/boot.properties

# bi_server1
cp $DOMAIN_HOME/servers/AdminServer/security/boot.properties $DOMAIN_HOME/servers/bi_server1/security/boot.properties

With then environment in place we can start and stop OBIEE using the following commands.

# Startup
nohup $DOMAIN_HOME/bin/startWebLogic.sh > /dev/null 2>&1 &
nohup $DOMAIN_HOME/bin/startManagedWebLogic.sh bi_server1 > /dev/null 2>&1 &

# Shutdown
$DOMAIN_HOME/bin/stopManagedWebLogic.sh bi_server1
$DOMAIN_HOME/bin/stopWebLogic.sh

For more information see:

Hope this helps. Regards Tim...

Back to the Top.