安装补丁：
Determine whether any currently installed one-off patches conflict with the PSU patch as follows:
unzip p27734982_112040_<platform>.zip cd 27734982 opatch prereq CheckConflictAgainstOHWithDetail -ph ./
The following steps load modified SQL files into the database. For an Oracle RAC environment, perform these steps on only one node . 1.For each database instance running on the Oracle home being patched, connect to the database using SQL*Plus. Connect as SYSDBA and run the catbundle.sql script as follows: cd $ORACLE_HOME/rdbms/admin sqlplus /nolog SQL> CONNECT / AS SYSDBA SQL> STARTUP SQL> @catbundle.sql psu apply SQL> QUIT The catbundle.sql execution is reflected in the dba_registry_history view by a row associated with bundle series PSU. For information about the catbundle.sql script, see My Oracle Support Document 605795.1 Introduction to Oracle Database catbundle.sql . 2.If the OJVM PSU was applied for a previous PSU patch, you may see invalid Java classes after execution of the catbundle.sql script in the previous step. If this is the case, run utlrp.sql to re-validate these Java classes. cd $ORACLE_HOME/rdbms/admin sqlplus /nolog SQL> CONNECT / AS SYSDBA SQL> @utlrp.sql 3. Check the following log files in $ORACLE_HOME/cfgtoollogs/catbundle or $ORACLE_BASE/cfgtoollogs/catbundle for any errors: catbundle_PSU_ <database SID> _APPLY_ <TIMESTAMP> .log catbundle_PSU_ <database SID> _GENERATE_< TIMESTAMP> .log catbundle_PSU_ <database SID> _APPLY_ <TIMESTAMP> .log catbundle_PSU_ <database SID> _GENERATE_< TIMESTAMP> .log
补丁卸载： 1. 验证 $ORACLE_HOME/rdbms/admin/catbundle_PSU_ <database SID> _ROLLBACK.sql 与该ORACLE_HOME关联的每个数据库是否存在文件。如果不是这种情况，则必须在卸载PSU之前对数据库执行如下。 cd $ ORACLE_HOME / rdbms / admin SQL> @ catbundle.sql psu apply catbundle.sql的 执行被反映在与束相关联的一系列连续dba_registry_history视图 PSU 。 检查以下日志文 件 $ORACLE_HOME/cfgtoollogs/catbundle 或 $ORACLE_BASE/cfgtoollogs/catbundle 是否有任何错误： catbundle_PSU_ <数据库SID> _APPLY_ <TIMESTAMP> .log catbundle_PSU_ <数据库SID> _GENERATE_ < TIMESTAMP> .log 2. 关闭与要更新的Oracle主目录关联的所有实例和侦听器。 3. oracle@service1 OPatch]$ ./opatch rollback -id 20299013 4. 启动从Oracle主目录运行的所有数据库实例。 5. cd $ ORACLE_HOME / rdbms / admin SQL> @catbundle_PSU_ <数据库SID> _ROLLBACK.sql
查看补丁安装记录：
select action_time,action,comments from dba_Registry_history
查看当前安装所有补丁：
[oracle@service1 OPatch]$ ./opatch lsinv
查看当前Opatch版本：
[oracle@service1 OPatch]$ ./opatch version
OPatch Version: 11.2.0.3.25
OPatch succeeded.
