Oracle 11g升级PSU详细步骤

2023-12-23 15:48
文章标签 oracle 步骤 详细 升级 11g psu

本文主要是介绍Oracle 11g升级PSU详细步骤,希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!

Oracle 每个季度都会发布最新的补丁。对于生产运维人员来说,定期升级系统、打补丁是日常工作中不可缺少的部分。

 相对于过去的版本,Oracle打补丁的方式已经变得比较简单,处理PSU的方法也发生了一些变化。在11g中,对于一些小bug的修复,我们可以使用OPatch工具进行补丁修复。对于大的版本升级,Oracle的PSU实际上就是一系列全新的安装文件,从MOS上下载之后就可以直接进行安装。

1、关闭数据库

Oracle的PSU升级不更新数据字典,风险较小,但是还是需要停库进行升级操作。

SQL> shutdown immediate

Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
停止监听服务。
[oracle@bntjftest 20299015]$ lsnrctl stop
检查服务进程
[oracle@bntjftest 20299015]$  ps aux | grep ora_
oracle    6922  0.0  0.0  5700  796 pts/3    S+  17:48  0:00 grep ora_
[oracle@bntjftest 20299015]$  ps aux | grep tns
oracle    6924  0.0  0.0  5704  796 pts/3    S+  17:48  0:00 grep tns

2、检查opatch版本信息,需要的话进行升级


 

[oracle@bntjftest OPatch]$ ./opatch version
OPatch Version: 11.2.0.1.7
OPatch succeeded.

检查发现opatch版本较低,为默认版本,所以需要升级opatch。升级方法很简单,直接mv掉原来的opatch目录,然后解压最新版本的opatch软件到ORACLE_HOME下面即可

[oracle@bntjftest OPatch]$ unzip p6880880_112000_Linux-x86-64-opatch .zip  -d $ORACLE_HOME

再次检查版本,发现已经升级成功。
[oracle@bntjftest OPatch]$  ./opatch version
OPatch Version: 11.2.0.3.6
OPatch succeeded.


3、应用PSU补丁

 


1)插曲一、安装程序错误

[oracle@bntjftest OPatch]$ ./opatch apply ./20299015/
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation.  All rights reserved.

Oracle Home      : /app/oracle/product/11.2.0/dbhome_1
Central Inventory : /app/oraInventory
  from          : /app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version    : 11.2.0.3.6
OUI version      : 11.2.0.4.0
Log file location : /app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2015-05-14_10-45-03AM_1.log


Verifying environment and performing prerequisite checks...
Prerequisite check "CheckPatchApplicableOnCurrentPlatform" failed.
The details are:
Patch ( 20299015 ) is not applicable>UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.
Log file location: /app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2015-05-14_10-45-03AM_1.log
OPatch failed with error code 73


不使用自动模式,手工运行,一样报错:

[oracle@bntjftest 20299015]$ /app/oracle/product/11.2.0/dbhome_1/OPatch/opatch napply -skip_subset -skip_duplicate
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation.  All rights reserved.

Oracle Home      : /app/oracle/product/11.2.0/dbhome_1
Central Inventory : /app/oraInventory
  from          : /app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version    : 11.2.0.3.6
OUI version      : 11.2.0.4.0
Log file location : /app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2015-05-14_10-45-03AM_1.log


Verifying environment and performing prerequisite checks...
Prerequisite check "CheckPatchApplicableOnCurrentPlatform" failed.
The details are:
Patch ( 20299015 ) is not applicable>UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.
Log file location: /app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2015-05-14_10-45-03AM_1.log
OPatch failed with error code 73

 


上网baidu,“ UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed”, 很快就查到解决办法,明确了其实就是因为有用户进程占用了文件libclntsh.so.11

