Oracle 10g升级之--PSU 升级(续)

简介:

Oracle 10g升级之--PSU升级(续)


5、再从10.2.0.4.4 升级到10.2.0.4.11


-----------升级到10.2.0.4.11

[oracle@RH4 12879929]$ /u01/app/oracle/product/10.2.0/db_1/OPatch/opatch apply

Invoking OPatch 10.2.0.5.1

Oracle Interim Patch Installer version 10.2.0.5.1

Copyright (c) 2010, Oracle Corporation.All rights reserved.

Oracle Home: /u01/app/oracle/product/10.2.0/db_1

Central Inventory : /u01/app/oracle/oraInventory

from: /etc/oraInst.loc

OPatch version: 10.2.0.5.1

OUI version: 10.2.0.4.0

OUI location: /u01/app/oracle/product/10.2.0/db_1/oui

Log file location : /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch2012-04-28_02-39-21AM.log

Patch history file: /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch_history.txt

ApplySession applying interim patch '12879929' to OH '/u01/app/oracle/product/10.2.0/db_1'

[oracle@RH4 12879929]$ /u01/app/oracle/product/10.2.0/db_1/OPatch/opatch apply

Invoking OPatch 10.2.0.5.1

Oracle Interim Patch Installer version 10.2.0.5.1

Copyright (c) 2010, Oracle Corporation.All rights reserved.

Oracle Home: /u01/app/oracle/product/10.2.0/db_1

Central Inventory : /u01/app/oracle/oraInventory

from: /etc/oraInst.loc

OPatch version: 10.2.0.5.1

OUI version: 10.2.0.4.0

OUI location: /u01/app/oracle/product/10.2.0/db_1/oui

Log file location : /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch2012-04-28_02-39-21AM.log

Patch history file: /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch_history.txt

ApplySession applying interim patch '12879929' to OH '/u01/app/oracle/product/10.2.0/db_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 opsu apply

SQL> -- Execute the next statement only if this is the first PSU applied for 10.2.0.4 or this is the first PSU applied since 10.2.0.4.8.

SQL> @utlrp.sql

SQL> QUIT

The catbundle.sql execution is reflected in the dba_registry_history view by a row associated with bundle series OPSU.

For information about the catbundle.sql script, see My Oracle Support Note 605795.1 Introduction to Oracle Database catbundle.sql.


------------验证


SQL> col COMMENTS for a50

SQL> set linesize 120

SQL> r

1* select action,comments from registry$history

ACTIONCOMMENTS

------------------------------ --------------------------------------------------

UPGRADEUpgraded from 10.2.0.1.0

CPUview recompilation

APPLYPSU 10.2.0.4.4

APPLYPSU 10.2.0.4.11

SQL>

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.


Total System Global Area515899392 bytes

Fixed Size1268412 bytes

Variable Size243270980 bytes

Database Buffers268435456 bytes

Redo Buffers2924544 bytes

Database mounted.

Database opened.

SQL> select action,comments from registry$history;


ACTIONCOMMENTS

------------------------------ --------------------------------------------------

UPGRADEUpgraded from 10.2.0.1.0

CPUview recompilation

APPLYPSU 10.2.0.4.4

APPLYPSU 10.2.0.4.11


SQL>


[oracle@RH4 ~]$ /u01/app/oracle/product/10.2.0/db_1/OPatch/opatchlsinventory -bugs_fixed | grep -i 'DATABASE PSU'

