oracle psu

oracle11g psu

1. OPatch替换到$ORACLE_HOME的OPatch
2. 查询各个组件相关信息

select COMP_ID,COMP_NAME,VERSION,STATUS from dba_registry;

3. 查询补丁情况

select ACTION_TIME, ACTION,version, COMMENTS from sys.DBA_REGISTRY_HISTORY;

4. 查询是否存在无效对象

select count(*) from dba_objects where status<>'VALID';

5. 进入到psu补丁目录执行兼容性测试

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./ -oh $ORACLE_HOME

6.关闭数据库，监听，dbctl

shutdown immediate
lsnrctl stop
emctl stop dbconsole

7. 执行补丁

/opt/app/oracle/product/11.2.0.4/db_home/OPatch/opatch apply

8. 可能出现CheckActiveFilesAndExecutables错误，需要执行如下命令

/sbin/fuser /opt/app/oracle/product/11.2.0.4/db_home/lib/libclntsh.so.11.1

9. 还有可能出现提示需要cmrsp响应文件的错误，使用如下命令生成，默认生成在当前目录

/opt/app/oracle/product/11.2.0.4/db_home/OPatch/ocm/bin/emocmrsp

10. 生成后修改执行命令

/opt/app/oracle/product/11.2.0.4/db_home/OPatch/opatch apply -ocmrf ocm.rsp

11. 最后

@?/rdbms/admin/catbundle.sql psu apply
@?/rdbms/admin/utlrp.sql
@?/rdbms/admin/dbmsjdev.sql