upgrade oracle 10.2.0.5 to oracle 10.2.0.5.4

 

help the customer to upgrade the oracle database single instance from 10.2.0.5 to 10.2.0.5.4. Here are the details of whole process,check it out.
 
environment info:redhat linux 5 update 5 x86_64,oracle 10205 single instance(no em,no isqlplus)
 
prepare the patch "p12419392_10205_Linux-x86-64.zip" and the corresponding OPatch tools "p6880880_102000_Linux-x86-64.zip" or you will get some error msg indicating the low version of opatch tools
 
//do precheck before opatch the PSU
[oracle@hundsun ~]$ /home/oracle/product/10.2.0/OPatch/opatch  prereq  CheckConflictAgainstOHWithDetail -phBaseDir ./12419392
Invoking OPatch 10.2.0.4.9
 
Oracle Interim Patch Installer version 10.2.0.4.9
Copyright (c) 2009, Oracle Corporation.  All rights reserved.
 
PREREQ session
 
Oracle Home       : /home/oracle/product/10.2.0
Central Inventory : /home/oracle/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 10.2.0.4.9
OUI version       : 10.2.0.5.0
OUI location      : /home/oracle/product/10.2.0/oui
Log file location : /home/oracle/product/10.2.0/cfgtoollogs/opatch/opatch2012-09-12_08-04-28AM.log
 
Patch history file: /home/oracle/product/10.2.0/cfgtoollogs/opatch/opatch_history.txt
 
Invoking prereq "checkconflictagainstohwithdetail"
 
Prereq "checkConflictAgainstOHWithDetail" passed.
 
OPatch succeeded.
————————————————————————————————————-
 
//get into the psu dir and opatch apply
 
[oracle@hundsun 12419392]$ /home/oracle/product/10.2.0/OPatch/opatch apply
Invoking OPatch 10.2.0.4.9
 
Oracle Interim Patch Installer version 10.2.0.4.9
Copyright (c) 2009, Oracle Corporation.  All rights reserved.
 
 
Oracle Home       : /home/oracle/product/10.2.0
Central Inventory : /home/oracle/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 10.2.0.4.9
OUI version       : 10.2.0.5.0
OUI location      : /home/oracle/product/10.2.0/oui
Log file location : /home/oracle/product/10.2.0/cfgtoollogs/opatch/opatch2012-09-12_08-08-15AM.log
 
Patch history file: /home/oracle/product/10.2.0/cfgtoollogs/opatch/opatch_history.txt
 
ApplySession applying interim patch '12419392' to OH '/home/oracle/product/10.2.0'
ApplySession failed: ApplySession failed to prepare the system.
 
Patch 12419392 requires OPatch version 10.2.0.5.0.
The OPatch version being used (10.2.0.4.9) doesn't meet the minimum version required by the patch(es). Please download latest OPatch from My Oracle Support.
 
System intact, OPatch will not attempt to restore the system
 
OPatch failed with error code 73
 
—————————————
 
the version of opatch is not satisfy with the requirements, download the needed OPatch tool p6880880_102000_Linux-x86-64.zip
 
 
//check the opatch version
 
[oracle@hundsun OPatch]$ ./opatch -version
Invoking OPatch 10.2.0.5.1
 
Oracle Interim Patch Installer version 10.2.0.5.1
Copyright (c) 2010, Oracle Corporation.  All rights reserved.
 
Syntax Error… Unrecognized Command or Option (-version): 1st argument must be one of the following:
      apply
      napply
      rollback
      nrollback
      lsinventory
      lsinv
      query
      util
      prereq
      version
      -help
      -h
 
Please use the option 'opatch  -help' to get correct syntax
 
OPatch failed with error code 14
——————————————————-
 
//try opatch apply
 
[oracle@hundsun ~]$ cd 12419392/
[oracle@hundsun 12419392]$ /home/oracle/OPatch/
-bash: /home/oracle/OPatch/: is a directory
[oracle@hundsun 12419392]$ /home/oracle/OPatch/opatch apply
Invoking OPatch 10.2.0.5.1
 
Oracle Interim Patch Installer version 10.2.0.5.1
Copyright (c) 2010, Oracle Corporation.  All rights reserved.
 
 
Oracle Home       : /home/oracle/product/10.2.0
Central Inventory : /home/oracle/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 10.2.0.5.1
OUI version       : 10.2.0.5.0
OUI location      : /home/oracle/product/10.2.0/oui
Log file location : /home/oracle/product/10.2.0/cfgtoollogs/opatch/opatch2012-09-12_08-22-26AM.log
 
Patch history file: /home/oracle/product/10.2.0/cfgtoollogs/opatch/opatch_history.txt
 
ApplySession applying interim patch '12419392' to OH '/home/oracle/product/10.2.0'
 
Running prerequisite checks…
Patch 12419392: Optional component(s) missing : [ oracle.rdbms.dv, 10.2.0.5.0 ] , [ oracle.rdbms.dv.oc4j, 10.2.0.5.0 ]
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,username are not the critical elements)
……………………………………………………….
 
Copying file to "/home/oracle/product/10.2.0/sysman/admin/emdrep/sql/core/latest/ecm/ecm_views.sql"
Copying file to "/home/oracle/product/10.2.0/sysman/admin/emdrep/sql/core/latest/sdk/sdk_views.sql"
 
