Google Analytics Alternative All Things Oracle Business Intelligence and more: OBIEE 12c installation steps

Friday, October 23, 2015

OBIEE 12c installation steps

As you probably already know from the blogosphere and twitter, Oracle released OBIEE12c today right before OOW15. This is a quick post to document the software installation in Windows 7 . The software is available on OTN:

http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/business-intelligence-2717951.html

As indicated on the OTN download page, the installation order is following:

A. Download and install JDK 1.8 from this link, the current release is JDK-8u65

B. Download and install the Web Logic server; installation will be covered in this post

  • fmw_12.2.1.0.0_infrastructure_Disk1_1of1.zip

C. Download and install Oracle Business Intelligence 12c (12.2.1.0.0) consisting of 2 zip file

  • fmw_12.2.1.0.0_bi_windows64_Disk1_1of2.zip
  • fmw_12.2.1.0.0_bi_windows64_Disk1_2of2.zip

D. Download and Install Oracle Business Intelligence Developer Client Tool (12.2.1.0.0) for LINUX installations.

Install Fusion Middleware 12c Infrastructure

this can be accomplished in Windows from the command prompt by issuing:

a. Java –jar fmw_12.2.1.0.0_infrastructure.jar

infra1

  infra2

infra3

Search for Fusion Middleware patches

infra5

infra7

infra8

infra9

infra10

infra11

infra12

infra13

infra14

 

2. Step 2: unzip the two zip file, you should end up with one executable and a folder named Disk2

clip_image001

Install OBIEE 12c by running the setup executable 

Following are few screen shots, one thing to note is that the installation has been simplified; in this release, one type of installation is available: Enterprise installation. Another major departure from 11g is the deprecation of the OPMN service.

screen1

Specify the previously created Oracle_Home

install1

install3

install4

install5

install6

nstall7

install8

install9

nstall10

Configure OBIEE 12c

Navigate to Oracle_Home/bi/bin

and run the configuration script: config.cmd in Windows.

config2

config3

config4

Create the BIPLATFORM schemas, the simplest option is to create new schemas on the fly; one can also using existing schemas created with the RCU.In 12c, the RCU is located in [ORACLE_HOME]\oracle_common\bin

config5

 

Specify the applications port range

config7

Specify that to install: sample application, existing BI application or a clean slate.

config8

Confirmation window

config9

The configuration process starts; there are fewer steps than in 11g and the process runs much faster. One thing to note is that the “Retry” and “Continue” buttons are not available; in OBIEE 12c, the configuration steps cannot be retried. In the event of a failure, one will have to go through the process again (run RCU, clean up domain directory [ORACLE_HOME]/user_projects/domains/bi similar to the 11g Software Only installation and run the configuration steps.

 

config10

config11

As mentioned previously, the configuration steps run much faster; once it reaches 100%, there is particular step (Start All Servers)  that take a relatively long time;

config12

if all goes well

config13

config14

One thing to note at least on 2 similar Windows installation is that the “Oracle Business Intelligence Enterprise Edition” folder that we are accustomed to is not created in the “Program Folder”.

Here is the new exciting OBIEE 12c home page (technically the Oracle Visual Analyzer is the new home page), cleaner user interface based on Oracle Alta UI and dare I say Tableau-like!

homepage

 

With the changes introduced by the new OBIEE 12c version, certain paths have changed; following are new path details:

OBIEE new path to executables and scripts

Start|Stop|Status scripts

[ORACLE_HOME]/user_projects/domains/bi/bitools/bin - stop.sh | start.cmd | start.cmd |status.cmd

startstop

 

[ORACLE_HOME]/bi/lib/bi-bar.jar (CreateBIArchive java executable)

[ORACLE_HOME]/bi/bifoundation/server/bin/

[ORACLE_HOME]/bi/migration-tool/jlib/bi-migration-tool.jar  OBI11g to OBIEE12c migration tool.

OBI Server, Scheduler , ClusterController executables

executables

Catalog manager

[ORACLE_HOME]/user_projects/domains/bi/bitools/bin/runcat.sh

catalog

Javahost

[ORACLE_HOME]/bi/modules/oracle.bi.cam.obijh/startOBIJH.cmd

javahost

Java applications (xmlpserver.ear, analytics.ear etc…)

[ORACLE_HOME]/bi/bifoundation/jee/

BI presentation service executable

[ORACLE_HOME]/bi/bifoundation/web/bin/ sawserver

Repository file and web catalog

[ORACLE_HOME]/user_projects/domains/bi/bidata/service_instances/ssi/metadata

rpd and webcat

Log files

  • [ORACLE_HOME]/user_projects/domains/bi/servers/obis1/logs/

logfiles

Weblogic

  • Administration Server: [ORACLE_HOME]/user_projects/domains/bi/servers
  • Managed Server: [ORACLE_HOME]/user_projects/domains/bi/servers

System Components

  • OBI Server: [ORACLE_HOME]/user_projects/domains/bi/servers/obis1/logs Presentation Server: [ORACLE_HOME]/user_projects/domains/bi/servers/obips1/logs
  • Catalog Manager: /ORACLE_HOME]/user_projects/domains/bi/servers/obips1/logs/catalogmanager
    • Scheduler: [ORACLE_HOME]/user_projects/domains/bi/servers/obisch1/logs
    • JavaHost: [ORACLE_HOME]/user_projects/domains/bi/servers/obijh1/logs
    • ClusterController: [ORACLE_HOME]/user_projects/domains/bi/servers/obiccs1/logs

