当前位置:  数据库>oracle

Oracle 11.2.0.4.0打PSU到11.2.0.4.16-适用于新安装RAC,尚未创建数据库

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

    本文导语: 一、准备软件包 下载合适的OPatch以及最新的PSU补丁集,并上传到Oracle RAC各个节点服务器(节点1和节点2分别做下面的操作)[root@rac1 psu]# pwd /u01/psu [root@rac1 psu]# ll -rw-r--r--  1 root root 753393263 Oct 26 16:21 p23615403_112040_Linux-x86-64.zip ...

一、准备软件包
 下载合适的OPatch以及最新的PSU补丁集,并上传到Oracle RAC各个节点服务器(节点1和节点2分别做下面的操作)
[root@rac1 psu]# pwd
 /u01/psu
 [root@rac1 psu]# ll
 -rw-r--r--  1 root root 753393263 Oct 26 16:21 p23615403_112040_Linux-x86-64.zip
 -rw-r--r--  1 root root  52733900 Oct 26 16:20 p6880880_112000_Linux-x86-64.zip

二、升级grid以及Oracle用户的OPatch(节点1和节点2分别做下面的操作)
1、查看当前OPatch版本
[grid@rac1 ~]$ /u01/app/11.2.0/grid/OPatch/opatch version
 OPatch Version: 11.2.0.3.4
 OPatch succeeded.

 [oracle@rac1 ~]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch version
 OPatch Version: 11.2.0.3.4
 OPatch succeeded.

 2、升级Opatch
 [root@rac1 psu]# unzip p6880880_112000_Linux-x86-64.zip
 [root@rac1 psu]# mv /u01/app/11.2.0/grid/OPatch /u01/app/11.2.0/grid/OPatch_bak
 [root@rac1 psu]# cp -rp /u01/psu/OPatch /u01/app/11.2.0/grid/
 [root@rac1 psu]# chown -R grid:oinstall /u01/app/11.2.0/grid/OPatch
 [root@rac1 psu]# mv /u01/app/oracle/product/11.2.0/db_1/OPatch /u01/app/oracle/product/11.2.0/db_1/OPatch_bak
 [root@rac1 psu]# cp -rp /u01/psu/OPatch /u01/app/oracle/product/11.2.0/db_1/
 [root@rac1 psu]# chown -R oracle:oinstall /u01/app/oracle/product/11.2.0/db_1/OPatch

 3、验证升级
[grid@rac1 ~]$ /u01/app/11.2.0/grid/OPatch/opatch version
 OPatch Version: 11.2.0.3.12
 OPatch succeeded.

 [oracle@rac1 ~]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch version
 OPatch Version: 11.2.0.3.12
 OPatch succeeded.

三、生成ocm文件(节点1和2分别做下面的操作)
[grid@rac1 ~]$ cd /tmp/
 [grid@rac1 tmp]$ /u01/app/11.2.0/grid/OPatch/ocm/bin/emocmrsp
 OCM Installation Response Generator 10.3.7.0.0 - Production
 Copyright (c) 2005, 2012, Oracle and/or its affiliates.  All rights reserved.

 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
 The OCM configuration response file (ocm.rsp) was successfully created.
 [grid@rac1 tmp]$ chmod 777 ocm.rsp
 [grid@rac1 tmp]$ ll ocm.rsp
 -rwxrwxrwx 1 grid oinstall 621 Oct 26 17:20 ocm.rsp

四、升级database和grid软件(节点1和2分别做下面的操作)
1、解压PSU升级包
[root@rac1 psu]# mkdir 23615403
 [root@rac1 psu]# unzip p23615403_112040_Linux-x86-64.zip -d 23615403
 [root@rac1 psu]# chmod -R 777 23615403

 2、升级grid软件

[root@rac1 ~]# /u01/app/11.2.0/grid/OPatch/opatch auto /u01/psu/23615403/ -ocmrf /tmp/ocm.rsp
 Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir /u01/psu -patchn 23615403 -ocmrf /tmp/ocm.rsp -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params

 This is the main log file: /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2016-10-26_21-39-17.log

 This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
 /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2016-10-26_21-39-17.report.log

 2016-10-26 21:39:17: Starting Clusterware Patch Setup
 Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params

 Stopping CRS...
 Stopped CRS successfully

 patch /u01/psu/23615403/23054359  apply successful for home  /u01/app/11.2.0/grid
 patch /u01/psu/23615403/23054319  apply successful for home  /u01/app/11.2.0/grid
 patch /u01/psu/23615403/22502505  apply successful for home  /u01/app/11.2.0/grid

 Starting CRS...
 Installing Trace File Analyzer
 CRS-4123: Oracle High Availability Services has been started.

 opatch auto succeeded.

验证grid升级情况:
[grid@rac1 ~]$ /u01/app/11.2.0/grid/OPatch/opatch lspatches
 22502505;ACFS Patch Set Update : 11.2.0.4.160419 (22502505)
 23054319;OCW Patch Set Update : 11.2.0.4.160719 (23054319)
 23054359;Database Patch Set Update : 11.2.0.4.160719 (23054359)

 OPatch succeeded.


 3、升级Oracle database软件
[root@rac1 ~]# /u01/app/11.2.0/grid/OPatch/opatch auto /u01/psu/23615403/ -ocmrf /tmp/ocm.rsp -oh /u01/app/oracle/product/11.2.0/db_1/
 Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir /u01/psu -patchn 23615403 -ocmrf /tmp/ocm.rsp -oh /u01/app/oracle/product/11.2.0/db_1/ -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params

 This is the main log file: /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2016-10-26_21-53-22.log

 This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
 /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2016-10-26_21-53-22.report.log

 2016-10-26 21:53:22: Starting Clusterware Patch Setup
 Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params

 Stopping RAC /u01/app/oracle/product/11.2.0/db_1 ...
 Stopped RAC /u01/app/oracle/product/11.2.0/db_1 successfully

 patch /u01/psu/23615403/23054359  apply successful for home  /u01/app/oracle/product/11.2.0/db_1
 patch /u01/psu/23615403/23054319/custom/server/23054319  apply successful for home  /u01/app/oracle/product/11.2.0/db_1
 patch /u01/psu/23615403/23177551  apply successful for home  /u01/app/oracle/product/11.2.0/db_1

 Starting RAC /u01/app/oracle/product/11.2.0/db_1 ...
 Started RAC /u01/app/oracle/product/11.2.0/db_1 successfully

 opatch auto succeeded.

验证Oracle database升级情况:
[root@rac1 ~]# su - oracle
 [oracle@rac1 ~]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch lspatches
 23177551;OJVM PATCH SET UPDATE 11.2.0.4.160719
 23054319;OCW Patch Set Update : 11.2.0.4.160719 (23054319)
 23054359;Database Patch Set Update : 11.2.0.4.160719 (23054359)

 OPatch succeeded.


    
 
 

您可能感兴趣的文章:

 
本站(WWW.)旨在分享和传播互联网科技相关的资讯和技术,将尽最大努力为读者提供更好的信息聚合和浏览方式。
本站(WWW.)站内文章除注明原创外,均为转载、整理或搜集自网络。欢迎任何形式的转载,转载请注明出处。












  • 相关文章推荐
  • Oracle删除当前用户下所有表的方法适用于有或没有删除权限
  • Oracle中Union与Union All的区别(适用多个数据库)
  • 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用户安装有什么区别么?
  • Oracle 12c的九大最新技术特性介绍
  • 网间Oracle的连接,远程连接Oracle服务器??


  • 站内导航:


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

    ©2012-2021,,E-mail:www_#163.com(请将#改为@)

    浙ICP备11055608号-3