Monday, May 27, 2013

OBIEE upgrade 11.1.1.6.0 to 11.1.1.6.9

The Oracle Business Intelligence 11.1.1.6.9 Patchset

Today am going to show you how to upgrade 11.1.1.6.0 to 11.1.1.6.9 upgrade.
This patchset is available for all customers who are using Oracle Business Intelligence Enterprise Edition 11.1.1.6.0, 11.1.1.6.1, 11.1.1.6.2, 11.1.1.6.2 BP1, 11.1.1.6.4, 11.1.1.6.5, 11.1.1.6.6, 11.1.1.6.7, and 11.1.1.6.8.
Note the following:
  • Oracle Exalytics customers must only install this Oracle Business Intelligence patchset if it is certified for the specific Oracle Exalytics Patch or Patchset Update that they are applying. For more information see Oracle Fusion Middleware Installation and Administration Guide for Oracle Exalytics In-Memory Machine and the Oracle Exalytics certification information.
  • Oracle Fusion Applications customers must not install this Oracle Business Intelligence patchset.
  • The Oracle Business Intelligence 11.1.1.6.9 Patchset is cumulative and includes patches that you might have already applied to the BI System. Therefore, when you are installing the patchset, you might see warning messages indicating that earlier patches are being rolled back. These warnings simply indicate that oPatch is working correctly, and do not require any action.
  • If you have horizontally scaled out the BI system on to multiple machines, then you must apply the Oracle BI EE 11.1.1.6.9 patches and the JDeveloper patch to all machines in the cluster.
  • Customers installing this Oracle Business Intelligence 11.1.1.6.9 patchset on the HP Itanium platform must first download and apply patch 14016752 from My Oracle Support. Note that you must apply patch 14016752 before installing the Oracle Business Intelligence 11.1.1.6.9 patchset. Follow the instructions in the Readme file for patch 14016752 carefully. In particular, be sure to set the ORACLE_HOME environment variable to the <Middleware Home>/<Oracle BI Home> directory (for example, prod_mwhome/Oracle_BI1) before applying patch 14016752.
  • When the patchset installation is complete and the BI System is running again, end users might experience unexpected behavior due to pre-existing browser sessions caching javascript from the earlier Oracle BI release. To avoid unnecessary support requests, ask all end users to clear their browser cache.
Patchset Installation Instructions
  1. Back up the Oracle BI System, including the following:
    • The ORACLE_HOME\bifoundation\server directory
    • The ORACLE_INSTANCE\bifoundation\OracleBIServerComponent\coreapplication_obis1\repository
    • The ORACLE_BI_HOME\bifoundation\jee\mapviewer.ear\web.war\WEB_INF\conf\mapViewerConfig.xml, if you have modified it
    •  
  2. Download the following Oracle BI 11.1.1.6.9 patch zip files from My Oracle Support into the Oracle BI Home directory:
    • 16287811
    • 16287778
    • 16237960
    • 16287840
    • 16287854
    • 16227549
    • 16287884
Like below :










The location of the Oracle BI Home directory depends on where Oracle BI was originally installed, and on the platform. For example:

For me :

C:\ Satya\OBIEE11G\Oracle_BI1

3. Download the following J Developer patch zip file from My Oracle Support:
  • 13952743

    4.   Stop the BI System (in the order shown):
  • BI system components:
    • On Unix, navigate to prod_mwhome/instances/<instance>/bin and enter the following at the command prompt:
      ./opmnctl stopall
    • On Windows, navigate to prod_mwhome\instances\<instance>\bin and enter the following at the command prompt:
      opmnctl stopall

 If you installed Software in your server then you need to stop the weblogic servcies as well.

  • WebLogic Managed Server(s):
    • On Unix, navigate to prod_mwhome/user_projects/domains/<domain_name>/bin and enter the following at the command prompt:
      ./stopManagedWebLogic.sh bi_server1
    • On Windows, navigate to prod_mwhome\user_projects\domains\<domain_name>\bin and enter the following at the command prompt:
      stopManagedWebLogic.cmd bi_server1
  • WebLogic Administration Server:
    • On Unix, navigate to prod_mwhome/user_projects/domains/<domain_name>/bin and enter the following at the command prompt:
      ./stopWebLogic.sh
    • On Windows, navigate to prod_mwhome\user_projects\domains\<domain_name>\bin and enter the following at the command prompt:
      stopWebLogic.cmd -stop
 5.  Clear the files that are associated with the Oracle BI EE Catalog Manager binary cache as follows:
  1. Go to the ORACLE_BI_HOME/bifoundation/web/catalogmanager/configuration/ directory (using a file manager application or the command line). For example:
    • On Linux, AIX, or Solaris: If the Oracle BI Home directory is prod_mwhome/Oracle_BI1, then go to the following directory:
      prod_mwhome/Oracle_BI1/bifoundation/web/catalogmanager/configuration/
    • On Windows: If the Oracle Home directory is C:\satya\OBIEE11G\Oracle_BI1, then go to the following directory:
      c:\satya\OBIEE11G\Oracle_BI1\bifoundation\web\catalogmanager\configuration\
  2. Remove the following Catalog Manager cache directories (if they exist):
    • org.eclipse.osgi
    • org.eclipse.equinox.app


 6.   In the Oracle BI Home directory, unzip each of the Oracle BI 11.1.1.6.9 patch zip files into a subdirectory below the Oracle BI Home directory. For example:
  • On Linux, AIX, or Solaris: You might extract patch 16287811 into prod_mwhome/Oracle_BI1/16287811
  • On Windows: You might extract patch 16287811 into c:\satya\OBIEE11G\Oracle_BI1\16287811

