Monday, October 28, 2013

Patch Failed with Error Code = 73

Error Code 73 while doing the patch  
 
Solution: Commands should run as Administrator. So, go to the Start Menu and right click on the cmd and select cmd as Administrator
 
Close the existed cmd window and open the cmd window by run as Administartor and then start patch process from scratch(Set Variables, running JavaScripts and applying patch)




‘Opatch’ is not recognized as an internal or external command

If we are getting any errors like as shown in the below, we had set the variables wrongly. So, We need set the Variables correctly  (i.e, Path should be correct)

 
Our correct path is “E:\Middleware\Oracle_BI1” but we used wrong path in above command prompt “E:\Middleware_folder\Oracle_BI1”. So, we got the error like ‘optach’ is not recognized.

run below scripts by correcting the path


set ORACLE_HOME=E:\Middleware\Oracle_BI1
and then execute the below javascripts
set PATH=%ORACLE_HOME%\bin;%PATH%
set JAVA_HOME=%ORACLE_HOME%\jdk
set PATH=%JAVA_HOME%\bin;%PATH%
set PATH=%ORACLE_HOME%\OPatch;%PATH%


all the above scripts are ran successfully then apply the patch.

If the patch got succeed then we will get message like "opatch succeeded



 
 
 

Sunday, October 27, 2013

Applying OBIEE 11.1.1.7.1 patch on OBIEE 11.1.1.7.0


Step 1: Extract 6 files into E:\Middleware\Oracle_BI1 path
Step 2: Stop all the Servers and components ( Stop all components using Enterprise Manager, Shut down BI server and Admin Server using console)
Step 3: Apply Patch one by one on 6 extracted files (16453010, 16842070, 16849017, 16850553, 16869578, 16916026)


Step 1:
Extract p16556157_111170_MSWIN-x86-64 file
 
Open p16556157_111170_MSWIN-x86-64 extracted file and again extract the below 6 files in E:\Middleware\Oracle_BI1 folder one by one
1.      BIFNDN_11_1_1_7_0_WINDOWS_X64_130605_1300_16842070
2.      BIFNDNEPM_11_1_1_7_0_WINDOWS_X64_130606_1421_16916026
3.      BIINST_11_1_1_7_0_GENERIC_130423_1920_16453010
4.      BIPUBLISHER_11_1_1_7_0_GENERIC_130607_0438_16849017
5.      BISERVER_11_1_1_7_0_WINDOWS_X64_130531_2306_16850553
6.      BISHIPHOME_11_1_1_7_0OBIEEBP_GENERIC_130607_1544_16869578

  
In Middleware folder we can see 6 extracted files after we extracted above 6 files like as in the below screen shot.
Open 16453010 file and read READ.HTML document for patching instruction in Section 5


Step 2:  
1. Stop all the components using Enterprise Manager
 
       Login to the Enterprise Manager and Goto -> Business Intelligence -> Core Application -> Availability path and Stop all the Services using STOP ALL option as shown in the below screen.
 2.      Go to console link and shut down the BI Server
We can get a message like as shown in the below screen
3.      stop the Admin Server using below screen

Then we will get the below screen if everything is stopped.

Step 3: Run the below scripts in Command to set the variables and apply patch for 6 files to patch.

set ORACLE_HOME=Installation drive:\Middleware\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%
 
Open Command Prompt as Administrator then go to BI Installation Drive
Suppose here we have installed in “E” drive. So, we are moving to E drive in Command prompt
Go to Oracle_BI1 folder in Middleware using command
Run below scripts as shown in the below screen
set ORACLE_HOME=Installation drive:\Middleware\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%
Go to 16453010 folder path using “cd 16453010command as shown in below screen
 Then type “opatch apply” in side of the 16453010
If it is succeed, then will get message like “Opatch Succeeded”as shown in below screen
 
 
 
Now we have successfully done patching for 16453010. Similarly do patching for other 5 files also (16842070, 16849017, 16850553, 16869578, 16916026)
Example: Come back from the 16453010 folder and go to 16842070 folder and run the “Optach apply” command in 16842070