OBIEE Online Training

Tuesday, July 10, 2012

In-Place Upgrading of OBIEE 11.1.1.5.0 to 11.1.1.6.0


1.1    Perform the following general pre-upgrade tasks


a) Stop all Web Logic Servers, Node Manager, OPMN, and OPMN-managed system components that are part of all Oracle BI domains that use the Middleware Home that you must upgrade.

On Windows systems, also stop the component that is called Oracle Web Logic Node Manager (name).

b) Back up directories.

Download the appropriate Product Installers, as described in "Download the Installer"
Patch Oracle Web Logic Server to the latest version (10.3.5 or 10.3.6 ) required

1.2     Run the Oracle BI Product Installer


Go to Disk1 folder inside the installation package folder
Run the following
. /run Installer
Skip Software Update and then select Software Install Only

Path like E:\Share_DEV\OBIEE111160\bishiphome\Disk1\setup.exe

Run the Oracle BI Product Installer, and perform Software Only installation, specifying the existing Middleware home to be patched.
















 Once Prerequisite Checks are done, the next screen will show your system’s current Middleware and Oracle Home. If not, select the proper locations.

You only need to upgrade MDS andBIPLATFORM schema.
1) Change your folder to Middleware/oracle_common/bin folder
2) Run the following command
./psa
Check Oracle Business Intelligence box and click next
D:\Oracle\Middleware\Oracle_BI1\bin\psa.cmd   run as administrator




Run the Patch Set Assistant for each of the Oracle BI schemas created with RCU, as described in the following list. Update the MDS schema first.

1) MDS
2) BIPLATFORM











Check the two prerequisite boxes and click next
Put in your database connection string and SYS account/password. Note: for SQL Server User Name, you have to connect as
dbadmin and password of dbadmin user
Click Connect to test the connection and then type in the MDS schema’s password. Click Next









Start web logic server and then do the below step

cd E:\MiddelwareHome\user_projects\domains\bifoundation_domain\bin
startWeblogic.cmd


upgradenonj2eeapp.bat -oracleInstance D:\Oracle\Middleware\instances\instance1 -adminHost 10.10.1.7 -adminPort 7001 -adminUsername weblogic



Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\Users\deva>d:

D:\>cd D:\Oracle\Middleware\Oracle_BI1\opmn\bin

D:\Oracle\Middleware\Oracle_BI1\opmn\bin>upgradenonj2eeapp
Unregister instance...
Command failed: Command requires argument: -oracleInstance

opmnctl unregisterinstance: failed.

D:\Oracle\Middleware\Oracle_BI1\opmn\bin>upgradenonj2eeapp.bat -oracleInstance D
:\Oracle\Middleware\instances\instance1 -adminHost 10.10.1.7 -adminPort 7001 -
adminUsername weblogic
Unregister instance...

Command requires login to weblogic admin server (10.10.1.7):
  Username: weblogic
  Password:

Unregistering instance
Command succeeded.
redeploy NonJ2EEManagement.ear...

Command requires login to weblogic admin server (10.10.1.7):
  Username: weblogic
  Password:

Redeploying NonJ2EEManagement Application...weblogic.Deployer invoked with optio
ns:  -adminurl 10.10.1.7:7001 -username weblogic -name NonJ2EEManagement -sour
ce D:\Oracle\Middleware\Oracle_BI1\opmn\applications\NonJ2EEManagement.ear -rede
ploy -upload -noexit
<May 8, 2012 3:50:06 PM SGT> <Info> <J2EE Deployment SPI> <BEA-260121> <Initiati
ng redeploy operation for application, NonJ2EEManagement [archive: D:\Oracle\Mid
dleware\Oracle_BI1\opmn\applications\NonJ2EEManagement.ear], to configured targe
ts.>
Done
Command failed: NonJ2EEManagement Applicationdeployment failed.
Details are logged in D:\Oracle\Middleware\instances\instance1\diagnostics\logs\
OPMN\opmn\provision.log

opmnctl redeploy: failed.

D:\Oracle\Middleware\Oracle_BI1\opmn\bin>



1.5    Update configurations and stores


Start WLST
cd/bishiphome/Middleware/oracle_common/common/bin
./wlst.sh
Runthe following WLST command:
upgradeOpss(jpsConfig="D:/Oracle/Middleware/user_projects/domains/bifoundation_domain/config/fmwconfig/jps-
config.xml",jaznData="D:/Oracle/Middleware/oracle_common/modules/oracle.jps_11.1.1/domain_config/system-jazn-data.xml")

1.6    Reboot your machine and Start all bi Services








Note: some place i have erazed IP address and DB Schema User ID so in that place yours

1.7    Some more reference
SR 3-5678807971: Unable to upgrade BIPLATFORM schema?

Till Next Time..

4 comments:

  1. Thank you very much for your good information.
    As I noted in the ... given information is very usefull to every student who ever want to learn about
    best obiee Online Training
    .

    ReplyDelete
  2. Hi your article is very helpful. I am in the process of upgrading from 11.1.1.5 to 11.1.1.6.
    I am using WLST to update configuration and stores. Got error with WLST.cmd that "error in finding weblogic.home". tried setting up wls home, classpath etc.
    thanks for any help.
    Wayne

    ReplyDelete
  3. Appreciation for nice Updates, I found something new and folks can get useful info about BEST ONLINE TRAINING

    ReplyDelete
  4. Thank you for information! This article saved soo much time!

    ReplyDelete