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

16 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. 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. obiee training in Hyderabad
    we are offering best Obiee online training with work support and job assistance and high quality training facilities and well expert faculty
    for other details and register your demo contact
    obiee online training
    Institute : Vguru Online Trainings
    Contact number: +91-9885681705
    Email Id: vguruonline@gmail.com

    ReplyDelete
  9. 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
  10. 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
  11. I am installing OBIEE 12c but getting errors as error insta 07545. Changed the directory still getting errors.
    Please guide.

    ReplyDelete
  12. @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