Note: This guide covers installation steps for Windows 7, 8, 8.1 and Windows Server 2012 (Tried and Tested). Make sure you have “Microsoft Visual C++ Redistributable “installed on your system.
- Java SDK 6 or higher
- Loopback Adapter
- Oracle 11g 11.2
Tried and Tested OBIEE installation on these Configurations:
OS: Windows 7, 8, 8.1, Server 2012 64-bit
RAM: 4GB (minimum)
CPU: Intel Core Dual Core, i3, i5, i7, 2.20 GHz
Minimum configuration needed for OBIEE 11G:
• Disk Space (HARD DISK): 20GB (or above)
• Available Memory (RAM): 4GB (or above)
• Temp Space: 950MB (or above)
• Swap Space: 3GB (or above)
• CPU: dual-core Pentium, 1.5GHz or above
Note: Make Sure port 7001 and 9704 are not in use or there was no previous version of OBIEE installed on your system, if so you have to uninstall previous version and clear all BI Publisher previous version files from Windows registry then follow installation steps in this post.
Downloads For OBIEE 11g:
- RUC ( Repository Creation Utility of Oracle ) 220.127.116.11.0 – 32 bit
Download it from oracle website. We must make sure that its version is compatible with OBIEE, also its 32 bit only not 64 bit (no matter your OS or DB is 32bit or 64bit )
- OBIEE ( Oracle Business Intelligence Enterprise Edition) 18.104.22.168.0 – 64 bit
Download it from here its license is free but you need it if you are using test or production environment.
Note: If your DB is 32 bit then OBIEE must be 32 bit or if DB is 64 bit then OBIEE must be 64 bit. Both must be 32 bit or 64 bit.
Installation Part 1 (Creating Schema for OBIEE through RUC):-
The RCU is simply the “Repository Creation Utility”. Simply put, the RCU lets you install certain schemas in a database that are required by Fusion Middleware products like Oracle BI EE. These schemas can be installed onto any certified version of database like Oracle Database, IBM DB2, or Microsoft SQL Server. There are schemas that are required by the core components of Oracle Fusion Middleware, while there are schemas that Oracle BI EE requires, like for the Scheduler, for BI Publisher, for the new Scorecard product.
Step 1: Unzip the downloaded RCU to a folder.
Step 2: Navigate to the rcuHome\BIN folder and run the rcu.bat file.
Step 3: Select “Create” from the option radio-button, and click “Next”.
Step 4: Here you can select an Oracle Database, or click the dropdown to select another database. I will use Oracle Database, obviously.
Host Name: Name or ip of database server
Port: It is by default 1521 provided by oracle for oracle database.
Services Name: Check the service name of your database in tnsname file and give it to service name field.
User name & Password: provide the User name & Password which has dba privileges.
Role: select Role depends upon the user you have given.
The below error can be ignored.
Reference : https://forums.oracle.com/forums/thread.jspa?threadID=2244561
Two metadata repositories are required:
- the Metadata Services (MDS)
- And Business Intelligence Platform (BIPLATFORM)
Select Metadata Services and Business Intelligence Platform only.
Component Detail ->Select the Oracle Business Intelligence Component. This action automatically selects the Metadata Services (MDS) schema (under the AS Common Schemas group), which is also required by Oracle Business Intelligence.
Schema Passwords -> Use Same Password for all schemas. I used sys as the password for both the schemas.
Step 9 :
Map Table space
After the schemas are created with no errors, the Completion Summary screen opens. In the Completion Summary screen, click Close.
Congratulations!!! Now you have metadata schema required for OBIEE installation.
Sort of a post-wrap exercise may be, for those so interested, to launch Oracle SQL Developer, and peek a look at what sort of tables are created by the RCU. If you choose to do so, this is what you would see.
The “ANNOT*” tables are used by the Scorecard product.
“QRTZ*” tables are used by BI Publisher, “CALC*”, “HSS*” by Essbase and Oracle Hyperion products.
Installation Part 2 (Installing OBIEE):-
After RCU we will go forward with installing OBIEE 11G.
Step 1: Extract the obiee11g setup. Run the installation setup from Disk 1.
The below screen appears. Follow the screen-shots given below.
Step 2: Select Enterprise install because it gives all options to customize.
Step 3: Follow the screen-shots given below.
Here we can specify a user name and password. Unlike OBIEE 10g where the user Administrator used to have all the administrative privileges, in OBIEE 11g we can specify the name of the user who will have Administrative rights. The user name will be weblogic by default. We can change it to any desired name.
The option Scale Out BI System will be used for vertical clustering which is not required here.
Step 5: Next step would be to give Oracle Middleware Home Location. Click Browse and select any location.
OBIEE11g will be installed into this location. The remaining fields will be populated automatically once you select the Middleware Home path.
I got the below error..no problem..click Yes if you get the same error…
Step 7: Just click Next and keep going…
Wow…now is the time you have to enter the name of the 2 RCU schemas DEV_BIPLATFORM and DEV_MDU we created earlier.
Also mention the connection string in this format
Note here I have used the port 1521.
Step 9: Use Option Auto Port Configuration.
Step 10: Just click Next and keep going…
Step 11: Click on Install and it will start installing OBIEE.
Step 12: Wait almost 2 hours…don’t put your laptop in sleep mode…
If you got an error…error is starting opmnctl coreapplication_obips1 failed…ignore this error…click next..
Hope you didn’t sleep 😀 ..it took around 3 hours for the OBIEE installation to complete on Windows 7 and less than an hour on Windows Server 2012 ( of course it have high specs ) .
Starting OBIEE Services and Using it Part 3 :-
Now we will try starting OBIEE and playing around with it.
Step1: Click Start BI Services
Note Perform this step only if you got this error:
Error in command line…unable to get file lock..
Note: You may got this error the first time you restart Weblogic …
Note: We got the above error because the file is locked. So we will have to go to the path and delete the lock file so that we can start the presentation services.
Navigate to the path : <OBIEE HOME>/C:\Middleware\user_projects\domains\bifoundation_domain\servers\AdminServer\tmp
and delete the “AdminServer.lok” file .
Wow..its done…now we can start enjoying OBIEE…
Type the following paths in your browser: