Oracle打补丁:
1、查看数据库PSU补丁版本
$ORACLE_HOME/OPatch/opatch lsinventory
2、部署opatch
将p6880880_112000_Linux-x86-64.zip上传到/home/oracle目录下。
cd $ORACLE_HOME
mv OPatch/ OPatch.old
unzip /home/oracle/p6880880_112000_Linux-x86-64.zip -d $ORACLE_HOME
$ORACLE_HOME/OPatch/opatch version
3、检查补丁冲突:
cd /home/oracle/28980129
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./
4、应用补丁:
cd /home/oracle/28980129
$ORACLE_HOME/OPatch/opatch apply
5、更新数据字典:
cd $ORACLE_HOME/rdbms/admin
sqlplus / as sysdba
startup
@catbundle.sql psu apply
6、验证升级结果:
sqlplus / as sysdba
SELECT ACTION,COMMENTS FROM REGISTRY$HISTORY;
exit
$ORACLE_HOME/OPatch/opatch lspatches;
查看ORACLE数据库已安装的组件:
col comp_id for a15
col version for a15
col comp_name for a30
select comp_id,comp_name,version from dba_registry;