[oracle@bntjftest 20299015]$  /sbin/fuser /app/oracle/product/11.2.0/dbhome_1/lib/libclntsh.so.11 .1
/app/oracle/product/11.2.0/dbhome_1/lib/libclntsh.so.11.1:  16470m
[oracle@bntjftest 20299015]$  ps -ef | grep 16470
oracle    16470 5399  0 14:45 pts/2    00:00:00 sqlplus  as sysdba
oracle    7780  6617  0 18:47 pts/3    00:00:00 grep 16470
[oracle@bntjftest 20299015]$  kill -9  16470
[oracle@bntjftest 20299015]$  /sbin/fuser /app/oracle/product/11.2.0/dbhome_1/lib/libclntsh.so.11.1


3)再次重新应用PSU补丁,成功


[oracle@bntjftest 20299015]$ /app/oracle/product/11.2.0/dbhome_1/OPatch/opatch napply -skip_subset -skip_duplicate
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation.  All rights reserved.

Oracle Home      : /app/oracle/product/11.2.0/dbhome_1
Central Inventory : /app/oraInventory
  from          : /app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version    : 11.2.0.3.6
OUI version      : 11.2.0.4.0
Log file location : /app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2015-05-14_10-45-03AM_1.log


Verifying environment and performing prerequisite checks...
OPatch continues with these patches:  [17811429 17811438 17811447 18203835 18203837 18203838 19463893 19544839 19584068 19972564 19972566 19972568 19972569 20142975 20299015 20506699 20506715 20631274]


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

OPatch Session completed with warnings.
 Log file location: /app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2015-05-14_10-45-03AM_1.log

OPatch completed with warnings.


 

 

 

 

4、检查应用之后的结果

[oracle@bntjftest 20299015]$ ../opatch lspatches
 20631274;
 20506715;
 20506699;
 20299015;
 20142975;
 19972569;
 19972568;
 19972566;
 19972564;
 19584068;
 19544839;
 19463893;
 18203838;
 18203837;
 18203835;
 17811447;
 17811438;
 17811429;

[oracle@bntjftest 20299015]$ ../opatch lsinventory
 Oracle Interim Patch Installer version 11.2.0.3.6
 Copyright (c) 2013, Oracle Corporation.  All rights reserved.


 Oracle Home      : /app/oracle/product/11.2.0/dbhome_1
 Central Inventory : /app/oraInventory
    from          : /app/oracle/product/11.2.0/dbhome_1/oraInst.loc
 OPatch version    : 11.2.0.3.6
 OUI version      : 11.2.0.4.0
 Log file location : /app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2015-05-14_11-04-15AM_1.log

Lsinventory Output file location : /app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2015-05-14_11-04-15AM.txt

--------------------------------------------------------------------------------
 Installed Top-level Products (1):

Oracle Database 11g                                                  11.2.0.4.0
 There are 1 product(s) installed in this Oracle Home.


 Interim patches (18) :

Patch  20631274    : applied on Wed May 13 17:11:06 CST 2015
 Unique Patch ID:  18695736
    Created on 13 Mar 2015, 10:25:35 hrs PST8PDT
    Bugs fixed:
      20296213, 17600719, 19458377, 19554106, 20631274, 16524926, 19466309

Patch  20506715    : applied on Wed May 13 17:11:02 CST 2015
 Unique Patch ID:  18695736
    Created on 13 Mar 2015, 10:23:10 hrs PST8PDT
    Bugs fixed:
      19049453, 19915271, 16450169, 17006570, 17811456, 18554871, 17786278
      18096714, 18744139, 20506715, 18061914

Patch  20506699    : applied on Wed May 13 17:10:57 CST 2015
 Unique Patch ID:  18695736
    Created on 13 Mar 2015, 11:23:48 hrs PST8PDT
    Bugs fixed:
      20506699, 19358317, 19197175, 19972570, 17762296

Patch  20299015    : applied on Wed May 13 17:10:54 CST 2015
 Unique Patch ID:  18695736
    Created on 13 Mar 2015, 10:28:05 hrs PST8PDT
    Bugs fixed:
      20299015, 18139690, 18681862, 17343514, 19727057, 19271443, 19854503, 17551709

Patch  20142975    : applied on Wed May 13 17:10:53 CST 2015
 Unique Patch ID:  18406185
    Created on 22 Dec 2014, 00:47:05 hrs PST8PDT
    Bugs fixed:
      19827973, 19463897, 19289642, 20142975

