安装补丁:
Determine whether any currently installed one-off patches conflict with the PSU patch as follows:
unzip p27734982_112040_.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
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_
_APPLY_
.log
catbundle_PSU_
_GENERATE_<
TIMESTAMP>
.log
catbundle_PSU_
_APPLY_
.log
catbundle_PSU_
_GENERATE_<
TIMESTAMP>
.log
补丁卸载:
1.
验证
$ORACLE_HOME/rdbms/admin/catbundle_PSU_
_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_
_APPLY_
.log
catbundle_PSU_
_GENERATE_ <
TIMESTAMP>
.log
2.
关闭与要更新的Oracle主目录关联的所有实例和侦听器。
3.
oracle@service1 OPatch]$ ./opatch rollback -id 20299013
4.
启动从Oracle主目录运行的所有数据库实例。
5.
cd $ ORACLE_HOME / rdbms / admin
SQL> @catbundle_PSU_
_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.