ITPub博客

首页 > 数据库 > Oracle > Oracle 单实例补丁

Oracle 单实例补丁

原创 Oracle 作者:DBhanG 时间:2020-06-24 14:05:49 0 删除 编辑

安装补丁:

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 
  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.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/69975956/viewspace-2700462/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2020-05-28

  • 博文量
    59
  • 访问量
    32920