Patch  19972569    : applied on Wed May 13 17:10:51 CST 2015
 Unique Patch ID:  18406185
    Created on 22 Dec 2014, 00:21:09 hrs PST8PDT
    Bugs fixed:
      19972569, 19006849

Patch  19972568    : applied on Wed May 13 17:10:50 CST 2015
 Unique Patch ID:  18406185
    Created on 22 Dec 2014, 00:13:36 hrs PST8PDT
    Bugs fixed:
      19972568, 19309466

Patch  19972566    : applied on Wed May 13 17:10:48 CST 2015
 Unique Patch ID:  18406185
    Created on 22 Dec 2014, 00:03:20 hrs PST8PDT
    Bugs fixed:
      19972566, 18641461, 18641451

Patch  19972564    : applied on Wed May 13 17:10:45 CST 2015
 Unique Patch ID:  18406185
    Created on 21 Dec 2014, 23:54:58 hrs PST8PDT
    Bugs fixed:
      19972564, 18436647

Patch  19584068    : applied on Wed May 13 17:10:43 CST 2015
 Unique Patch ID:  18084194
    Created on 24 Sep 2014, 07:43:52 hrs PST8PDT
    Bugs fixed:
      18262334, 19584068

Patch  19544839    : applied on Wed May 13 17:10:40 CST 2015
 Unique Patch ID:  18084194
    Created on 11 Oct 2014, 01:43:34 hrs PST8PDT
    Bugs fixed:
      18673325, 19544839, 19211724, 18673304

Patch  19463893    : applied on Wed May 13 17:10:26 CST 2015
 Unique Patch ID:  18084194
    Created on 24 Sep 2014, 06:28:06 hrs PST8PDT
    Bugs fixed:
      19463893, 18641419

Patch  18203838    : applied on Wed May 13 17:10:24 CST 2015
 Unique Patch ID:  17351342
    Created on 26 Feb 2014, 23:57:58 hrs PST8PDT
    Bugs fixed:
      17865671, 18203838

Patch  18203837    : applied on Wed May 13 17:10:21 CST 2015
 Unique Patch ID:  17351342
    Created on 26 Feb 2014, 23:48:38 hrs PST8PDT
    Bugs fixed:
      17716305, 18203837

Patch  18203835    : applied on Wed May 13 17:10:19 CST 2015
 Unique Patch ID:  17351342
    Created on 26 Feb 2014, 23:43:04 hrs PST8PDT
    Bugs fixed:
      17721717, 18203835

Patch  17811447    : applied on Wed May 13 17:10:17 CST 2015
 Unique Patch ID:  17066906
    Created on 11 Dec 2013, 02:20:51 hrs PST8PDT
    Bugs fixed:
      17811447, 17088068

Patch  17811438    : applied on Wed May 13 17:10:15 CST 2015
 Unique Patch ID:  17066906
    Created on 11 Dec 2013, 02:37:11 hrs PST8PDT
    Bugs fixed:
      17811438, 16721594

Patch  17811429    : applied on Wed May 13 17:10:13 CST 2015
 Unique Patch ID:  17066906
    Created on 11 Dec 2013, 02:36:54 hrs PST8PDT
    Bugs fixed:
      17811429, 13944971

 

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

OPatch succeeded.


SQL> select * from dba_registry_history;


ACTION_TIME                    ACTION  NAMESPAC VERSION            ID BUNDL COMMENTS
 ------------------------------ -------- -------- ---------- ---------- ----- --------------------
 05-MAY-15 09.24.08.184589 AM  APPLY    SERVER  11.2.0.4            0 PSU  Patchset 11.2.0.2.0
 13-MAY-15 05.17.48.578053 PM  APPLY    SERVER  11.2.0.4            6 CPU  CPUApr2015


2 rows selected.

这篇关于Oracle 11g升级PSU详细步骤的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!



http://www.chinasem.cn/article/528570

相关文章

ubuntu20.0.4系统中安装Anaconda的超详细图文教程

