Oracle 10g(10.2.0.4)升级到10.2.0.5.19(2)

set line 200  
col ACTION_TIME for a30    
col ACTION for a20    
col NAMESPACE for a10    
col VERSION for a10    
col BUNDLE_SERIES for a5    
col COMMENTS for a25    
select * from dba_registry_history;    
 

ACTION_TIME                    ACTION              NAMESPACE  VERSION            ID COMMENTS  
------------------------------ -------------------- ---------- ---------- ---------- -------------------------    
21-316 10.47.16.102814 VIEW RECOMPILE                                8289601 view recompilation

21-316 10.47.16.167852 UPGRADE              SERVER    10.2.0.5.0            Upgraded from 10.2.0.4.0

SQL>

四、打PSU19，更新OPatch版本，必须要更新OPatch版本

说明：分别在两个节点更新OPatch版本。

1. 更新OPatch版本，需要更新到10.2.0.5.19，OPatch直接压缩替换就可以了。

(1) 上传p6880880_102000_Linux-x86-64.zip到/u01/software目录下, /u01/software给777权限，也可以采用/tmp目录。  
(2) root用户下将原OPatch目录改名。

mv /u01/app/oracle/product/10.2.0/db_1/OPatch /u01/app/oracle/product/10.2.0/db_1/OPatchBK

2. oracle目录OPatch替换

(1) root用户

cd /u01/software/  
chown oracle:oinstall p6880880_102000_Linux-x86-64.zip    
chown oracle:oinstall p20299014_10205_Linux-x86-64.zip

(2) oracle用户

su - oracle  
cd /u01/software/    
unzip p6880880_102000_Linux-x86-64.zip    
unzip p20299014_10205_Linux-x86-64.zip

(3) root用户

cd /u01/software/  
mv OPatch /u01/app/oracle/product/10.2.0/db_1/

(4) oracle用户测试

su - oracle

/u01/app/oracle/product/10.2.0/db_1/OPatch/opatch version

Invoking OPatch 10.2.0.5.1  
OPatch Version: 10.2.0.5.1    
OPatch succeeded

3. 测试兼容性

su - oracle

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/software/20299014 -oh $ORACLE_HOME

----------------------------------------------------  
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.

PREREQ session  
Oracle Home      : /u01/app/oracle/product/10.2.0/db_1    
Central Inventory : /u01/app/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/db_1/oui    
Log file location : /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch2016-03-15_12-33-56PM.log

Patch history file: /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch_history.txt  
Invoking prereq "checkconflictagainstohwithdetail"    
Prereq "checkConflictAgainstOHWithDetail" passed.    
OPatch succeeded.

五、实施打补丁PSU 1. 关闭数据库

1）关闭数据库  
sqlplus / as sysdba;    
shutdown immediate;

2）关闭监听

$ lsnrctl stop

3. oracle database打补丁，还是用同一个补丁包

su - oracle

/u01/app/oracle/product/10.2.0/db_1/OPatch/opatch napply -oh $ORACLE_HOME -local /u01/software/20299014

***************************************************************  
Do you want to proceed? [y|n]    
y    
User Responded with: Y

Email address/User Name:

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    
...