当前位置:  数据库>oracle

Oracle 11g 单实例打11.2.0.3.4 P14275605 PSU补丁

    来源: 互联网  发布时间：2017-06-06

    本文导语: 1.关闭所有instance SQL> shutdown immediate 2.关闭所有监听 $[Oracle@ora_11g test01]$ lsnrctl stop 3.关闭所有后台sqlplus [oracle@ora_11g 14275605]$ ps -ef | grep sqlplus oracle  11823  6859  0 20:20 pts/2    00:00:00 grep sqlplus --------------------------------------分割线 ---...

1.关闭所有instance

SQL> shutdown immediate

2.关闭所有监听

$[Oracle@ora_11g test01]$ lsnrctl stop

3.关闭所有后台sqlplus

[oracle@ora_11g 14275605]$ ps -ef | grep sqlplus

oracle  11823  6859  0 20:20 pts/2    00:00:00 grep sqlplus

--------------------------------------分割线 --------------------------------------

在CentOS 6.4下安装Oracle 11gR2(x64)

Oracle 11gR2 在VMWare虚拟机中安装步骤

Debian 下 安装 Oracle 11g XE R2

--------------------------------------分割线 --------------------------------------

4.进入14275605 psu 解压目录,确保14275605权限为oracle:oinstall

[oracle@ora_11g ~]$ cd /oinstall/14275605/

[oracle@ora_11g 14275605]$ pwd

/oinstall/14275605

[oracle@ora_11g 14275605]$ ls -al

drwxrwxr-x 6 oracle oinstall 4096 Oct 12 15:29 .

drwxr-xr-x 5 oracle oinstall 4096 Dec 17 20:00 ..

drwxr-xr-x 4 oracle oinstall 4096 Apr  4  2012 13343438

drwxrwxr-x 4 oracle oinstall 4096 Apr  4  2012 13696216

drwxrwxr-x 4 oracle oinstall 4096 Jun 13  2012 13923374

drwxrwxr-x 4 oracle oinstall 4096 Oct  4 09:38 14275605

-rwxr-xr-x 1 oracle oinstall 2871 Oct  4 09:38 patchmd.xml

 

5.检查OPATCH版本，如果版本过低需要到MOS下载最近的OPATCH psu号为为6880880

[oracle@ora_11g 14275605]$ $ORACLE_HOME/OPatch/opatch  version

OPatch Version: 11.2.0.3.0

 

OPatch succeeded.

 

6.检查是否有与14275605有冲突的PSU

[oracle@ora_11g 14275605]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./

Oracle Interim Patch Installer version 11.2.0.3.0

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

 

PREREQ session

 

Oracle Home      : /opt/oracle/product/db_1

Central Inventory : /opt/oraInventory

  from          : /opt/oracle/product/db_1/oraInst.loc

OPatch version    : 11.2.0.3.0

OUI version      : 11.2.0.3.0

Log file location : /opt/oracle/product/db_1/cfgtoollogs/opatch/opatch2012-12-18_20-05-23PM_1.log

 

Invoking prereq "checkconflictagainstohwithdetail"

 

Prereq "checkConflictAgainstOHWithDetail" passed.

 

OPatch succeeded.

 

 

7.应用14275605 database PSU

[oracle@ora_11g 14275605]$ /opt/oracle/product/db_1/OPatch/opatch apply

Oracle Interim Patch Installer version 11.2.0.3.0

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

 

 

Oracle Home      : /opt/oracle/product/db_1

Central Inventory : /opt/oraInventory

  from          : /opt/oracle/product/db_1/oraInst.loc

OPatch version    : 11.2.0.3.0

OUI version      : 11.2.0.3.0

Log file location : /opt/oracle/product/db_1/cfgtoollogs/opatch/opatch2012-12-18_20-09-24PM_1.log

 

Verifying environment and performing prerequisite checks...

OPatch continues with these patches:  13343438  13696216  13923374  14275605 

 

Do you want to proceed? [y|n]

y

User Responded with: Y

All checks passed.

Provide your email address to be informed of security issues, install and

initiate Oracle Configuration Manager. Easier for you if you use your My

Oracle Support Email address/User Name.

Visit http://www.oracle.com/support/policies.html for details.

Email address/User Name:

 

You have not provided an email address for notification of security issues.

Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]:  y

 

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.

(Oracle Home = '/opt/oracle/product/db_1')

 

 

Is the local system ready for patching? [y|n]