《ubuntu20.0.4系统中安装Anaconda的超详细图文教程》:本文主要介绍了在Ubuntu系统中如何下载和安装Anaconda,提供了两种方法,详细内容请阅读本文,希望能对你有所帮助... 本文介绍了在Ubuntu系统中如何下载和安装Anaconda。提供了两种方法,包括通过网页手动下载和使用wg

ubuntu系统使用官方操作命令升级Dify指南

《ubuntu系统使用官方操作命令升级Dify指南》Dify支持自动化执行、日志记录和结果管理,适用于数据处理、模型训练和部署等场景,今天我们就来看看ubuntu系统中使用官方操作命令升级Dify的方... Dify 是一个基于 docker 的工作流管理工具,旨在简化机器学习和数据科学领域的多步骤工作流。

SpringBoot实现二维码生成的详细步骤与完整代码

《SpringBoot实现二维码生成的详细步骤与完整代码》如今,二维码的应用场景非常广泛,从支付到信息分享,二维码都扮演着重要角色,SpringBoot是一个非常流行的Java基于Spring框架的微... 目录一、环境搭建二、创建 Spring Boot 项目三、引入二维码生成依赖四、编写二维码生成代码五

Oracle 通过 ROWID 批量更新表的方法

《Oracle通过ROWID批量更新表的方法》在Oracle数据库中,使用ROWID进行批量更新是一种高效的更新方法,因为它直接定位到物理行位置,避免了通过索引查找的开销,下面给大家介绍Orac... 目录oracle 通过 ROWID 批量更新表ROWID 基本概念性能优化建议性能UoTrFPH优化建议注

PostgreSQL 序列(Sequence) 与 Oracle 序列对比差异分析

《PostgreSQL序列(Sequence)与Oracle序列对比差异分析》PostgreSQL和Oracle都提供了序列(Sequence)功能,但在实现细节和使用方式上存在一些重要差异,... 目录PostgreSQL 序列(Sequence) 与 oracle 序列对比一 基本语法对比1.1 创建序

Java中 instanceof 的用法详细介绍

《Java中instanceof的用法详细介绍》在Java中,instanceof是一个二元运算符(类型比较操作符),用于检查一个对象是否是某个特定类、接口的实例,或者是否是其子类的实例,这篇文章... 目录引言基本语法基本作用1. 检查对象是否是指定类的实例2. 检查对象是否是子类的实例3. 检查对象是否

IDEA之MyBatisX使用的图文步骤

《IDEA之MyBatisX使用的图文步骤》本文主要介绍了IDEA之MyBatisX使用,文中通过图文示例介绍的非常详细,对大家的学习或者工作具有一定的参考学习价值,需要的朋友们下面随着小编来一起学习... 目录一、idea插件安装二、IDEA配置数据库连接(以mysql为例)三、生产基础代码一、idea插

将图片导入Python的turtle库的详细过程

《将图片导入Python的turtle库的详细过程》在Python编程的世界里,turtle库以其简单易用、图形化交互的特点,深受初学者喜爱,随着项目的复杂度增加,仅仅依靠线条和颜色来绘制图形可能已经... 目录开篇引言正文剖析1. 理解基础:Turtle库的工作原理2. 图片格式与支持3. 实现步骤详解第

Docker安装MySQL镜像的详细步骤(适合新手小白)

《Docker安装MySQL镜像的详细步骤(适合新手小白)》本文详细介绍了如何在Ubuntu环境下使用Docker安装MySQL5.7版本,包括从官网拉取镜像、配置MySQL容器、设置权限及内网部署,... 目录前言安装1.访问docker镜像仓库官网2.找到对应的版本,复制右侧的命令即可3.查看镜像4.启

debian12安装docker的实现步骤

《debian12安装docker的实现步骤》本文主要介绍了debian12安装docker的实现步骤,文中通过示例代码介绍的非常详细,对大家的学习或者工作具有一定的参考学习价值,需要的朋友们下面随着... 目录步骤 1:更新你的系统步骤 2:安装依赖项步骤 3:添加 docker 的官方 GPG 密钥步骤