ORACLE 11.2.0.4 PSU

检查当前Opatch版本(双节点grid执行) su - grid /u01/app/11.2.0.4/grid/OPatch/opatch lsinventory -detail -oh /u01/app/11.2.0.4/grid /u01/app/11.2.0.4/grid/OPatch/opatch version 解压软件包(双节点root执行) chmod 777 /tmp/update/ cd /tmp/update/ unzip p6880880_112000_Linux-x86-64.zip unzip p27967757_112040_Linux-x86-64.zip 替换OPatch并赋权(双节点root执行) cd /u01/app/11.2.0.4/grid mv OPatch/ OPatch.bak cp -r /tmp/update/OPatch . chown -R grid:oinstall OPatch cd /u01/app/oracle/product/11.2.0.4/db_1 mv OPatch/ OPatch.bak cp -r /tmp/update/OPatch . chown -R oracle:oinstall OPatch 确认安装是否成功(双节点grid执行) /u01/app/11.2.0.4/grid/OPatch/opatch lsinventory -detail -oh /u01/app/11.2.0.4/grid /u01/app/11.2.0.4/grid/OPatch/opatch version 确认安装是否成功(双节点oracle执行) /u01/app/oracle/product/11.2.0.4/db_1/OPatch/opatch lsinventory -detail -oh /u01/app/oracle/product/11.2.0.4/db_1/ /u01/app/oracle/product/11.2.0.4/db_1/OPatch/opatch version 关闭数据库(节点一grid执行) srvctl stop database -d rac 打PSU补丁(双节点执行) su - grid $ORACLE_HOME/OPatch/ocm/bin/emocmrsp -no_banner -output /tmp/update/ocm.rsp chmod 775 /tmp/update/ocm.rsp root cd /tmp/update chown -R grid:oinstall 27967757 /u01/app/11.2.0.4/grid/OPatch/opatch auto /tmp/update/27967757 -oh /u01/app/11.2.0.4/grid -ocmrf /tmp/update/ocm.rsp su - grid $ORACLE_HOME/OPatch/opatch lsinventory su - oracle /u01/app/oracle/product/11.2.0.4/db_1/OPatch/opatch apply  -oh /u01/app/oracle/product/11.2.0.4/db_1  -ocmrf /tmp/update/ocm.rsp /tmp/update/27967757/27734982 $ORACLE_HOME/OPatch/opatch lsinventory 打开节点一数据库(节点一oracle执行) sqlplus / as sysdba shutdown immediate; 执行升级脚本(节点一oracle执行) sqlplus / as sysdba @?/rdbms/admin/catbundle.sql psu apply @?/rdbms/admin/utlrp.sql 查看数据库无效对象(节点一oracle执行) select owner,object_name,object_type from dba_objects where status='INVALID'; 查看数据库补丁安装情况(节点一oracle执行) Select * from dba_registry_history; 查看数据库组件情况(节点一oracle执行) select comp_name, version, status from dba_registry;