安装补丁:
Determine whether any currently installed one-off patches conflict with the PSU patch as follows:
unzip p27734982_112040_
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_
catbundle_PSU_
catbundle_PSU_
catbundle_PSU_
补丁卸载:
1.
验证
$ORACLE_HOME/rdbms/admin/catbundle_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_
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.