We plan to use the latest 10 GB version 10.2.0.5.4 for the newly created environment. The previous test process is as follows:
Upgrade a single oracle instance from 10.2.0.1 to 10.2.0.5.4 on Linux
Http://blog.csdn.net/tianlesoftware/article/details/6858397
The previous steps were successful, but an error was reported in apply10.2.0.5.4 patch.
QS-Xe-dzora-PD:/u01/software/12419392> $ ORACLE_HOME/opatch apply
Invoking opatch 10.2.0.5.1
Oracle interim patch installer version10.2.0.5.1
Copyright (c) 2010, oraclecorporation. All rights reserved.
Oracle Home:/u01/APP/Oracle/product/10.2.0.5.4/db_1
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:/u01/APP/Oracle/product/10.2.0.5.4/db_1/OUI
Log File Location:/u01/APP/Oracle/product/10.2.0.5.4/db_1/runtime toollogs/opatch/opatch2011-10-19_21-03-26PM.log
Patch history file:/u01/APP/Oracle/product/10.2.0.5.4/db_1/export toollogs/opatch/opatch_history.txt
Applysession applying interim patch '000000' to oh'/u01/APP/Oracle/product/10.2.0.5.4/db_1'
Running prerequisite checks...
Patch 12419392: optionalcomponent (s) Missing: [Oracle. RDBMS, 10.2.0.5.0], [Oracle. RDBMS. RSF, 10.2.0.5.0], [Oracle. RDBMS. dbscripts, 10.2.0.5.0], [Oracle. RDBMS. DV, 10.2.0.5.0], [Oracle. network. RSF, 10.2.0.5.0], [Oracle. RDBMS. DV.. sysman. bsln, 10.2.0.5.0], [Oracle. sysman. repository. core, 10.2.0.5.0a], [Oracle. sysman. console. DB, 10.2.0.5.0], [Oracle. xdk. RSF, 10.2.0.5.0], [Oracle. precomp. common, 10.2.0.5.0], [Oracle. RDBMS. RMAN, 10.2.0.5.0]
Prerequisite check "checkapplicable" failed.
The details are:
Patch "12419392" is a no-op patch.
Applysession failed during prerequisitechecks: prerequisite check "checkapplicable" failed.
System intact, opatch will not attempt torestore the system
Opatch failed with error code 74
QS-Xe-dzora-PD:/u01/software/12419392 & gt;
Because it is a new production environment, use Oui to unmount all the previously installed Oracle, and then reinstall it, hitting 10.2.0.5.0. because no instance is created, the entire process will take 20 minutes.
Then, the patch will pass smoothly. However, the following error message is displayed:
QS-Xe-dzora-PD:/u01/software/12419392> $ ORACLE_HOME/opatch apply
Invoking opatch 10.2.0.5.1
Oracle interim patch installer version10.2.0.5.1
Copyright (c) 2010, oraclecorporation. All rights reserved.
Oracle Home:/u01/APP/Oracle/product/10.2.0.5.4/db_1
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:/u01/APP/Oracle/product/10.2.0.5.4/db_1/OUI
Log File Location:/u01/APP/Oracle/product/10.2.0.5.4/db_1/runtime toollogs/opatch/opatch2011-10-20_09-23-52AM.log
Patch history file:/u01/APP/Oracle/product/10.2.0.5.4/db_1/export toollogs/opatch/opatch_history.txt
Applysession applying interim patch '000000' to oh'/u01/APP/Oracle/product/10.2.0.5.4/db_1'
Running prerequisite checks...
Patch 12419392: optionalcomponent (s) Missing: [Oracle. RDBMS. DV, 10.2.0.5.0], [Oracle. RDBMS. DV. Solaris, 10.2.0.5.0]
Provide your email address to be informedof security issues, install and
Initiate Oracle Configuration Manager. easier for you if you use your my
Oracle Support email address/user name.
Visithttp: // www.oracle.com/support/policies.html for details.
......
Verify patch:
QS-Xe-dzora-PD:/u01/software/12419392> $ ORACLE_HOME/opatch lsinv-bugs_fixed | grep PSU
9952230 12419392 Thu Oct 20 09:34:38 cst2011 database PSU 10.2.0.5.1 (includescpuoct2010)
10248542 12419392 Thu Oct 20 09:34:38 cst2011 database PSU 10.2.0.5.2 (includescpujan2011)
11724962 12419392 Thu Oct 20 09:34:38 cst2011 database PSU 10.2.0.5.3 (includescpuapr2011)
12419392 12419392 Thu Oct 20 09:34:38 cst2011 database PSU 10.2.0.5.4 (includescpujul2011)
Bytes -------------------------------------------------------------------------------------------------------
All rights reserved. reprinted articles are allowed, but the source address must be indicated by link; otherwise, the documents shall be held legally liable.
Blog: http://blog.csdn.net/tianlesoftware
WEAVER: http://weibo.com/tianlesoftware
Email: tianlesoftware@gmail.com
Dba1 group: 62697716 (full); dba2 group: 62697977 (full) dba3 group: 62697850 (full)
Super DBA group: 63306533 (full); dba4 group: 83829929 (full) dba5 group: 142216823 (full)
Dba6 group: 158654907 (full) dba7 group: 69087192 (full) dba8 group: 172855474
DBA super group 2: 151508914 dba9 group: 102954821 chat group: 40132017 (full)
-- Add the group to describe the relationship between Oracle tablespace and data files in the remarks section. Otherwise, the application is rejected.