Oracle11g Patch level list

最新推荐文章于 2025-09-09 17:00:50 发布
转载 最新推荐文章于 2025-09-09 17:00:50 发布 · 245 阅读 · 0
文章标签：

#数据库

本文介绍了如何通过SQL查询和opatchlsinventory两种方式，获取和查看软件包信息的方法，提供了实用的技术指导。
除了用opatch lsinventory 查看外，

还可以通过
select * from sys.registry$history;
来查看

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/3637/viewspace-748805/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/3637/viewspace-748805/

cuhao8037
关注
（第75天）AutoUpgrade 升级：11GR2 到 19C
LuciferLiu_DBA
03-24 867
Oracle 从 12CR2 开始就开始大力推广 AutoUpgrade 升级工具，但是实际生产中使用并不广泛，但是这个工具已经发展的非常成熟了。本文介绍一下如何使用 AutoUpgrade 工具进行快速升级，操作非常简单。
查看及管理Oracle patch
Ora-onway
04-16 1022
Oracle patch也即是Oracle补丁。Oracle补丁又包含好几个种类，小的补丁简直是难以数计，难免让人眼花缭乱。尽管如此，Oracle patch还是有序可循的。而且Oracle提供的opatch工具非常方便的用于安装oracle patch，以及查看当前系统已经安装的patch。本文列出了patch的几种类型，以及主要描述通过opatch工具查看当前数据库的patch应用的情况。对于
17.OracleRAC 打补丁报：CRS-6706 patch level 不一致
weixin_43346403的博客
02-09 538
Oracle RAC补丁安装
查找打补丁后修复的BUG命令
babymouse1212的博客
05-02 592
-bash-3.2$ opatch lsinventory -bugs_fixed|grep 12879027 或者使用以下查询： select * from sys.registry$history
Oracle打补丁笔记
TEST_ID_KING的博客
09-09 271
也就是说，用户对于同一操作，无论是发起一次请求还是多次请求，最终的执行结果是一致的，不会因为多次点击而产生副作用。CPU补丁 Critical Patch Update 针对高危漏洞的修复。幂等操作一般是指我们在进行多次操作时，所得到的结果是一样的，即多次运算结果是一致的。离线安装 需要关闭数据库实例和监听器 适合在维护窗口内进行，操作简单。幂等操作是指在使用相同的参数调用超过一次时，没有任何额外效果的操作。补丁安装顺序：GI->DB->OJVM。
日常维护SQL以及脚本
weixin_30444021的博客
07-06 1242
----调整DG的传输进程为ARCH ics:   alter system set  log_archive_dest_3 ='SERVICE=lics arch async noaffirm reopen=60 valid_for=(online_logfiles,primary_role) db_unique_name=lics' scope =both;
UOS统信服务器版本V20 1070A安装部署Oracle11g数据库
limin741231475963的博客
07-15 3770
UOS统信服务器版本V20 1070A安装部署Oracle11g数据库
Patch level不一致，导致的集群无法启动
文档搬运工
07-26 1053
4 dump出olr的内容，发现olr中的patch level确实不一样，参考文档Grid Infrastructure 启动的五大问题 (Doc ID 1526147.1)，尝试重建olr，无效。安装完毕后，发现集群的CRS无法启动。查看节点1和节点2上的patch ，发现节点2上多了29517242这个补丁，这个是19.3。2 回退掉补丁后，尝试使用opatchauto方式打GI补丁，可以正常打上补丁，但问题依旧。5 发现节点2上多了29517242这个补丁，这个是19.3 ，卸载补丁，无法卸载。
Oracle Linux安装Oracle 11G R2 ASM+RAC
热门推荐
qq_35413116的博客
04-17 1万+
Oracle Linux安装Oracle11GR2 ASM+RAC 项目规划： 业务环境：HIS系统 物理机的配置：双CPU,28核/颗，256G,447G SSD硬盘。 主机名：his101/his102 IP地址：192.168.1.201-205 OS版本: OracleLinux-R7-U6-Server-x86_64 数据库版本：Oracle版本11g（Oracle 11.2.0.4....
Oracle 11g R2 RAC 增加节点详解（一）
moscot_wu的博客
05-19 1万+
最近准备给我的RAC环境加个节点，看了下官网，表示写的很简单，也应该是比较简单 第一步当然是准备一台虚拟机，最好是host01的拷贝，在未安装前，安装完毕后 $ cluvfy stage -pre nodeadd -n node3 [-fixup [-fixupdir fixup_dir]] [-verbose]这一步一般开始都不会通过PRVF-4007，原因是新增的主机并未进行SSH用户等效
Patch for vasp.5.4.4.18Apr17-6-g9f103f2a35
04-18
For vasp.5.4.4.18Apr17-6-g9f103f2a35 The following patch addresses a few issues: Fixes a bug in the stress term when using the SCAN functional in certain pathological cases. Fixes a bug in the Thomas-Fermi potential. Fixes a bug that affected the optB88 for some atoms and molecules. Fixes some issues with the BSE at finite q. and adds support for: The CX13 vdW-DFT functional. To apply this patch gunzip the patch file and patch -p0 < patch.5.4.4.16052018 within your vasp.X.X.X root-directory.
VASP_5.4.4版
06-08
第一性原理计算软件VASP最新版，.tar.gz格式，比之前的小好下载
DBA_REGISTRY_HISTORY
文档搬运工
12-06 1939
参考文档：https://docs.oracle.com/cd/B28359_01/server.111/b28320/statviews_4199.htm#REFRN23549 DBA_REGISTRY_HISTORY provides information about upgrades, downgrades, and critical patch updates that have be...
CRS-6706 patch level 不一致
whb234174124的博客
07-28 2453
19.3.0.0RAC的2节点打补丁失败，导致2节点集群无法启动报错： [root@rac19c2 soft]# /u01/app/11.2.0/grid/bin/crsctl start crs CRS-6706: Oracle Clusterware Release patch level ('4203896349') does not match Software patch level...
CRS-6706: Oracle Clusterware Release patch level ('3329448500') does not match Software patch level
sqlora的专栏
11-15 3159
oracle19.3.0.0 rac+centos7.6 补丁为19.5.0.0 启动crs报错如下： [root@rac2 ~]# /oracle/app/19c/grid/bin/crsctl start crsCRS-6706: Oracle Clusterware Release patch level ('3329448500') does not match Software p...
Oracle Patch补丁体系和如何打补丁
congdingfu1756的博客
11-27 829
Oracle作为大型商用关系型数据库，从其补丁体系就可以看出其考虑的全面性。首先我们看下Oracle Patch的主要类型[参考1和2]： Version/维护版本 针对前一个维护版本的所有补丁进行整理，增...
Oracle 19c rac PSU安装及问题 - CRS-6706: Oracle Clusterware Release patch level ('nnn') does not match
文档搬运工
04-30 3103
-- 19c rac 19.3.0.0 安装PSU 19.7.0.0.200414 /stage 下的补丁文件夹的属性是grid:oinstall --GI用户下 $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /stage/30899722/30869156 $ORACLE_HOM...
如何用oracle 12c,如何在oracle 12c中正确的应用补丁?
weixin_32940141的博客
04-11 382
问题描述在HP-UX上执行asmcmd会出现下面的错误，为了解决这个bug，需要应用补丁20948770，内容如下：ohsdb1#[/home/orgrid]asmcmdUse of uninitialized value in subroutine entry at /pgold/orgrid/oracle/product/121/lib/asmcmdbase.pm line 5086.pani...
翻译下面内容 Oracle Database 11g Release 11.2.0.4.0 ORACLE DATABASE Patch for Bug# 8857940 for AIX5L Platforms This patch is RAC Rolling Installable - Please read My Oracle Support Document 244241.1 https://support.us.oracle.com/oip/faces/secure/km/DocumentDisplay.jspx?id=244241.1 Rolling Patch - OPatch Support for RAC. This patch is Data Guard Standby-First Installable - Please read My Oracle Support Note 1265700.1 https://support.us.oracle.com/oip/faces/secure/km/DocumentDisplay.jspx?id=1265700.1 Oracle Patch Assurance - Data Guard Standby-First Patch Apply for details on how to remove risk and reduce downtime when applying this patch. Released: Sat Jun 11 09:03:01 2016 This document describes how you can install the ORACLE DATABASE interim patch for bug# 8857940 on your Oracle Database 11g Release 11.2.0.4.0 (I) Prerequisites -------------------- Before you install or deinstall the patch, ensure that you meet the following requirements: Note: In case of an Oracle RAC environment, meet these prerequisites on each of the nodes. 1. Ensure that the Oracle home on which you are installing the patch or from which you are rolling back the patch is Oracle Database 11g Release 11.2.0.4.0. 2. Oracle recommends that you use the latest version available for 11g Release 11.2.0.4.0. If you do not have OPatch 11g Release 11.2.0.3.5 or the latest version available for 11g Release 11.2.0.4.0,then download it from patch# 6880880 for 11.2.0.4.0 release. For information about OPatch documentation, including any known issues, see My Oracle Support Document 293369.1 OPatch documentation list: https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=224346.1 3. Ensure that you set (as the home user) the ORACLE_HOME environment variable to the Oracle home. 4. Ensure that the $PATH definition has the following executables: make, ar, ld and nm. The location of these executables depends on your operating system. On many operating systems, they are located in /usr/ccs/bin. 5. Ensure that you verify the Oracle Inventory because OPatch accesses it to install the patches. To verify the inventory, run the following command. $ opatch lsinventory Note: - If this command succeeds, it will list the Top-Level Oracle Products and one-off patches if any that are installed in the Oralce Home. - Save the output so you have the status prior to the patch apply. - If the command displays some errors, then contact Oracle Support and resolve the issue first before proceeding further. 6. (Only for Installation) Maintain a location for storing the contents of the patch ZIP file. In the rest of the document, this location (absolute path) is referred to as <PATCH_TOP_DIR>. Extract the contents of the patch ZIP file to the location (PATCH_TOP_DIR) you have created above. To do so, run the following command: $ unzip -d <PATCH_TOP_DIR> p8857940_112040_AIX64-5L.zip 7. (Only for Installation) Determine whether any currently installed interim patches conflict with this patch 8857940 as shown below: $ cd <PATCH_TOP_DIR>/8857940 $ opatch prereq CheckConflictAgainstOHWithDetail -ph ./ The report will indicate the patches that conflict with this patch and the patches for which the current 8857940 is a superset. Note: When OPatch starts, it validates the patch and ensures that there are no conflicts with the software already installed in the ORACLE_HOME. OPatch categorizes conflicts into the following types: - Conflicts with a patch already applied to the ORACLE_HOME that is a subset of the patch you are trying to apply - In this case, continue with the patch installation because the new patch contains all the fixes from the existing patch in the ORACLE_HOME. The subset patch will automatically be rolled back prior to the installation of the new patch. - Conflicts with a patch already applied to the ORACLE_HOME - In this case, stop the patch installation and contact Oracle Support Services. 8. Ensure that you shut down all the services running from the Oracle home. Note: - For a Non-RAC environment, shut down all the services running from the Oracle home. - For a RAC environment, shut down all the services (database, ASM, listeners, nodeapps, and CRS daemons) running from the Oracle home of the node you want to patch. After you patch this node, start the services on this node.Repeat this process for each of the other nodes of the Oracle RAC system. OPatch is used on only one node at a time. (II) Installation ----------------- To install the patch, 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>/8857940 $ opatch apply 2. Verify whether the patch has been successfully installed by running the following command: $ opatch lsinventory 3. Start the services from the Oracle home. (III) Deinstallation ---------------------- Ensure to follow the Prerequsites (Section I). To deinstall the patch, follow these steps: 1. Deinstall the patch by running the following command: $ opatch rollback -id 8857940 2. Start the services from the Oracle home. 3. Ensure that you verify the Oracle Inventory and compare the output with the one run before the patch installation and re-apply any patches that were rolled back as part of this patch apply. To verify the inventory, run the following command: $ opatch lsinventory (IV) Bugs Fixed by This Patch --------------------------------- The following are the bugs fixed by this patch: 8857940: NEED COMMON DURATIONS FOR UNSHRINKABLE POOLS -------------------------------------------------------------------------- Copyright 2016, Oracle and/or its affiliates. All rights reserved. --------------------------------------------------------------------------
最新发布
10-01
- 示例：标题“Oracle Database 11g Release 11.2.0.4.0 Patch Set Update - April 2021”翻译为“Oracle数据库11g版本11.2.0.4.0补丁集更新 - 2021年4月”。 2. **已修复问题列表**：列出每个问题编号及其描述，...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值