Oracle 11.2.0.4打补丁的方法

最新推荐文章于 2024-03-20 13:55:06 发布

蚁库

最新推荐文章于 2024-03-20 13:55:06 发布

阅读量343

点赞数

文章标签： oracle 数据库 dba

本文链接：https://blog.csdn.net/weixin_52805903/article/details/127314616

版权

一、概述

本文主要介绍了Oracle 11.2.0.3 升级到11.2.0.4的补丁的方法，本文给大家介绍的非常详细，具有一定的参考借鉴价值,需要的朋友可以参考下

二、打补丁

所需补丁及高版本opatch
解压补丁
image上传后将p6880880_112000_Linux-x86-64.zip解压覆盖$ORACLE_HOME/OPatch目录即可

[oracle@localhost OPatch]$ ./opatch version
OPatch Version: 11.2.0.3.16
 
OPatch succeeded.

检查环境是否需要打补丁，opatch版本安装环境可以看mos和readme 查看组件信息

12:40:47 SYS@std> set linesize 500 pagesize 600
12:40:49 SYS@std> col COMP_NAME for a30
12:41:06 SYS@std> select COMP_ID,COMP_NAME,VERSION,STATUS from DBA_REGISTRY;
COMP_ID      COMP_NAME      VERSION      STATUS
------------------------------ ------------------------------ ------------------------------ --------------------------------------------
OWB       OWB       11.2.0.4.0      VALID
APEX       Oracle Application Express  3.2.1.00.12     VALID
EM        Oracle Enterprise Manager  11.2.0.4.0      VALID
AMD       OLAP Catalog     11.2.0.4.0      VALID
SDO       Spatial      11.2.0.4.0      VALID
ORDIM       Oracle Multimedia    11.2.0.4.0      VALID
XDB       Oracle XML Database   11.2.0.4.0      VALID
CONTEXT      Oracle Text     11.2.0.4.0      VALID
EXF       Oracle Expression Filter  11.2.0.4.0      VALID
RUL       Oracle Rules Manager   11.2.0.4.0      VALID
OWM       Oracle Workspace Manager  11.2.0.4.0      VALID
CATALOG      Oracle Database Catalog Views 11.2.0.4.0      VALID
CATPROC      Oracle Database Packages and T 11.2.0.4.0      VALID
        ypes
JAVAVM       JServer JAVA Virtual Machine 11.2.0.4.0      VALID
XML       Oracle XDK      11.2.0.4.0      VALID
CATJAVA      Oracle Database Java Packages 11.2.0.4.0      VALID
APS       OLAP Analytic Workspace  11.2.0.4.0      VALID
XOQ       Oracle OLAP API    11.2.0.4.0      VALID
18 rows selected.
Elapsed: 00:00:00.04

查看补丁情况

12:46:11 SYS@std> select count(*) from dba_objects where status<>'VALID';
  
 COUNT(*)
----------
   0

测试兼容性，如果之前没打过，这步可以忽略

[oracle@localhost OPatch]$ ./opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/oracle/28689165/ -oh $ORACLE_HOME  
Oracle Interim Patch Installer version 11.2.0.3.16
Copyright (c) 2019, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home  : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
 from   : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.16
OUI version  : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2019-03-22_13-02-45PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.

为数据库做冷备份,因为是学习用的库不是生产库，这步骤省了停库停止数据库外部进程

ps -ef|grep -v grep |grep LOCAL=NO|awk '{print $2}'|xargs kill -9

停库

13:11:12 SYS@std> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
13:11:28 SYS@std>

停止监听

[oracle@localhost OPatch]$ lsnrctl stop
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 22-MAR-2019 13:12:51
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
The command completed successfully
[oracle@localhost OPatch]$

查看是否停干净

[oracle@localhost OPatch]$ ps -ef |grep ora_|grep -v grep
[oracle@localhost OPatch]$ netstat -an |grep 1158
[oracle@localhost OPatch]$ netstat -an|grep 1521
[oracle@localhost OPatch]$

正式打补丁

[oracle@localhost OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.16
Copyright (c) 2019, Oracle Corporation. All rights reserved.
Oracle Home  : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
 from   : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.16
OUI version  : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2019-03-25_08-44-35AM_1.log
Lsinventory Output file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2019-03-25_08-44-35AM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: localhost
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Database 11g             11.2.0.4.0
There are 1 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@localhost OPatch]$
 
./opatch napply -oh $ORACLE_HOME -local /home/oracle/28689165
many more lines compressed..
 1. make -f /u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ins_emagent.mk new_ld_shlib _FULL_LIBNAME=/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/libnmcfhc.so _LIBNAME=libnmcfhc _LIBDIR=/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ '_LIBNAME_LIBS=$(libnmcfhcLIBS)' '_LIBNAME_EXTRALIBS=$(libnmcfhcEXTRALIBS)'
 2. PATH=/bin:/usr/bin