Patching component oracle.sysman.console.db, 10.2.0.5.0…
Updating jar file "/home/oracle/product/10.2.0/sysman/jlib/emjsp.jar" with "/sysman/jlib/emjsp.jar/_database/_schema/_plsqlobject/_createPLSqlObjectPage$__jsp_StaticText.class"
Updating jar file "/home/oracle/product/10.2.0/sysman/jlib/emjsp.jar" with "/sysman/jlib/emjsp.jar/_database/_schema/_plsqlobject/_createPLSqlObjectPage.class"
Updating jar file "/home/oracle/product/10.2.0/sysman/jlib/emjsp.jar" with "/sysman/jlib/emjsp.jar/_database/_schema/_plsqlobject/_editPLSqlObjectPage$__jsp_StaticText.class"
Updating jar file "/home/oracle/product/10.2.0/sysman/jlib/emjsp.jar" with "/sysman/jlib/emjsp.jar/_database/_schema/_plsqlobject/_editPLSqlObjectPage.class"
Updating jar file "/home/oracle/product/10.2.0/sysman/jlib/emjsp.jar" with "/sysman/jlib/emjsp.jar/_database/_schema/_trigger/_triggerAdvancedPage$__jsp_StaticText.class"
Updating jar file "/home/oracle/product/10.2.0/sysman/jlib/emjsp.jar" with "/sysman/jlib/emjsp.jar/_database/_schema/_trigger/_triggerAdvancedPage.class"
Updating jar file "/home/oracle/product/10.2.0/sysman/jlib/emjsp.jar" with "/sysman/jlib/emjsp.jar/_database/_schema/_trigger/_triggerEventPage$__jsp_StaticText.class"
Updating jar file "/home/oracle/product/10.2.0/sysman/jlib/emjsp.jar" with "/sysman/jlib/emjsp.jar/_database/_schema/_trigger/_triggerEventPage.class"
Updating jar file "/home/oracle/product/10.2.0/sysman/jlib/emjsp.jar" with "/sysman/jlib/emjsp.jar/_database/_schema/_trigger/_triggerGeneralPage$__jsp_StaticText.class"
Updating jar file "/home/oracle/product/10.2.0/sysman/jlib/emjsp.jar" with "/sysman/jlib/emjsp.jar/_database/_schema/_trigger/_triggerGeneralPage.class"
Updating jar file "/home/oracle/product/10.2.0/sysman/jlib/emjsp.jar" with "/sysman/jlib/emjsp.jar/_database/_confirmationDelete$__jsp_StaticText.class"
Updating jar file "/home/oracle/product/10.2.0/sysman/jlib/emjsp.jar" with "/sysman/jlib/emjsp.jar/_database/_confirmationDelete.class"
Updating jar file "/home/oracle/product/10.2.0/sysman/jlib/emjsp.jar" with "/sysman/jlib/emjsp.jar/_database/_confirmationWithOptions$__jsp_StaticText.class"
Updating jar file "/home/oracle/product/10.2.0/sysman/jlib/emjsp.jar" with "/sysman/jlib/emjsp.jar/_database/_confirmationWithOptions.class"
Updating jar file "/home/oracle/product/10.2.0/sysman/jlib/emjsp.jar" with "/sysman/jlib/emjsp.jar/_database/_dbObjectsList$__jsp_StaticText.class"
Updating jar file "/home/oracle/product/10.2.0/sysman/jlib/emjsp.jar" with "/sysman/jlib/emjsp.jar/_database/_dbObjectsList.class"
Copying file to "/home/oracle/product/10.2.0/oc4j/j2ee/oc4j_applications/applications/em/em/admin/rep/editUserSummary.uix"
 
Patching component oracle.xdk.rsf, 10.2.0.5.0…
Updating archive file "/home/oracle/product/10.2.0/lib/libxml10.a"  with "lib/libxml10.a/lpxpar.o"
Updating archive file "/home/oracle/product/10.2.0/lib32/libxml10.a"  with "lib32/libxml10.a/lpxpar.o"
 
Patching component oracle.precomp.common, 10.2.0.5.0…
 
Patching component oracle.rdbms.rman, 10.2.0.5.0…
Running make for target client_sharedlib
Running make for target ioracle
Running make for target iwrap
Running make for target client_sharedlib
Running make for target proc
Running make for target irman
ApplySession adding interim patch '12419392' to inventory
 
Verifying the update…
Inventory check OK: Patch ID 12419392 is registered in Oracle Home inventory with proper meta-data.
 
Files check OK: Files from Patch ID 12419392 are present in Oracle Home.
 
The local system has been patched and can be restarted.
 
OPatch succeeded.
 
————————————————————
 
check the results:
 
[oracle@hundsun OPatch]$ ./opatch lsinventory -bugs_fixed|grep PSU
9952230    12419392  Wed Sep 12 08:27:39 CST 2012   DATABASE PSU 10.2.0.5.1 (INCLUDES CPUOCT2010)
10248542   12419392  Wed Sep 12 08:27:39 CST 2012   DATABASE PSU 10.2.0.5.2 (INCLUDES CPUJAN2011)
11724962   12419392  Wed Sep 12 08:27:39 CST 2012   DATABASE PSU 10.2.0.5.3 (INCLUDES CPUAPR2011)
12419392   12419392  Wed Sep 12 08:27:39 CST 2012   DATABASE PSU 10.2.0.5.4 (INCLUDES CPUJUL2011)
[oracle@hundsun OPatch]$