8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | 23c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux
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.
- Assumptions
- Downloads
- Response Files
- Additional OS Packages
- Database Software Installation
- Database Creation
- WebLogic Installation
- Repository Configuration Utility (RCU) Installation
- Repository Configuration Utility (RCU)
- OBIEE Installation
- OBIEE Configuration
- OBIEE URLs
- Startup/Shutdown
Related articles.
Assumptions
To keep this article as brief as possible I'm going to make the following assumptions.
- You already have a server (Virtual or Physical) with Oracle Linux 6 and 7 (OL6 and OL7) installed (described here OL6 and OL7).
- The server has a reasonable amount of memory allocated. During my testing, the BI configuration phase would fail if the VM had less than 16G of memory assigned. If you were running the database on a separate node this could be reduced somewhat.
- The prerequisites for an Oracle Database 12c Release 1 (12.1) installation have been completed (described here OL6 and OL7).
- You are somewhat familiar with the concept of silent installations (described here).
- To keep things simple we will install both the database and OBIEE on a single machine. This is not a recommendation. As a result of this, some of the paths may look a little odd, as it will be a mix of OFA for the database and my typical paths for WebLogic installations.
- All the software listed below will be placed in the "/u01/software" directory.
- All the response files listed below are placed in the "/u01/software" directory and adjusted to suite your purposes.
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.
- Oracle Database 12c Release 1 (12.1.0.2) (linuxamd64_12102_database_1of2.zip and linuxamd64_12102_database_2of2.zip)
- JDK7 Update 80 (jdk-7u80-linux-x64.tar.gz)
- Weblogic Server 11g (10.3.6)
- Oracle Business Intelligence 11g (Linux x86-64-bit 5 files plus Repository Creation Utility)
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.
- WebLogic Console : http://ol7-obiee.localdomain:9500/console
- WebLogic Enterprise Manager: http://ol7-obiee.localdomain:7001/em
- Analytics: http://ol7-obiee.localdomain:9704/analytics
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:
- Silent Oracle Fusion Middleware Installation and Deinstallation
- Oracle Fusion Middleware System Requirements and Specifications
- Silent Installation and Configuration : OUI, DBCA, WebLogic
Hope this helps. Regards Tim...