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 11.1.1.9 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
- Configuration
I downloaded JDK 8, Weblogic server and 2 BI files from here. After unzipping them I had the following:
I installed the JDK. It's better not to accept the default of installing in "Program Files\Java" folder because of the space in the name. I installed it in c:\Java.
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_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 I 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).
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:
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) :
******************************************
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:
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.
Migration:
After the installation, the natural step is to upgrade your existing OBIEE 11 to 12. It should be done from 11.1.1.7 latest patches or 11.1.1.9 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)
Hey Boris,
ReplyDeleteDo you have 11g or 12c db installed?
My DB is 12c. According to the support matrix DB versions are: 12.1.0.1+; 11.2.0.4+
DeleteOk. I'll install on a server i have here and see how it all behaves with BI APPS rpd and catalog.
Deleteshould be interesting
Hi! Tahnk you for your post, it's really useful. I just can't finish my installation though.. After running the config.cmd and setting all the info about my db, when the installation starts Creating schemas using RCU it just fails everytime, saying:
ReplyDelete"oracle.bi.exec.ExecutionStatusException: Execution of [cmd, /c, C:\Oracle\Middleware\Oracle_Home\bi\bin\..\..\oracle_common\bin\rcu.bat, -silent, -createRepository, -useSamePasswordForAllSchemaUsers, true, -databaseType, ORACLE, -connectString, localhost:1521/orcldb.obi12, -dbUser, sys, -dbRole, sysdba, -selectDependentsForComponents, true, -schemaPrefix, rcu12, -component, WLS, -component, MDS, -component, OPSS, -component, STB, -component, BIPLATFORM] failed with exit value 1"
I tried reinstalling odb12, with different databases but I can't fix it, do you have any idea of why could it be failing??
Thank you in advance
Try separating the RCU step from the general configuration as described in the above mentioned post by Leela Madhav.
DeleteYou are trying to connect to the CDB and not to the PDB.
Deleteyou need to provide the pluggable database connection string as the schema is installed on it.
Same error. Any solution guys? Tried the PDB didn't work. Same error as well when creating the schemas from the RCU
DeleteI'm just guessing, is your DB UTF8? Is it 12 multi tenant?
DeleteI am facing exactly the same issue and tried with PDB "2015-11-08T02:08:36.365-06:00] [bi] [ERROR] [] [oracle.bi.install.config.actions] [tid: 39] [ecid: 0000L3a8ubcFw0WVLyyGOA1MFk4V000004,0] Non-skipped failure during configuration action: Execution of [cmd, /c, D:\Installations\Oracle\Middleware\Oracle_Home\bi\bin\..\..\oracle_common\bin\rcu.bat, -silent, -createRepository, -useSamePasswordForAllSchemaUsers, true, -databaseType, ORACLE, -connectString, localhost:1521/BI, -dbUser, SYS, -dbRole, sysdba, -selectDependentsForComponents, true, -schemaPrefix, RCU12, -component, WLS, -component, MDS, -component, OPSS, -component, STB, -component, BIPLATFORM] failed with exit value 1".. Any suggestions plz
DeleteI just gave different password for the new schema to be created by RCU which was all numbers before to an alphanumeric and it fixed this issue
DeleteIm also having the same problem and i have tried everything listed above but im still getting that error. Any other suggestions?
DeleteGuys , Any solution on this issue?
Deleteare you guys able to install OBIEE client?? I faced issues while installing client..
ReplyDeleteInstalled with no issues. make sure you have java X64 installed
DeleteHi,while installing setup_bi_platform-12.2.1.0_win64.exe cleanup window popping up and then nothing happened
ReplyDeletesupport.oracle.com?
DeleteI have the same ISSUE ... Unable to Install
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteHello,
ReplyDeletePlease let me know, DB 12c and OBIEE 12c (OTN) on platform win 2012 server 64 bit is certified?
Yes, see the http://www.oracle.com/technetwork/middleware/ias/downloads/fusion-certification-100350.html linked at the beginning of this post.
DeleteI am stuck with the below error in the "Store port Range" step; Error "Config Action BI failed with cannot load EndPoint Manager:java.lang.RuntimeException:BI Product Home must be specified in sys properties: oracle.bi.home.dir or variable BI_PRODUCT_HOME " Please advice.
ReplyDeleteAdd new system variable BI_PRODUCT_HOME and set its value Oracle_Home directory(ex : C:\Oracle\Middleware\Oracle_Home)
DeleteIt should be C:\Oracle\Middleware\Oracle_Home\bi
DeleteI am also facing the same issue while installing OBIEE 12c on windows 10 Home edition. OBIEE 12c deployment is stuck at RCU creation step with same error message as shown above. I tried Oracle databse 11gR2 and 12c both for RCU creation, tried all numbers and all alpha passwords for RCU schemas but same issue. Did anyone got any success in complete installation of obiee 12c on WINDOWS 10 Home?
Deletei am also facing same problem. did you able to install?? plss let me know
DeleteI am facing the below error while executing the OBIEE 12c configuration assistant Step name "Add default service instance" Error: "[2015-11-08T10:58:54.199-06:00] [bi] [ERROR] [] [oracle.bi.bar.si.framework.handler.JaznServiceInstanceHandler] [tid: 38] [ecid: 0000L3c06jxFw0WVLyyGOA1MFrki000004,0] Failed in migrateing policy store from stripe obi to file D:\Installations\Oracle\Middleware\Oracle_Home\user_projects\domains\BI12\bidata\service_instances\ssi\tmp\backupImportBar\authmodel\backup\jazn-data.xml
ReplyDelete[2015-11-08T10:58:54.199-06:00] [bi] [ERROR] [] [oracle.bi.bar.si.framework.ServiceInstanceFrameWorkImpl] [tid: 38] [ecid: 0000L3c06jxFw0WVLyyGOA1MFrki000004,0] Error during import service instanceoracle.bi.bar.si.exception.ServiceInstanceLifeCycleException: Failed in migrateing policy store from stripe obi to file D:\Installations\Oracle\Middleware\Oracle_Home\user_projects\domains\BI12\bidata\service_instances\ssi\tmp\backupImportBar\authmodel\backup\jazn-data.xml
[2015-11-08T10:58:54.199-06:00] [bi] [ERROR] [BAR-00010] [oracle.bi.bar.si.ServiceInstanceLifeCycleImpl] [tid: 38] [ecid: 0000L3c06jxFw0WVLyyGOA1MFrki000004,0] Failed in running all the handlers during backing up of service instance.
[2015-11-08T10:58:54.199-06:00] [bi] [ERROR] [] [oracle.bi.servicelcm.BIServiceInstanceManager] [tid: 38] [ecid: 0000L3c06jxFw0WVLyyGOA1MFrki000004,0] problem encountered whilst creating SI with key: ssi[[
java.lang.RuntimeException: oracle.bi.bar.si.exception.ServiceInstanceLifeCycleException: Failed in running all the handlers during backing up of service instance."
Its creating the directory ssi and then the directory is gone. Please suggest
Hey any solution on the previous Post? I am stuck at the same step .. Add default Service instance
DeleteI am stuck with the same issue too.
DeleteAny leads from this . Im stuck with the same step
DeleteHas anyone come up with a solution to this yet. Oracle has been no help whatsoever.
DeleteLook at this thread: https://community.oracle.com/thread/3825092?start=0&tstart=0, try last solution.
DeleteThis comment has been removed by the author.
ReplyDeleteFor the original error, to fix what I did was to reinstall my Oracle 12c database without the PDB. After this it worked. Not sure if its the best practice but worked for me and I was able to install without issues
ReplyDeleteI'm facing a strange issue. At the end of the configuration while the BI components were getting started, I received errors saying "nqsserver.exe stopped working". Installation was completed successfully though. But the Presentation server is not coming up. All the other services are showing alive. When I try to start the PS manually, I receive the same errors "nqserver.exe stopped working" and the BI Server also goes down automatically. Any thoughts on this please?
ReplyDeleteIf you've got EPM installed on the same server you might be getting the same issue as I had: http://hyperion-epm-bi.blogspot.co.uk/2015/12/obiee-12c-oracle-business-intelligence.html
DeleteGreat blog btw Boris!
DeleteThis comment has been removed by the author.
DeleteThe problem is not EPM specific. I had a case when OBIEE 1.1.1.7 installation caused the problem. Just cleaning the path and minimizing it might solve the problem.
DeleteThanks for the help Guillaume and Boris, your solution worked for me.
DeleteHey Guillaume, I would like to create a post in my blog about this issue if you are Ok with that? Please let me know. Thanks.
DeleteSiva, I am facing the similar issue can you please guide me when you did to solve this problem ?
DeleteThis comment has been removed by the author.
DeleteHello,
ReplyDeleteI've this issue in the end of the installation.
firma con problemas:
Nombre del evento de problema: APPCRASH
Nombre de la aplicación: sawserver.exe
Versión de la aplicación: 12.2.1.0
Marca de tiempo de la aplicación: 5616f0d2
Nombre del módulo con errores: nqutilitygeneric64.dll
Versión del módulo con errores: 12.2.1.0
Marca de tiempo del módulo con errores: 561bbb0c
Código de excepción: c0000005
Desplazamiento de excepción: 000000000008fbe7
Versión del sistema operativo: 6.1.7601.2.1.0.274.10
Id. de configuración regional: 3082
Información adicional 1: 09eb
Información adicional 2: 09ebc4aec07f984362012e2d6dd49e58
Información adicional 3: 03f2
Información adicional 4: 03f2a6671544484638066c3f7daeff7b
Lea nuestra declaración de privacidad en lÃnea:
http://go.microsoft.com/fwlink/?linkid=104288&clcid=0x0c0a
Si la declaración de privacidad en lÃnea no está disponible, lea la declaración de privacidad sin conexión:
C:\Windows\system32\es-ES\erofflps.txt
A windows pop-up comes up with opcions "solution online (or something like that) or close process (something like that too).
Somebody knows something about that?
Configure BI Failed with Execution of [cmd, /c, D:\Oracle_Data_Integrator\Middleware\bi\bin\..\..\oracle_common\common\bin\wlst.cmd, D:\Oracle_Data_Integrator\Middleware\bi\bin\..\..\bi\modules\oracle.bi.configassistant\create_base_domain.py, D:\Oracle_Data_Integrator\Middleware\bi\bin\..\..\user_projects\domains\bixe, root, true, 9500, 9501, 9506, 1000-PC] failed with exit value 1
ReplyDeleteI got this error during configuration, Can any one help me to resolve this problem
This is probably caused by spaces in the environment variables JAVA_HOME and Path. Java should be installed in the directory without spaces.
DeleteI am also getting the same error. There are spaces env variables.
DeleteI've attempted to install OBIEE 12c on my Windows 7 box several times now and no matter what I do I get the same error as many people above (most recently Akhil Agarwal on Jan. 31, 2016). I've given up.
ReplyDeleteI've attempted to install OBIEE 12c on my Windows 7 box several times now and no matter what I do I get the same error as many people above (most recently Akhil Agarwal on Jan. 31, 2016). I've given up.
ReplyDeleteKurt Wolff? I'm honored. seriously.
DeleteAs you know, there are many factors that could cause such a problem and it's extremely hard to try and analyze without logs (and often with them).
The first thing that comes to mind is the RCU database. that is why I advised to do this step separately, as the Wizard suggests.
When having problems at the RCU stage they could be several reasons:
If it's Oracle DB it should be at least 11.2.0.4. If it's 12 and multi-tenant DB, read note 2075762.1. UTF8 Character set might be a good idea.
If you still prefer Microsoft SQL Server it should be 2012. With multilingual option (as in OBIEE 11).
In case it's not RCU related, other problems might be because of system variables of your Windows 7 (assuming your Windows is 64 bit Windows 7 Professional SP1, if not, forget about the installation).
There are often tons of "garbage" in Windows Environment that might interfere with the installation in the path, Oracle_Home and Java_Home definitions in the Environment. For example I always had problems with OBIEE server combined with Apple QuickTime.
A workaround for this sort of problem is the tip mentioned above (in the post itself) by Guillaume Slee, of cleaning the Path (and maybe other variables) but not for starting, but rather running the configuration itself in a Command Window (as Administrator?).
Since Windows 7 if formally not supported, opening SR is a gamble.
If all else fails, there is always: http://www.oracle.com/technetwork/middleware/bi-foundation/obiee-samples-167534.html
Regards,
Boris
How to restart the failed configuration? I got the error at " Store port Range" while configuring and I am applying the fix suggested to create a environment variable. But do we have to begin all over again? Choose a new domain name etc?
ReplyDeleteIn similar situation I selected "bi1" instead of the default "bi" and there were no problems later.
DeleteWhatever you have uploaded for the RPD (metadata repository), it's not valid, and that's why the BI Server keeps crashing.
ReplyDeleteYou can't use data-model-cmd.cmd to upload a new repository... that only works if the BI Server is running. You'll need to reimport a BAR file, which will work while the BI Server is down. If you have not yet created a BAR file with your own content, reimport the SampleAppLite BAR File.
Use WLST to import the SampleAppLite.bar file (ORACLE_HOME/bi/bifoundation/samples/sampleapplite/SampleAppLite.bar), do a stop.sh/stop.cmd and a start.sh/start.cmd, and it should show up.
Sample WLST:
importServiceInstance(
'/app/oracle/obiee_1/user_projects/domains/bi','ssi',
'ORACLE_HOME/bi/bifoundation/samples/sampleapplite/SampleAppLite.bar'
)
I got the link
ReplyDeletehttps://community.oracle.com/thread/3825092?start=0&tstart=0
and followed the last advice and it worked for me.
Basically you have set environment variable as
_JAVA_OPTIONS
-Xms1548m -Xmx2048m
Hi,
ReplyDeleteI am stuck with bi startup, starting all servers, not completed,
I am started this in manually then bi publisher not working, some times gets oracle business intelligence has stopped working,
How to resolve these startup problem,
Please replay me,
Thanks,
Greetings! Very useful advice in this particular
ReplyDeletearticle! It is the little changes that will make the largest
changes. Many thanks for sharing!
Hi There,
ReplyDeleteI have just installed OVR and I am missing COMPONENT folder...
Any clue...
Thanks,
Aniket Pawar
Invalid argument(s): Sachdeva\AppData\Local\Temp\oraparam-ini-19772.tmp
ReplyDeleteI'm getting this error while running config.cmd file as administration i've set the JAVA_HOME path as C:\Program Files\Java\jdk1.8.0_201 ... This is the stage where The Oracle Business Intelligence 12C Configuration Assistant opens up on the screen. Can anyone help me in this??