oracle psu oracle11g psu OPatch替换到$ORACLE_HOME的OPatch 查询各个组件相关信息 select COMP_ID,COMP_NAME,VERSION,STATUS from dba_registry; 查询补丁情况 select ACTION_TIME, ACTION,version, COMMENTS from sys.DBA_REGISTRY_HISTORY; 查询是否存在无效对象 select count(*) from dba_objects where status<>'VALID'; 进入到psu补丁目录执行兼容性测试 $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./ -oh $ORACLE_HOME 6.关闭数据库，监听，dbctl shutdown immediate lsnrctl stop emctl stop dbconsole 执行补丁 /opt/app/oracle/product/11.2.0.4/db_home/OPatch/opatch apply 可能出现CheckActiveFilesAndExecutables错误，需要执行如下命令 /sbin/fuser /opt/app/oracle/product/11.2.0.4/db_home/lib/libclntsh.so.11.1 还有可能出现提示需要cmrsp响应文件的错误，使用如下命令生成，默认生成在当前目录 /opt/app/oracle/product/11.2.0.4/db_home/OPatch/ocm/bin/emocmrsp 生成后修改执行命令 /opt/app/oracle/product/11.2.0.4/db_home/OPatch/opatch apply -ocmrf ocm.rsp 最后 @?/rdbms/admin/catbundle.sql psu apply @?/rdbms/admin/utlrp.sql @?/rdbms/admin/dbmsjdev.sql