7. At the command prompt, change directory to the Oracle BI Home directory using the command appropriate for the operating system.
For example:
  • On Linux, AIX, or Solaris: If the Oracle BI Home directory is prod_mwhome/Oracle_BI1, then enter the following:
    cd c:\satya\OBIEE11G/Oracle_BI1
  • On Windows: If the Oracle BI Home directory is C:\prod_mwhome\Oracle_BI1, then enter the following:
    cd c:\satya\OBIEE11G\Oracle_BI1




8. At the command prompt, set the ORACLE_HOME, PATH, and JAVA_HOME environment variables as appropriate for the operating system.
For example:
  • On Linux, AIX, or Solaris: If you are using a command shell derived from the C shell, then set the environment variables by entering the following:
    setenv ORACLE_HOME $PWD
    setenv PATH $ORACLE_HOME/bin:$PATH
    setenv JAVA_HOME $ORACLE_HOME/jdk
    setenv PATH $JAVA_HOME/bin:$PATH
    setenv PATH $ORACLE_HOME/OPatch:$PATH
  • On Windows: If the Oracle BI Home directory is C:\satya\OBIEE11G\Oracle_BI1, then set the environment variables by entering the following:
    set ORACLE_HOME=C:\prod_mwhome\Oracle_BI1
    set PATH=%ORACLE_HOME%\bin;%PATH%
    set JAVA_HOME=%ORACLE_HOME%\jdk
    set PATH=%JAVA_HOME%\bin;%PATH%
    set PATH=%ORACLE_HOME%\OPatch;%PATH%

    You have to set two System variables like below.



 10.  At the command prompt, for each of the extracted Oracle BI 11.1.1.6.9 patch directories (starting with 1 of 7, then 2 of 7, and so on):
  1. Change directory to the extracted patch directory.
    For example:
    • On Linux, AIX, or Solaris: If you extracted patch 16287811 into prod_mwhome/Oracle_BI1/16287811, then enter the following:
      cd prod_mwhome/Oracle_BI1/16287811
    • On Windows: If you extracted patch 16287811 into C:\satya\OBIEE11G\Oracle_BI1\16287811, then enter the following:
      cd c:\satya\OBIEE11G\Oracle_BI1\16287811
  2. Apply the patch using the command: opatch apply
  3. When the message "Opatch Succeeded" is displayed, repeat the previous steps for the next patch directory until all the patches have been applied.





     11.   Verify that the Oracle BI 11.1.1.6.9 patches have been applied successfully as follows:
  4. At the command prompt, change directory to the Oracle BI Home.
  5. Run the following command to list the patches that have been applied to the Oracle home that is
    specified by the ORACLE_HOME environment variable (currently the Oracle BI Home):
    opatch lsinventory
  6. Confirm that all the Oracle BI 11.1.1.6.9 patches shown in Section 1 appear in the list of applied patches (along with any other patches that have previously been applied to the BI System).



     Stall the all OBIEE related services including web logic.

    If you want check current obiee version please use below command in command mode in windows .

    Putty in Linux/Unix/Aix.

    C:\Oracle\Middleware\Oracle_BI1\OPatch>opatch version
    OPatch Version: 11.1.0.9.0




    Hope this help's

    Thanks,
    Satya Ranki Reddy

3 comments:

  1. wonderful information, I had come to know about your blog from my friend nandu , hyderabad,i have read atleast 7 posts of yours by now, and let me tell you, your website gives the best and the most interesting information. This is just the kind of information that i had been looking for, i'm already your rss reader now and i would regularly watch out for the new posts, once again hats off to you! Thanks a ton once again, Regards, obiee training institutes in hyderebad


    ReplyDelete
  2. I have RPD and Catalog along with Users created in Obiee 11.1.1.6.0. Now i had installed obiee 11.1.1.7.0 in some other machine, i have to move RPD and Catalog along with Users to the newer version. Can anybody help with step by step document to do this process.

    Thanks,
    Divakar

    ReplyDelete
  3. Hi,

    Please refer below links.

    https://forums.oracle.com/thread/2549726

    https://forums.oracle.com/thread/2549726

    https://forums.oracle.com/message/10948362

    Thanks.

    ReplyDelete