oracle 单边实例,Oracle 单实例补丁

安装补丁：

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.