965499112879929Sat Apr 28 02:42:11 CST 2012DATABASE PSU 10.2.0.4.5 (REQUIRES PRE-REQUISITE

995223412879929Sat Apr 28 02:42:11 CST 2012DATABASE PSU 10.2.0.4.6 (REQUIRES PRE-REQUISITE

1024863612879929Sat Apr 28 02:42:11 CST 2012DATABASE PSU 10.2.0.4.7 (REQUIRES PRE-REQUISITE

1172497712879929Sat Apr 28 02:42:11 CST 2012DATABASE PSU 10.2.0.4.8 (REQUIRES PRE-REQUISITE

1241939712879929Sat Apr 28 02:42:11 CST 2012DATABASE PSU 10.2.0.4.9 (REQUIRES PRE-REQUISITE

1282777812879929Sat Apr 28 02:42:11 CST 2012DATABASE PSU 10.2.0.4.10 (REQUIRES PRE-REQUISITE

85761569352164Sat Apr 28 00:50:14 CST 2012DATABASE PSU 10.2.0.4.1 (INCLUDES CPUJUL2009)

88332809352164Sat Apr 28 00:50:14 CST 2012DATABASE PSU 10.2.0.4.2 (INCLUDES CPUOCT2009)

91192849352164Sat Apr 28 00:50:14 CST 2012DATABASE PSU 10.2.0.4.3 (INCLUDES CPUJAN2010)

93521649352164Sat Apr 28 00:50:14 CST 2012DATABASE PSU 10.2.0.4.4 (INCLUDES CPUAPR2010)










本文转自 客居天涯 51CTO博客,原文链接:http://blog.51cto.com/tiany/846729,如需转载请自行联系原作者
目录
相关文章
|
10月前
|
SQL Oracle 安全
Virtualbox安装Oracle 19c 升级到19.8(Oracle Restart和数据库)完整步骤
这个文档是来自鼎甲科技的姚远工作中整理的,在Virtualbox上安装Oracle 19.3 再升级到19.8(Oracle Restart和数据库)完整步骤,包括:配置系统环境,安装grid,oracle,建库,补丁下载升级等全过程。
455 0
|
10月前
|
SQL Oracle 关系型数据库
Oracle 19c 补丁升级引发的单表恢复失败谜案
问题表现 某客户在恢复 Oracle 数据库的单表时,提示类似下面的信息
|
10月前
|
SQL Oracle 关系型数据库
|
Oracle 关系型数据库 数据库
|
Oracle 关系型数据库 数据库
❤️Docker中只需2步即可拥有Oracle 10G环境,史上最快部署❤️
❤️Docker中只需2步即可拥有Oracle 10G环境,史上最快部署❤️
911 1
❤️Docker中只需2步即可拥有Oracle 10G环境,史上最快部署❤️
|
SQL Oracle 关系型数据库
Oracle 10g与Oracle 11g之间的导入与导出
Oracle 10g与Oracle 11g之间的导入与导出
|
存储 Oracle 关系型数据库
Oracle 10g通过创建物化视图实现不同数据库间表级别的数据同步
Oracle 10g通过创建物化视图实现不同数据库间表级别的数据同步
|
Oracle 容灾 安全
实战篇:生产库升级,容灾库 Oracle DataGuard 如何升级?
实战篇:生产库升级,容灾库 Oracle DataGuard 如何升级?
实战篇:生产库升级,容灾库 Oracle DataGuard 如何升级?
|
监控 Oracle 关系型数据库
实战篇:AutoUpgrade 便捷高效的升级 Oracle 数据库
实战篇:AutoUpgrade 便捷高效的升级 Oracle 数据库
实战篇:AutoUpgrade 便捷高效的升级 Oracle 数据库
【阿里云新品发布·周刊】第14期:POLARDB 2.0 重磅升级,分别支持Oracle与PostgreSQL
点击订阅新品发布会! 新产品、新版本、新技术、新功能、价格调整,评论在下方,下期更新!关注更多内容,了解更多 最新发布 POLARDB 2.0 重磅升级 2019年6月19日15时,阿里云 POLARDB 2.0重磅发布,高度兼容 Oracle,助力企业快速进入云智能时代;完全兼容 PostgreSQL,适合中大型企业核心业务场景;最大100T,计算和存储分离架构提供澎湃性能。
4583 0

推荐镜像

更多