Tuesday, November 24, 2015

OBIEE 12c - Quick installation guide - Windows

OBIEE 12c has been released and here we bring a quick installation guide for those interested.

First of all, make sure you perform the installation in a certified platform. Take a look at the Certification Matrix:
http://www.oracle.com/technetwork/middleware/ias/downloads/fusion-certification-100350.html

Look for the link under:
"System Requirements and Supported Platforms for Oracle Fusion Middleware 12c (12.2.1)"
 
0. Review Certification Matrix.
    Minimum Oracle DB version : 11.2.0.4+
    Windows OS : 2012 / 2012 R2
    Even though the certification matrix does not list Windows 2008 I gave it a try and successfully  
     installed the software.

1. Gather the installation files from
http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/business-intelligence-2717951.html
So, it is very clear what we need for Windows installation:
  1. JDK 
  2. Weblogic Server12c
  3. BIEE 12c
  4. Configuration 
1. The installation of JDK is pretty straight forward, so nothing relevant to discuss.
    Just ensure you are using the recommended JDK version by issuing the following command:

C:\temp> java -version
java version "1.8.0_65"
Java(TM) SE Runtime Environment (build 1.8.0_65-b17)
Java HotSpot (TM) 64-Bit Server VM (build 25.65-b01, mixed mode)


2. Next, we proceed with the installation of WLS 12c. Invoke the WLS jar file by issuing the
   following command:

   C:\temp>"c:\Program Files\Java\jdk1.8.0_65\bin\java" -jar fmw_12.2.1.0.0_infrastructure.jar


Then just follow the Installer steps:








 This step is important not to overlook. I highly recommend to always check for possible patches (you will need an account with Oracle Support)


 The installer detected a patch to install 18994592








3. Installing OBIEE12c:
    Let's assume the OBIEE12c installation files have been placed in a temp directory and unzipped.
    Then it should look like this:

    Should you get error code =1 during the installation then please apply workaround indicated (here)


 Here again, we are given the opportunity for the installer to check for patches of this installation. So if you have an account with Oracle Support, proceed to enter the details


 Use the same Oracle_Home of the WLS12c installation:


Here, select the second option so you get the samples installed.






Warning: Be patient. The previous step may take a little while to complete.


3. Configuration:
    Well, so far OBIEE12c software has been installed but yet one final step is required: Configuration. For this purpose, go to Oracle_home\bi\bin and execute the file config.cmd
 



 This step will Add a new BI DOMAIN (Domain Name : bi) in Weblogic Server 12c


This step will create the OBIEE12c Metadata in the Oracle Database (typically performed by RCU)


Notice now the port range is 9500-9999


This will install SampleAppLite as demo application of OBIEE12c







 Here a summary of the new links:

        Components
           - Essbase
           - BIEE
               *  OBIPS (Port 9507)
               * Cluster controller (Main port 9508, monitor 9509)
               * Java host (Port 9510)
               * Scheduler (Main port 9511, monitor 9512, script 9513)
           - BIP
        Domain
            BI Domain Name: bi
            Domains Directory: C:\fusionMW\Oracle_Home\bi\bin\..\..\user_projects\domains
            Admin server (HTTP port 9500, HTTPS 9501, internal 9504)
            Managed server (HTTP port 9502, HTTPS 9503, internal 9505)
        Database
            New schemas
                Database type: ORACLE
                Connect string: biserver:1521:orcl
                New RCU prefix: DEV
        Port Management
            Port range
                Port range start: 9500
                Port range end: 9999
        Application
            SampleAppLite
            Service Instance Key: ssi
            Service Instance Limit: 1
    Entry points
        BI Analytics:                            http://biserver:9502/analytics
        BI Publisher:                             http://biserver:9502/xmlpserver
        WebLogic Console:                  http://biserver:9500/console
        Fusion Middleware Control:    http://biserver:9500/em

3 comments:

  1. hi! did you experience any issues running OBIEE 12c on Windows 2008?

    ReplyDelete
  2. I cant use OBIEE client tools, because the driver wouldnt work on Windows server 2008

    ReplyDelete
  3. i have the below error bi service not start
    ------------------ obis1.out --------------
    Jun 24, 2018 9:14:13 AM PDT>










    ----------------------------- AdminServer.out ---------------------




    ------------------------------- nodemanager.log ------------




    ------------------ bi_server1.log---------------

    XML-24538: (Error) Can not find definition for element 'beans'>


    #### <[ACTIVE] ExecuteThread: '31' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <1529911079857> <[severity-value: 16] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <[ACTIVE] ExecuteThread: '31' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <1529911079889> <[severity-value: 8] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > ] [ecid: cb1a9742-152d-4773-83cb-41c78d92b2c0-0000000a,0:32160] [APP: bisearch] [partition-name: DOMAIN] [tenant-name: GLOBAL] Failed to start crawl with exception: [[
    oracle.biee.search.security.BIPSSoapSessionException: Failed to create BIPSSoapSession object


    Caused by: javax.xml.ws.ProtocolException: java.net.ConnectException: Connection refused: connect

    Caused by: java.net.ConnectException: Connection refused: connect

    ReplyDelete