y

User Responded with: Y

Backing up files...

Applying sub-patch '13343438' to OH '/opt/oracle/product/db_1'

 

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

 

Patching component oracle.rdbms, 11.2.0.3.0...

 

Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...

 

Verifying the update...

Applying sub-patch '13696216' to OH '/opt/oracle/product/db_1'

 

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

 

Patching component oracle.rdbms, 11.2.0.3.0...

 

Patching component oracle.sdo.locator, 11.2.0.3.0...

 

Patching component oracle.sysman.console.db, 11.2.0.3.0...

 

Patching component oracle.sysman.oms.core, 10.2.0.4.4...

 

Verifying the update...

Applying sub-patch '13923374' to OH '/opt/oracle/product/db_1'

ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.3.0 ]  not present in the Oracle Home or a higher version is found.

 

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

 

Patching component oracle.rdbms, 11.2.0.3.0...

 

Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...

 

Patching component oracle.network.rsf, 11.2.0.3.0...

 

Patching component oracle.network.listener, 11.2.0.3.0...

 

Patching component oracle.sysman.console.db, 11.2.0.3.0...

 

Verifying the update...

Applying sub-patch '14275605' to OH '/opt/oracle/product/db_1'

ApplySession: Optional component(s) [ oracle.precomp.lang, 11.2.0.3.0 ]  not present in the Oracle Home or a higher version is found.

 

Patching component oracle.network.client, 11.2.0.3.0...

 

Patching component oracle.network.rsf, 11.2.0.3.0...

 

Patching component oracle.precomp.common, 11.2.0.3.0...

 

Patching component oracle.rdbms, 11.2.0.3.0...

 

Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...

 

Patching component oracle.rdbms.rman, 11.2.0.3.0...

 

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

 

Patching component oracle.rdbms.util, 11.2.0.3.0...

 

Verifying the update...

 

OPatch found the word "warning" in the stderr of the make command.

Please look at this stderr. You can re-run this make command.

Stderr output:

ins_precomp.mk:19: warning: overriding commands for target `pcscfg.cfg'

/opt/oracle/product/db_1/precomp/lib/env_precomp.mk:2160: warning: ignoring old commands for target `pcscfg.cfg'

/opt/oracle/product/db_1/precomp/lib/ins_precomp.mk:19: warning: overriding commands for target `pcscfg.cfg'

/opt/oracle/product/db_1/precomp/lib/env_precomp.mk:2160: warning: ignoring old commands for target `pcscfg.cfg'

 

 

Composite patch 14275605 successfully applied.

OPatch Session completed with warnings.

Log file location: /opt/oracle/product/db_1/cfgtoollogs/opatch/opatch2012-12-18_20-09-24PM_1.log

 

OPatch completed with warnings.

 

 

8.进入admin目录，执行catbundle.sql脚本应用改变

[oracle@ora_11g 14275605]$ cd  $ORACLE_HOME/rdbms/admin

[oracle@ora_11g admin]$ sqlplus  / as sysdba

 

SQL> startup

 

SQL> @catbundle.sql psu apply

 

查询registry$history 来查看PSU级别

 

SQL>select substr(action_time,1,30) action_time,

    substr(id,1,8) id,

    substr(action,1,10) action,

    substr(version,1,8) version,

    substr(comments,1,20) comments

    from registry$history;

 

ACTION_TIME                    ID    ACTION    VERSION    COMMENTS

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

17-DEC-12 03.14.08.703547 PM  0    APPLY      11.2.0.3  Patchset 11.2.0.2.0

18-DEC-12 08.13.16.342146 PM  4    APPLY      11.2.0.3  PSU 11.2.0.3.4

 

 

9.在以下目录检查是否错误

 

$ORACLE_HOME/cfgtoollogs/catbundle

$ORACLE_BASE/cfgtoollogs/catbundle

日志格式如下:

catbundle_PSU__APPLY_.log

catbundle_PSU__GENERATE_.log

 

到此 PSU数据库升级完成

 

10.执行完catbundle.sql后，会在$ORACLE_HOME/rdbms/admin目录下生成

catbundle_PSU__APPLY.sql，catbundle_PSU__ROLLBACK.sql两个脚本

 

[oracle@ora_11g admin]$ ls -al catbundle_PSU_TEST01_*

-rw-r----- 1 oracle oinstall 1130 Dec 18 20:13 catbundle_PSU_TEST01_APPLY.sql

