Applying patch on Windows using Opatch Utility
- Step:1 Ensure you have the latest Opatch
Make sure you have the latest supported version of OPatch downloaded.for your operating systemFor example, you can download the latest Opatch and install it in the directory on your machine under:
D:\OPatch.
- Step 2 : Download the patch to PATCH_TOP
Download the patch to PATCH_TOP directory, as instructed in the README.
For example:
D:\PATCH_TOP>dir <Enter>
Volume in drive D has no label.
Volume Serial Number is 14FC-DC90
Directory of D:\PATCH_TOP
09/24/2010 11:50 AM <DIR> .
09/24/2010 11:50 AM <DIR> ..
09/24/2010 11:50 AM <DIR> 10042883
09/24/2010 11:50 AM 1,088,865 10042883.zip
1 File(s) 1,088,865 bytes
3 Dir(s) 59,291,029,504 bytes free - Step: 3
cd to patch (for example 10042883) directory: - D:\PATCH_TOP>cd 10042883
- Step 4 : Make sure Opatch is in the PATH
Add D:\OPatch to the PATH: - D:\PATCH_TOP\10042883>set PATH=%PATH%;D:\OPatch
Verify that the PATH is set:- D:\PATCH_TOP\10042883> PATH <Enter>
- Step 5 : Set ORACLE_HOME
Set ORACLE_HOME to your BI Home.
For example, in this case, BI Home is set to D:\BI11\Oracle_BI1:
D:\PATCH_TOP\10042883>set ORACLE_HOME=D:\BI11\Oracle_BI1<Enter> - Verify that the Oracle Home is set correctly:
- D:\PATCH_TOP\10042883>echo %ORACLE_HOME% <Enter>Note: You are setting ORACLE_HOME for this command-prompt session only. This is set to only facilitate patch application/rollback/inventory, etc. Do not make this a permanent environment variable as it will affect other Oracle Products running on your system which may need a permanent ORACLE_HOME environment variable.
- Step 6 : Verify Opatch version
Verify you have the correct OPatch version:
D:\PATCH_TOP\10042883>opatch version <Enter>
Invoking OPatch 11.1.0.8.3
OPatch Version: 11.1.0.8.3
OPatch succeeded.
Invoking OPatch 11.1.0.8.3
OPatch Version: 11.1.0.8.3
OPatch succeeded.
- Step 7 : Apply the OBIEE patch (for example 10042883)
7.1: Shutdown all BI services:
Apply patch 10042883 -- Before applying any OBIEE patch, make sure all
BI Services are shut down.
Start->Programs->Oracle BI->Stop BI Services - 7.2: Apply the patch:
D:\PATCH_TOP\10042883>opatch apply <Enter>
If you are running a 64-bit OS: Windows64bit / Linux 64bit / AIX 64bit, make sure
you use the following command:
you use the following command:
opatch apply -jre %ORACLE_HOME%/jdk/jre <Enter>
- You should get the following output:
Invoking OPatch 11.1.0.8.3
Oracle Interim Patch Installer version 11.1.0.8.3
Copyright (c) 2010, Oracle Corporation. All rights reserved.
Oracle Home : D:\BI11\Oracle_BI1
Central Inventory : C:\Program Files\Oracle\Inventory
from : n/a
OPatch version : 11.1.0.8.3
OUI version : 11.1.0.8.0
OUI location : D:\BI11\Oracle_BI1\oui
Log file location : D:\BI11\Oracle_BI1\cfgtoollogs\opatch\opatch2010-09-24_16-52-41PM.log
Patch history file: D:\BI11\Oracle_BI1\cfgtoollogs\opatch\opatch_history.txt
OPatch detects the Middleware Home as " D:\BI11"
ApplySession applying interim patch '10042883' to OH ‘D:\BI11\Oracle_BI’
Running prerequisite checks...
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name: ----------> SKIP THIS (Press Enter ! )
You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: Y -----> Enter Y
OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = 'D:\OracleBI11\Oracle_BI1')
Is the local system ready for patching? [y|n]
y -----> Enter Y
User Responded with: Y
Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch '10042883' for restore. This might take a while...
Backing up files affected by the patch '10042883' for rollback. This might take a while...
Patching component oracle.bi.bifndn, 11.1.1.3.0...
Copying file to " D:\BI11\Oracle_BI1\bifoundation\server\bin\nqsexecevalutil.dll"
Copying file to " D:\BI11\Oracle_BI1\bifoundation\server\bin\nqutilitygeneric.dll"
Copying file to " D:\BI11\Oracle_BI1\bifoundation\server\bin\nqutilitycomm.dll"
Copying file to " D:\BI11\Oracle_BI1\bifoundation\server\bin\nqsserventry.dll"
ApplySession adding interim patch '10042883' to inventory
Verifying the update...
Inventory check OK: Patch ID 10042883 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 10042883 are present in Oracle Home.
The local system has been patched and can be restarted.
OPatch succeeded. - Step 8 : lsinventory command
- Verify that the patch was applied correctly by checking the inventory:
D:\PATCH_TOP\10042883>opatch lsinventory <Enter>
If you are running a 64-bit OS: Windows64bit / Linux 64bit / AIX 64bit, make sure
you use the following command:
you use the following command:
opatch lsinventory -jre %ORACLE_HOME%/jdk/jre <Enter>
- Invoking OPatch 11.1.0.8.3
Oracle Interim Patch Installer version 11.1.0.8.3
Copyright (c) 2010, Oracle Corporation. All rights reserved.
Oracle Home : D:\BI11\Oracle_BI1
Central Inventory : C:\Program Files\Oracle\Inventory
from : n/a
OPatch version : 11.1.0.8.3
OUI version : 11.1.0.8.0
OUI location : D:\BI11\Oracle_BI1\oui
Log file location : D:\BI11\Oracle_BI1\cfgtoollogs\opatch\opatch2010-09-24_16-55-24PM.log
Patch history file: D:\BI11\Oracle_BI1\cfgtoollogs\opatch\opatch_history.txt
OPatch detects the Middleware Home as "D:\OracleBI11"
Lsinventory Output file location : D:\BI11\Oracle_BI1\cfgtoollogs\opatch\lsinv\lsinventory2010-09-24_16-55-24PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Business Intelligence Shiphome 11.1.1.3.0
There are 1 products installed in this Oracle Home.
Interim patches (2) :
Patch 10042883 : applied on Fri Sep 24 16:55:12 PDT 2010
Created on 22 Sep 2010, 16:51:37 hrs
Bugs fixed:
9966690, 9980734, 9975798, 9959228
--------------------------------------------------------------------------------
OPatch succeeded.
You can now restart all OBIEE services and test the patch.
Start->Programs->Oracle BI->Start BI Services - Step 9 : rollback commandIf you need to remove the patch, use this command:D:\PATCH_TOP\10042883>opatch rollback -id 10042833 <specify your patch ID>If you are running a 64-bit OS: Windows64bit / Linux 64bit / AIX 64bit, make sureopatch rollback -id 10042833 -jre %ORACLE_HOME%/jdk/jre <Enter>
- Step 10 : additional Opatch commands
If you need additional help on OPatch commands:
D:\PATCH_TOP\10042883>opatch -help
