Tuesday, December 24, 2013

In-place upgrade OBIEE 11.1.1.6.0 to 11.1.1.7.0

Requirement:

 Upgrade OBIEE 11.1.1.6.0 to 11.1.1.7.0 in Linux
High level Steps:

 It includes 3 high level steps mainly

 1. OBIEE S/W upgrade
2. Upgrade repository schemas
3. Upgrade domain
Steps in detail:

 1. Pre-Upgrade Steps

 Stop all the BI components (AdminServer, Managed Server, opmn components and Nodemanager)

 Take a backup of MW Home and Inventory

 2. OBIEE S/W Upgrade

 Download OBIEE 11.1.1.7.0 for the platform

 Invoke runInstaller

 Intallation Type Screen: Choose Software Only Install

 Intallation Location Screen:The installer would automatically choose the current MW and BI installation directories.

 Click Intall

 3. Upgrade MDS and BIPLATFORM schemas using Patch Set Assistant (psa)

 psa is available in $MW_HOME/oracle_common/bin

 Invoke psa (./psa)

 Select Component Screen: Choose only "Oracle Bussiness Intelligence". Both BIPLATFORM and MDS schema would be selected by default

 Prerequisites Screen: Select both prerequisite check boxes 1. backup completed and 2. DB version certified by FMW upgrade

 MDS Schema Screen: Give DB connection information and DB user "SYS as sysdba" and press "Connect" button
Give MDS and BIPLATFORM username and password.

 Examine Screen: The status of the examination process would be shown in next page. Both status should be of status "Succeeded".
Click Upgrade button

 4. Start nodemanager and AdminServer

 Start nodemanager and Admin server. This is mandatory since during domain updation both Admin server and bi server has to be retsrated by the configuration utility.
5. Domain Upgrade using config utility

 Invoke configuration utility from $MW_HOME/Oracle_BI1/bin folder

 ./config.sh

 Create, Scale out or Extend Screen: Choose Update BI Domain option
Provide the Adminserver hostname, port number and user details

 Update BI Domain Details Screen: Verify that all the paths chosen by the installer are accurate.

 Click configure and Press Finish button when done

 The Configuration Assistant will restart AdminServer and start the managed server, and OPMN components.

 Verify that all the URLs are reachable and all components are up.

Posted by at

12 comments:

  1. AnonymousJune 24, 2014 at 5:23 PM

    You have no where mention whether existing services need to started or in off state???

    ReplyDelete
  2. Satish V ChandranJune 26, 2014 at 5:57 AM

    It is mandatory to stop all the components running from the MW Home. Thanks for pointing it out. I have added that as a pre requisite.

    ReplyDelete
  3. SairamAugust 26, 2014 at 9:21 PM

    Hi Satish,
    Thanks for posting the information about upgrade.
    The below are the installers mentioned in the link http://docs.oracle.com/cd/E28280_01/doc.1111/e16793/patch_set_installer.htm#PATCH805.
    Do we need to repeat the Step -2 in your steps given above, for each installer..?
    Oracle Application Developer Runtime
    Oracle SOA Suite
    Oracle Service Bus
    Oracle WebCenter Portal
    Oracle WebCenter Content
    Oracle Identity Management
    Oracle Web Tier
    Oracle Data Integrator
    Oracle Application Integration Architecture Foundation Pack

    ReplyDelete
  4. Satish V ChandranAugust 27, 2014 at 12:51 PM

    Hi Sairam,
    Do you have all the above components under the same Oracle fusion Middleware Home? Each of them are independent products. So you should patch only the components installed in your machine.

    ReplyDelete
    Replies
    1. SairamAugust 27, 2014 at 1:56 PM

      Okay. Actually i am in confusion about the software files exactly what to be considered for installation. Can we consider the total OBIEE software dump for version 11.1.1.7.0 for upgrade..? Can you please suggest the exact files details for installation, that would be more helpful to me.

      Thanks,
      Sairam.

      Delete
    2. Satish V ChandranAugust 27, 2014 at 4:09 PM

      Hi Sai,

      For eg: if you are upgrading to OBIEE 11.1.1.7, you can download the right version from edelivery or otn. It is the same software used for both fresh installation and upgrades. OBIEE installers are generally a set of 5 files and you have to download and extract all those 5 files. Then follow the step mentioned here for upgrade.

      Delete
    3. SairamAugust 27, 2014 at 6:52 PM

      Thanks for the answer. In one of blog i read about weblogic upgrade to 10.3.6, it is with a patch number 13529623. You have not mentioned about this upgrade in your blog, and also the feed back about hte path at OTN is not good. Is it good to upgrade the WLS to 10.3.6 for 11.1.1.7.0 upgrade.?

      Delete
    4. Satish V ChandranAugust 27, 2014 at 8:23 PM

      Hi Sai,

      The WLS upgrade is also mentioned in the blog, URL: http://satishvchandran.blogspot.in/2013/12/weblogic-1035-to-1036-in-place-upgrade.html

      It is not mandatory to upgrade WLS to 10.3.6 for OBIEE 11.1.1.7.0 as it is certified with both 10.3.5 and 10.3.6 versions of weblogic. But if required, you can patch WLS first.

      Delete
    5. SairamAugust 27, 2014 at 8:54 PM

      Thank you so much

      Delete
    6. SairamAugust 29, 2014 at 2:03 PM

      Hi Satish,

      When we try to install using ./runinstaller, it is giving errors for display related. Any suggestions to resolve this error.. Thanks,

      $ ./runInstaller
      Starting Oracle Universal Installer...

      Checking Temp space: must be greater than 1536 MB. Actual 2206 MB Passed
      Checking swap space: must be greater than 500 MB. Actual 10240 MB Passed
      Checking monitor: must be configured to display at least 256 colors
      >>> Could not execute auto check for display colors using command /usr/bin/X11/xdpyinfo. Check if the DISPLAY variable is set. Failed <<<<

      Some requirement checks failed. You must fulfill these requirements before

      continuing with the installation,

      Delete
    7. SairamSeptember 1, 2014 at 7:18 PM

      Hi, Able to resolve the above error by installing Reflection X software.. thanks.

      Delete
  5. AnonymousSeptember 18, 2014 at 1:34 PM

    Hi Satish,

    I tried to upgrade from 11.1.1.6.12 to 11.1.1.7.0 as explained above in my DEV environment.
    I am getting error at configuration Assistant.
    It is failing to restart services using opmnctl. When i tried to restart manually using opmnctl i found two ias-components are failing. Those are
    coreapplication_obips1 and coreapplication_obis1.
    The error message as per nqsserver.log is
    [nQSError: 26013] File /app/oracle/MW/instances/instance1/config/OracleBIServerComponent/coreapplication_obis1/NQSConfig.INI Near Line 148, near : Syntax error.

    and as per log file in 'OracleBIPresentationServicesComponent' and file name ('console~coreapplication_obips1~1.log') is
    Could not load program /app/oracle/MW/Oracle_BI1/bifoundation/web/bin/sawserver:
    Symbol resolution failed for /app/oracle/MW/Oracle_BI1/bifoundation/web/bin/libsawbedrock643r.so

    Thanks,
    Sairam.

    ReplyDelete

Subscribe to: Post Comments (Atom)