Steps to Apply patch in OBIEE 11g

1. Back up the Oracle BI system, including the following 

• C:\BIHOME\Oracle_BI1\bifoundation directory
• C:\BIHOME\instances\instance3\bifoundation\OracleBIServerComponent\coreapplication_obis1\repository

2. Stop the Oracle BI system (in the order shown)

• cd C:\BIHOME\instances\instance3\bin 
• opmnctl stopall
• cd C:\BIHOME\user_projects\domains\bifoundation_domain\bin
• stopManagedWebLogic.cmd bi_server1 
•  cdC:\BIHOME\user_projects\domains\bifoundation_domain\bin
• stopWebLogic.cmd 

 3. Navigate to C:\BIHOME\Oracle_BI1 and Unzip the patch zip files.

4. At the command prompt, set the ORACLE_HOME, PATH, and JAVA_HOME environment variables

set ORACLE_HOME=C:\BIHOME\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%

5. At the command prompt, install all component patches that comprise the Oracle BI EE Suite Bundle Patch.

cd C:\BIHOME\Oracle_BI1\20124371\<Directory whose patch to be applied>

If you extracted patch 16913445 into C:\BIHOME\Oracle_BI1\20124371\16913445, then enter the following: 

cd C:\BIHOME\Oracle_BI1\20124371\16913445 

Apply the patch by entering the following command: 

opatch apply  

6. Verify that patch is applied successfully.

7.  Start Admin Sever, Managed Server and BI system components

cd C:\BIHOME\user_projects\domains\bifoundation_domain\bin  

startWebLogic.cmd 

cd  C:\BIHOME\user_projects\domains\bifoundation_domain\bin

startManagedWebLogic.cmd bi_server1  

cd  C:\BIHOME\instances\instance3\bin

opmnctl startall