I wanted to install the new OBIEE 12.2.1 on my Windows 7 box. Since I want to test the process of migration of OBIEE 11 to 12, I installed it side by side with my existing 18.104.22.168 installation.
If you want to see Linux installation description, you can see Andrew's post here. My installation seems to be smoother then his, despite the fact that Windows 7 doesn't seem to be supported according to the certification matrix (12.2.1 one).
The installation is of 4 steps:
- JDK installation (if needed)
- Weblogic Server installation
- BI Installation
I downloaded JDK 8, Weblogic server and 2 BI files from here. After unzipping them I had the following:
Next I opened a 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_22.214.171.124.0_infrastructure.jar
Accepted the defaults and pointed it to a new MWHOME I created (D:\MWHOME12, in my case).
Next I run the BI installation in the same folder:
And selected the same MWHOME for BI installation (D:\MWHOME12, in my case).
Here are the next screens:
Now I can run the configuration part.
I used the same Command Prompt Window, and run config.cmd from MWHOME\bi\bin
I left the default, including Essbase (note the RTD installation is gone).
passed the prerequests:
Didn't change the location, but selected the domain user and password:
and updated the DB connection details (note, no need to add "as SYSDBA" for Oracle sys user) :
******************************************To be on the safe side, you might prefer to run the RCU separately. The RCU utility is located, in my case at MWHOME\oracle_common\bin.
The new version of RCU allows us to create a script to be used later by DBA, as well.
After you finish the with the RCU, the screen is a bit different:
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 didn't save the URLs before. Do it now:
The OBIEE didn't start on it's own.
It is working:
I don't know if this should be so or it's because I have a previous entry of "Oracle Business Intelligence" in the "All Programs" menu, but nothing was added there.
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 in my case).
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, in my case.
One first discovery I had after the installation. Since OBIEE 12 is pure HTML, we can copy/paste data from analysis, in all browsers I tested:
One more similar post: http://ssssupport.blogspot.co.il/2015/10/installing-oracle-obiee-12c-in-windows.html. Leela Madhav preferred to set up RCU separately.
And another by Srinivas Malyala: OBIEE12c installation on windows7 machine
To the best of my knowledge the RCU should be installed on UTF8 type DB. Deliver BI try to work around it in OBIEE 12 RCU Avoid Hardstop Pre Reqs for AL32UTF8 Database Char Set.
If you are installing RCU on Multi-Tenant Oracle DB, please read before installation:
OBIEE 12c FAQ: Does OBIEE 12c (12.2.1) Support A Multi-Tenant Oracle Database For The RCU Schemas? (Doc ID 2077802.1)
If your installation was successful but OBIEE failed to start please read OBIEE 12c: Oracle Business Intelligence has stopped working by Guillaume Slee (
hyperion-epm-bi.blogspot.com) and his great advise of reducing the PATH to eliminate possible contradictions.
After the installation, the natural step is to upgrade your existing OBIEE 11 to 12. It should be done from 126.96.36.199 latest patches or 188.8.131.52 and described in the post Migrating from Oracle BI 11g to 12c by Shahed Munir.
And at allthingsorcl.blogspot.com here by @KeitaFK.
The Oracle migration guide is here.
Note the following from Oracle Support: OBIEE 12c Pre-Upgrade Alert: Before Upgrading To 12c, Ensure your 11g Catalog Is Upgraded To the Correct Version (Doc ID 2068965.1)