37 comments:

  1. if this installation is being done on windows, do you still need to set a static IP address and modify the Host file?

    ReplyDelete
    Replies
    1. even obiee11g on windows 8 , not need static IP , for obiee12c i do not know ...

      Delete
    2. Hi, Great.. Tutorial is just awesome..It is really helpful for a newbie like me.. I am a regular follower of your blog. Really very informative post you shared here. Kindly keep blogging. If anyone wants to become a Front end developer Node js Training in Chennai . learn from or Javascript Online Training from India. Nowadays JavaScript has tons of job opportunities on various vertical industry. JavaScript Training in Chennai

      Delete
  2. Thank you very much, it helped very much in installing the new 12c version.
    Now i want to install odi12c in the same weblogic server.Please send me the steps.

    ReplyDelete
  3. This comment has been removed by the author.

    ReplyDelete
  4. i install OBIEE c12 but found error in configuration not complete

    ReplyDelete
  5. Thanks, this made installing OBIEE 12c a lot easier, i had two issues
    1) I removed al installed java components and installed the latest version
    2) I used the rcu for creating the schema's, using a little xe database, it's just for testting

    ReplyDelete
  6. I'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?

    ReplyDelete
    Replies
    1. If you have already installed EPM on the same machine then you need to uninstall it. Hope it helps

      Delete
    2. If you have already installed EPM on the same machine then you need to uninstall it. Hope it helps

      Delete
    3. i am facing same issue... my services were up for sometime.. and then they stopped... now.. presentation services.. for obiee12c.. not gettingup.. please help.

      Delete
  7. I am implementing OBIEE 12c with all the component OBIA 12c,ODI 12c inetgrating it with Oracle ebusiness suite R12 but I can't see the obiee12c configuration manager ? Where is it located in this version ?

    ReplyDelete
  8. Thank you for the instructions. I try to run Java –jar fmw_12.2.1.0.0_infrastructure.jar but with error "Error: Could not find or load main class ?jar". How to fix it with cmd? Thank you.

    ReplyDelete
  9. This is my first time visit here. From the tons of comments on your articles,I guess I am not only one having all the enjoyment right here!
    Successful Businesses

    ReplyDelete
  10. I am installing OBIEE 12c but getting errors as error insta 07545. Changed the directory still getting errors.
    Please guide.

    ReplyDelete
  11. @David - Please check if you are able to run the commands 'java' and 'javac' in cmd without any error. If there is no error, then go ahead and instead of copy pasting the jar command to run in cmd, type it manually (java –jar fmw_12.2.1.0.0_infrastructure.jar) and run. Hope it will resolve your issue.

    ReplyDelete
  12. A blend mind and crucial words. Exactly what I was scanning for.
    loja magento

    ReplyDelete
  13. Thank you for taking the time to provide us with your valuable information. We strive to provide our candidates with excellent care and we take your comments to heart.As always, we appreciate your confidence and trust in us
    Devops Training courses
    Devops Training in Bangalore
    Best Devops Training in pune
    Microsoft azure training in Bangalore

    ReplyDelete
  14. I was recommended this web site by means of my cousin.
    I am now not certain whether this post is written through him as nobody else recognise such precise about my difficulty. You're amazing! Thank you!


    selenium training in Tambaram
    selenium training in Velachery
    selenium training in Omr
    selenium training in Annanagar
    selenium training in Chennai

    ReplyDelete
  15. I was recommended this web site by means of my cousin.
    I am now not certain whether this post is written through him as nobody else recognise such precise about my difficulty. You're amazing! Thank you!


    selenium training in Tambaram
    selenium training in Velachery
    selenium training in Omr
    selenium training in Annanagar
    selenium training in Chennai

    ReplyDelete
  16. Needed to compose you a very little word to thank you yet again regarding the nice suggestions you’ve contributed here.
    python training in chennai
    Python Online training in usa
    python course institute in chennai

    ReplyDelete
  17. Great thoughts you got there, believe I may possibly try just some of it throughout my daily life.
    python training in chennai
    Python Online training in usa
    python course institute in chennai

    ReplyDelete
  18. Awesome! Education is the extreme motivation that open the new doors of data and material. So we always need to study around the things and the new part of educations with that we are not mindful.
    Devops Training in Chennai | Devops Training Institute in Chennai

    ReplyDelete
  19. Thank you for sharing. This article is very helpful and Inspirational. Excellent!
    Devops Training in Chennai | Devops Training Institute in Chennai

    ReplyDelete
  20. No one can stop you writing a perfect blog or article if you are passionate to your job. Your aim is to satisfy your readers with a well written blog and your passion is always behind your every successful assignment. Impressive writing skills can be observed over here.
    Dell PowerVault MD1400

    ReplyDelete
  21. Thank you for sharing valuable information.This article is very useful for me valuable info about
    OBIEE Online Training
    OBIEE Training
    OBIEE Online Course .keep updating.........

    ReplyDelete
  22. This comment has been removed by the author.

    ReplyDelete
  23. Existing without the answers to the difficulties you’ve sorted out through this guide is a critical case, as well as the kind which could have badly affected my entire career if I had not discovered your website.
    Best PHP Training Institute in Chennai|PHP Course in chennai

    Best .Net Training Institute in Chennai
    Powerbi Training in Chennai
    R Programming Training in Chennai
    Javascript Training in Chennai

    ReplyDelete
  24. Great idea its very informative and keep sharing the update information Surya Informatics

    ReplyDelete
  25. Thanks! I can understand your effort and experimentation on BI. I've saved my time by visiting your blog very informative and I learnt a lot about the BI related command line utilities. I will apply these on OAS will post on my blog : https://myofmwexperiments.blogspot.com/

    ReplyDelete