-rw-r----- 1 oracle oinstall 1139 Dec 18 20:13 catbundle_PSU_TEST01_ROLLBACK.sql

 

catbundle_PSU_TEST01_ROLLBACK.sql用于回滚PSU时使用

：


    
 
 

您可能感兴趣的文章:

  • Linux上建立第二个ORACLE实例分析
  • Linux操作系统下Oracle数据库多实例启动方式及修改内存
  • oracle的存储过程实例讲解
  • linux redhat5.6安装oracle11g在自动创建实例时停住不动，有图
  • oracle分页存储过程 oracle存储过程实例
  • C#连接Oracle数据库的实例方法
  • Oracle数据库实例两则
  • Oracle 删除归档日志实例
  • Oracle 10g for solaris准备工作和实例的删除
  • Oracle 11G 无法连接到数据库实例故障排除
  • Linux下设置Oracle 10g 服务以及实例自动启动
  • oracle group by语句实例测试
  • Oracle数据库异构服务原理及实例说明
  • Linux下删除Oracle实例
  • 与Oracle RAC相关的连接配置写法实例
  • Oracle监听器Server端与Client端配置实例
  • Oracle中使用触发器(trigger)和序列(sequence)模拟实现自增列实例
  • oracle删除已存在的表的实例
  • Aix 5.3下自动备份Oracle多个实例
  • Oracle数据库安全性管理基本措施实例解析
    •  
    本站(WWW.)旨在分享和传播互联网科技相关的资讯和技术，将尽最大努力为读者提供更好的信息聚合和浏览方式。
    本站(WWW.)站内文章除注明原创外，均为转载、整理或搜集自网络。欢迎任何形式的转载，转载请注明出处。












  • 相关文章推荐
  • c/c++ iis7站长之家
  • 急求SCO UNIX 5.06的ORACLE补丁包oss459a.z,请问各位大侠,哪里可以下载,急等!!!
  • AS3安装Oracle 9.2.0前，打补丁出错，导致系统无法引导.大侠们帮忙
  • turbolinux7.1 安装 oracle817 的问题 补丁binutils-2.11.92.0.7-2.i586.rpm不能安装
  • 那位仁兄有oracle8i for red hat linux9 的 glibc-2.1.3-stubs.tar.gz 补丁程序？急用！
  • 快一个月了，我参考了所有的安装帖子，下了所有的补丁，Oracle安装依然出错。为什么？？想哭。
  • VMware中linux环境下oracle安装图文教程（二）ORACLE 10.2.05版本的升级补丁安装
  • oracle for Linux 的补丁在哪里下？？我怎么在Oracle的站点上找不到？？
  • Linux下安装Oracle 11G的语义网补丁
  • [Oracle] Data Guard CPU/PSU补丁安装详细教程
  • [Oracle] CPU/PSU补丁安装详细教程
  • Oracle 12c发布简单介绍及官方下载地址
  • 在linux下安装oracle,如何设置让oracle自动启动！也就是让oracle那个服务自动启动，不是手动的
  • oracle 11g最新版官方下载地址
  • 请问su oracle 和su - oracle有什么不同？
  • Oracle 数据库(oracle Database)Select 多表关联查询方式
  • 虚拟机装Oracle R12与Oracle10g
  • Oracle数据库(Oracle Database)体系结构及基本组成介绍
  • Oracle 数据库开发工具 Oracle SQL Developer
  • 如何设置让Oracle SQL Developer显示的时间包含时分秒
  • Oracle EBS R12 支持 Oracle Database 11g
  • Oracle 10g和Oracle 11g网格技术介绍
  • SCO unix下安装oracle，但没有光盘，请大家推荐一个oracle下载站点（unix版本的）。谢谢！！！！
  • oracle中如何把表中具有相同值列的多行数据合并成一行
  • 请问大家用oracle数据库, 用import oracle.*;下的东西么? 还是用标准库?
  • Oracle 数据库(oracle Database)性能调优技术详解
  • Linux /$ORACLE_HOME $ORACLE_HOME
  • ORACLE日期相关操作
  • Linux系统下Oracle的启动与Oracle监听的启动
  • ORACLE数据库常用字段数据类型介绍
  • 请问在solaris下安装ORACLE，用root用户和用oracle用户安装有什么区别么？


    • 站内导航:


    特别声明:169IT网站部分信息来自互联网,如果侵犯您的权利,请及时告知,本站将立即删除！

    ©2012-2021,