Installation of OBIEE 12c on windows 7 Environment

Installation of OBIEE 12c on windows 7 Environment .

For trainings : training@edubodhi.co

The installation is of 4 steps:

1. JDK installation (if needed)
2. Weblogic Server installation
3. BI Installation 
4. Configuration

Download JDK 8, Weblogic server and 2 BI files from here. Unzip the files

After installing JDK.Do not  accept the default path of installing in "Program Files\Java" folder because as its a space in the name. Change the installed location to c:\Java.

Open Command Prompt as Administrator. Moved to the above folder (where the files are located) and run the Weblogic installation:
c:\Java\jdk1.8.0_65\bin\java.exe -jar fmw_12.2.1.0.0_infrastructure.jar
Accepted the defaults and pointed it to a new MWHOME I created (D:\MWHOME12, in my case).

Next run the BI installation in the same folder:
 setup_bi_platform-12.2.1.0.0_win64.exe
And selected the same MWHOME for BI installation (D:\MWHOME12, in my case).
Next screens:

Now can run the configuration part.
used the same Command Prompt Window, and run config.cmd from MWHOME\bi\bin

 left the default, including Essbase (note the RTD installation is gone).

passed the prerequests:

Dont change the location, but selected the domain user and password:

Allowed the wizard to created the RCU schema (note the options are: Oracle DB, Oracle RAC DB and MS SQL server). there is no standalone RCU anymore.

and updated the DB connection details (note, no need to add "as SYSDBA" for Oracle sys user)  :

Next left the defaults:

The options here are new and interesting:

 Saved the response file (PLEASE do it at some point, it's not fun to look for the ports and URLs later).

Now the process is running.

While the configuration passed well, the BI Startup at the bottom stayed for few very long minutes on 0%. Then jumped to 100% and finished. Made me check the log few times, during the period.

Now is the last screen. If you dont save the URLs before. Please do it now:

The OBIEE do not start on its own.

To stop and start the BI server I can run start.cmd and stop.cmd from MWHOME\user_projects\domains\bi\bitools\bin\ (D:\MWHOME12\user_projects\domains\bi\bitools\bin\start.cmd ).

After the installation my default ports are 9502 for BI and 9504 for EM.
For Administration Tool installation, the port 9516 is used in the ODBC settings.

One first discovery after the installation. Since OBIEE 12 is HTML, we can copy/paste data from analysis, in all browsers.

Process to Install and Configure OBIEE 12c on Linux environment.

Contact OBIEE 12c Online Training - training@edubodhi.co

This post is about installing and configuring OBIEE 12c with detailed step-by-step instructions(Linux x86-64.

You can start with downloading the media from OTN :

1. Download and install JDK8(at least 1.8.0_40)
2. Download and install Weblogic Server

fmw_12.2.1.0.0_infrastructure_Disk1_1of1.zip

3. Download and install Oracle Business Intelligence 12c (12.2.1.0.0)

fmw_12.2.1.0.0_bi_linux64_Disk1_1of2.zip

fmw_12.2.1.0.0_bi_linux64_Disk1_2of2.zip

Now lets start with the steps above.

1. After JDK8 is installed export environment variables and add this to the profile if needed.

export JAVA_HOME=/usr/java/jdk1.8.0_65

export PATH=$JAVA_HOME/bin:$PATH

2. Download and install Oracle Business Intelligence 12c (12.2.1.0.0)

$ unzip -q fmw_12.2.1.0.0_infrastructure_Disk1_1of1.zip
$ $JAVA_HOME/bin/java -d64 -jar fmw_12.2.1.0.0_infrastructure.jar  

Click Next to continue and then choose ‘Skip Auto Updates’ and then click Next.

Choose the Fusion Middleware Home location for example /app/oracle/obiee12c

Choose Fusion Middleware Infrastructure with Examples in case you are keen on playing with them.

Click Next after all system configuration checks are successful.

 Choose Next and continue to next screen.

Choose Install to proceed with the installation.

Click Finish to complete the installation.

Oracle Fusion Middleware Infrastructure 12c is now installed.

3. Install OBIEE

To begin with OPMN is no more used in Oracle Fusion Middleware and is deprecated in 12c. You can check more about OBIEE 12c New Features here.

Navigate to the directory where you downloaded the media and unzip the two files.

$ cd /home/oracle/obiee12c

$ unzip -q fmw_12.2.1.0.0_bi_linux64_Disk1_1of2.zip

$ unzip -q fmw_12.2.1.0.0_bi_linux64_Disk1_2of2.zip

$ ./bi_platform-12.2.1.0.0_linux64.bin

Choose Next

 

Again choose Skip Auto Updates and then click Next.

Specify the same Fusion Middleware home from the steps above. 

Choose BI Platform with Samples in case you want to play with the Sample Apps. 

When all system configuration checks are passed click Next. 

Choose Install to proceed with the installation. 

Choose Finish to complete the installation.

 

OBIEE 12c is now installed. Next part of this post will cover the repository creation.

4. Repository creation

The RCU – Repository Creation Utility is no more a separate download as it used to be in the previous releases. It is now part of the software installation. You can start RCU as shown below:

$ cd /app/oracle/obiee12c/oracle_common/bin

$ ./rcu 

Click Next and then choose Create Repository and then System Load and Product Load if you have DBA privileges. 

Specify the Oracle database details. Note that Oracle Fusion Middleware 12c requires Oracle Database 11g R2(11.2.0.4) or higher. Bare in mind if you go with Oracle 12c you’d better use a container database as non-container architecture is deprecated in Oracle Database 12c, and may be desupported and unavailable in a release after Oracle Database 12cRelease 2. Oracle recommendation is to use the container architecture. 

Click OK when prerequisite checks are completed and choose Next.

Choose the prefix for the schemas to be created, in this case the default DEV.

Click OK when prerequisite checks are completed and choose Next. 

Provide password(s) for the schemas to be created. 

 Choose Next 

Click OK 

Click Create to confirm the schemas which will be created. 

Click Close to exit from RCU. With this step the repositories creation is complete. 

Next section will cover the configuration of OBIEE 12c. 

5. Configure OBIEE 12c 

Navigate to <OBIEE_HOME>/bi/bin and start the configuration utility script. 

$ cd /app/oracle/obiee12c/bi/bin

$ ./config.sh 

Select components to install in this case just Business Intelligence Enterprise Edition and then click Next. 

Click Next when all system checks are completed. 

Specify the details for the BI domain to be created.

 

The repositories schemas are created with the RCU so choose Use existing schemas to continue. You have the option to create the schemas at this step too if you haven’t done this yet. 

Specify the port numbers in this case default values. 

Choose SampleAppLite in case you need this. 

On the next screen click Configure. This step will take a while to get the configuration completed. 

Click Next and you will get the configuration complete screen. 

It is always useful to save the configuration install log file. Click Finish to complete the configuration. 

Once this is done a browser window opens up automatically for you to login to OBIEE. 

 

This post will end up with listing the basic commands to manage the services. The scripts for this are located in <OBIEE_HOME>/user_projects/domains/bi/bitools/bin

• start.sh
• status.sh
• stop.sh