打补丁p19023822_112040_Linux-x86-64
补丁下载地址
https://updates.oracle.com/Orion/PatchDetails/handle_rel_change?release=80112040&plat_lang=226P&patch_file=&file_id=&password_required=&password_required_readme=&merged_trans=&aru=22040584&patch_num=19023822&patch_num_id=3323200&default_release=80112040&default_plat_lang=226P&default_compatible_with=&patch_password=&orderby=1&direction=a&no_header=0&sortcolpressed=&tab_number=&email=516036499%40qq.com&userid=o-516036499%40qq.com
选择与数据库版本一致的补丁版本,我这里选择11.2.0.4.0版本
1.设置opatch环境变量
export PATH=$ORACLE_HOME/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/X11R6/bin:/bin:$ORACLE_HOME/OPatch
2.上传补丁包到相应目录
我这里上传到oralce home目录下
[root@localhost oracle]# chown oracle:oinstall /home/oracle/p19023822_112040_Linux-x86-64.zip
3.解压补丁包
[oracle@localhost ~]$ unzip p19023822_112040_Linux-x86-64.zip
该补丁包可以停机安装和在线安装的,我们这里采用的是在线安装,仔细阅读README.txt,按照提示进行安装打补丁
2.2) Installing in Online Mode
-----------------------------------
To install the patch in online mode, follow these steps:
1. Set your current directory to the directory where the patch is located and then run the OPatch utility by entering the following commands:
$ cd <PATCH_TOP_DIR>/19023822
2. Install the patch by running the following command:
- For Non-RAC Environments (Standalone Databases):
$ opatch apply online -connectString <SID>:<USERNAME>:<PASSWORD>:
- For RAC Environments:
$ opatch apply online -connectString <SID_Node1>:<Username_Node1>:<Password_Node1>:<Node1_Name>,<SID_Node2>:<Username_Node2>:<Password_Node2>:<Node2_Name>,<SID_NodeN>:<Username_NodeN>:<Password_NodeN>:<NodeN_Name>
Note:
- Run the previous command on the first node of the Oracle RAC system, and specify details of each node separated by a comma. In the command, NodeN refers to the different nodes of the Oracle RAC system. Once the patch is applied on the first node, OPatch automatically moves over and patches the next node you have specified in the comamnd.
Note:Patch Post Install Steps:
link oracle
具体操作过程:
登陆到补丁目录
[oracle@localhost ~]$ cd 19023822/
我这里是单节点的数据库,采用如下安装方式安装:
[oracle@localhost 19023822]$ opatch apply online -connectString slnngkdg:sys:oracle
Oracle Interim Patch Installer version 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0.4/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0.4/db_1/oraInst.loc
OPatch version : 11.2.0.3.4
OUI version : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0.4/db_1/cfgtoollogs/opatch/19023822_May_12_2020_17_35_27/apply2020-05-12_17-35-26PM_1.log
The patch should be applied/rolled back in '-all_nodes' mode only.
Converting the RAC mode to '-all_nodes' mode.
Applying interim patch '19023822' to OH '/u01/app/oracle/product/11.2.0.4/db_1'
Verifying environment and performing prerequisite checks...
All checks passed.
Backing up files...
Patching component oracle.rdbms, 11.2.0.4.0...
Installing and enabling the online patch 'bug19023822.pch', on database 'slnngkdg'.
Verifying the update...
Patch 19023822 successfully applied
Log file location: /u01/app/oracle/product/11.2.0.4/db_1/cfgtoollogs/opatch/19023822_May_12_2020_17_35_27/apply2020-05-12_17-35-26PM_1.log
OPatch succeeded.
3.检查是否安装了
[oracle@localhost 19023822]$ opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0.4/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0.4/db_1/oraInst.loc
OPatch version : 11.2.0.3.4
OUI version : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0.4/db_1/cfgtoollogs/opatch/opatch2020-05-12_17-37-52PM_1.log
Lsinventory Output file location : /u01/app/oracle/product/11.2.0.4/db_1/cfgtoollogs/opatch/lsinv/lsinventory2020-05-12_17-37-52PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 11g 11.2.0.4.0
There are 1 products installed in this Oracle Home.
Interim patches (1) :
Patch (online) 19023822: applied on Tue May 12 17:35:33 CST 2020
Unique Patch ID: 17884511
Created on 28 Jul 2014, 20:54:00 hrs PST8PDT
Bugs fixed:
19023822
--------------------------------------------------------------------------------
OPatch succeeded.
4.补丁回滚
[oracle@localhost 19023822]$ opatch rollback -id 19023822 -connectString slnngkdg:sys:oracle
相关文章
- Linux 进程
- Ubuntu 解决 pip 安装 lxml 出现 x86_64-linux-gnu-gcc 异常
- 64分布式电商项目 - Linux下安装nginx(超详细)
- Linux系统管理员不可不知的命令:sudo
- Linux集群和自动化维1.4 CentOS 6.4 x86_64最小化安装后的优化
- 如何在Linux下创建一个不可变更的文件
- Linux有问必答:如何为在Linux中安装兄弟牌打印机
- linux内核启动时报错ubi0 error: validate_ec_hdr: bad VID header offset 256, expected 64
- 【Linux】—常用命令(测试人员)
- Kali Linux下运行Sniffjoke出错的解决
- linux主编号的动态分配
- Qt编写跨平台视频监控系统(64通道占用7%CPU/支持win_linux_mac等)
- 一、linux扩展
- Linux(四)日志管理
- Linux常用基本命令(head)
- Configuring HugePages for Oracle on Linux (x86-64)
- 回收站功能在 Linux 中的实现
- 【正点原子FPGA连载】第三十章Linux按键输入实验 摘自【正点原子】DFZU2EG_4EV MPSoC之嵌入式Linux开发指南
- 如何优化及安全设置Linux系统
- 如何看linux是32位还是64位--转
- Linux编译遇到各种错误解决方法,例如 /lib/modules/3.10.0-(xxx).el7.x86_64/build: No such file or directory. Stop.
- 64位linux 汇编
- 联想否认锁住设备以及阻止用户安装Linux
- linux 常见名词及命令(一)
- Linux安装Mysql server镜像安装失败 警告:mysql-community-devel-8.0.31-1.el7.x86_64.rpm: 头V4 RSA/SHA256 Signature