Oracle Database 19 Release 19.0.0.0.0
CORE Patch for Bug# 35220732 for Linux-x86-64 Platforms
This patch is RAC Rolling Installable
Released: Fri Apr 14 06:56:44 2023
This document describes how you can install the CORE DST patch for bug# 35220732 on your Oracle Database 19 Release 19.0.0.0.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 19 Release 19.0.0.0.0.
2. Oracle recommends that you use the latest version available for 19 Release 19.0.0.0.0. If you do not have OPatch 19 Release 12.2.0.1.19 or the latest version available for 19 Release 19.0.0.0.0,then download it from patch# 6880880 for 19.0.0.0.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> p35220732_190000_Linux-x86-64.zip
7. (Only for Installation) Determine whether any currently installed interim patches conflict with this patch 35220732 as shown below:
$ cd <PATCH_TOP_DIR>/35220732
$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
The report will indicate the patches that conflict with this patch and the patches for which the current 35220732 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 also meet the DST-specific prerequisites described in My Oracle Support note 412160.1 available at the following location. Failing to meet these prerequisites may result in corrupted timezone data in the database, which may not be possible to correct later.
https://metalink.oracle.com/metalink/plsql/ml2_documents.showNOT?p_id=412160.1
You will notice that the My Oracle Support note mandates you to install patch 7695070 for DSTv11 or higher, as a prerequisite, for all releases of Oracle Database, except for Oracle Database 10g
Release 2 (10.2.0.5) and Oracle Database 11g Release 2 (11.2.0.1.0) or higher. However, note that on Microsoft Windows platforms, instead of installing patch 7695070, you must install a Patch
Set Bundle that includes the fix for bug# 7695070.
(II) Installation
-----------------
To install the patch, follow these steps:
1. If this is a RAC environment, install the patch using the OPatch rolling (no downtime) installation method as the patch is rolling RAC installable. Refer to My Oracle Support Document 244241.1 Rolling Patch - OPatch Support for RAC.
2. 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>/35220732
$ opatch apply
3. Verify whether the patch has been successfully installed by running the following command:
$ opatch lsinventory
(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 35220732
2. 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:
35220732: RDBMS - DSTV42 UPDATE - TZDATA2023C
--------------------------------------------------------------------------
Copyright 2023, Oracle and/or its affiliates. All rights reserved.
--------------------------------------------------------------------------
没有合适的资源?快使用搜索试试~ 我知道了~
oracle19c升级时区版本 32->42,解决数据泵导数据TSTZ报错
共10个文件
dat:6个
xml:2个
txt:2个
需积分: 0 4 下载量 15 浏览量
2024-03-05
16:10:25
上传
评论
收藏 377KB ZIP 举报
温馨提示
oracle19c升级时区版本 32->42,解决数据泵导数据TSTZ报错
资源推荐
资源详情
资源评论
收起资源包目录
p35220732_190000_Linux-x86-64(2).zip (10个子文件)
35220732
files
oracore
zoneinfo
timezone_42.dat 399KB
readme_42.txt 73KB
timezlrg_42.dat 922KB
big
timezone_42.dat 399KB
timezlrg_42.dat 922KB
little
timezone_42.dat 399KB
timezlrg_42.dat 922KB
etc
config
inventory.xml 2KB
actions.xml 2KB
README.txt 6KB
共 10 条
- 1
资源评论
伊泽瑞尔792
- 粉丝: 30
- 资源: 1
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功