标签云
asm恢复 bbed bootstrap$ dul In Memory kcbzib_kcrsds_1 kccpb_sanity_check_2 MySQL恢复 ORA-00312 ORA-00607 ORA-00704 ORA-00742 ORA-01110 ORA-01555 ORA-01578 ORA-08103 ORA-600 2131 ORA-600 2662 ORA-600 2663 ORA-600 3020 ORA-600 4000 ORA-600 4137 ORA-600 4193 ORA-600 4194 ORA-600 16703 ORA-600 kcbzib_kcrsds_1 ORA-600 KCLCHKBLK_4 ORA-15042 ORA-15196 ORACLE 12C oracle dul ORACLE PATCH Oracle Recovery Tools oracle加密恢复 oracle勒索 oracle勒索恢复 oracle异常恢复 Oracle 恢复 ORACLE恢复 ORACLE数据库恢复 oracle 比特币 OSD-04016 YOUR FILES ARE ENCRYPTED 勒索恢复 比特币加密文章分类
- Others (2)
- 中间件 (2)
- WebLogic (2)
- 操作系统 (102)
- 数据库 (1,701)
- DB2 (22)
- MySQL (74)
- Oracle (1,562)
- Data Guard (52)
- EXADATA (8)
- GoldenGate (24)
- ORA-xxxxx (159)
- ORACLE 12C (72)
- ORACLE 18C (6)
- ORACLE 19C (15)
- ORACLE 21C (3)
- Oracle 23ai (8)
- Oracle ASM (68)
- Oracle Bug (8)
- Oracle RAC (53)
- Oracle 安全 (6)
- Oracle 开发 (28)
- Oracle 监听 (28)
- Oracle备份恢复 (571)
- Oracle安装升级 (94)
- Oracle性能优化 (62)
- 专题索引 (5)
- 勒索恢复 (81)
- PostgreSQL (18)
- PostgreSQL恢复 (6)
- SQL Server (27)
- SQL Server恢复 (8)
- TimesTen (7)
- 达梦数据库 (2)
- 生活娱乐 (2)
- 至理名言 (11)
- 虚拟化 (2)
- VMware (2)
- 软件开发 (37)
- Asp.Net (9)
- JavaScript (12)
- PHP (2)
- 小工具 (20)
-
最近发表
- ORA-742 写丢失常见bug记录
- Oracle 19c 202501补丁(RUs+OJVM)
- 避免 19c 数据库性能问题需要考虑的事项 (Doc ID 3050476.1)
- Bug 21915719 Database hang or may fail to OPEN in 12c IBM AIX or HPUX Itanium – ORA-742, DEADLOCK or ORA-600 [kcrfrgv_nextlwn_scn] ORA-600 [krr_process_read_error_2]
- ORA-600 ktuPopDictI_1恢复
- impdp导入数据丢失sys授权问题分析
- impdp 创建index提示ORA-00942: table or view does not exist
- 数据泵导出 (expdp) 和导入 (impdp)工具性能降低分析参考
- 19c非归档数据库断电导致ORA-00742故障恢复
- Oracle 19c – 手动升级到 Non-CDB Oracle Database 19c 的完整核对清单
- sqlite数据库简单操作
- Oracle 暂定和恢复功能
- .pzpq扩展名勒索恢复
- Oracle read only用户—23ai新特性:只读用户
- 迁移awr快照数据到自定义表空间
- .hmallox加密mariadb/mysql数据库恢复
- 2025年首个故障恢复—ORA-600 kcbzib_kcrsds_1
- 第一例Oracle 21c恢复咨询
- ORA-15411: Failure groups in disk group DATA have different number of disks.
- 断电引起的ORA-08102: 未找到索引关键字, 对象号 39故障处理
分类目录归档:Oracle安装升级
Assistant: Download Reference for Oracle Database/GI PSU, SPU(CPU), Bundle Patches, Patchsets and Base Releases-202110
|
|
19.0.0.0 | |||
Description | Database Update | GI Update | Windows Bundle Patch |
OCT2021(19.13.0.0.0) | 33192793 | 33182768 | 33155330 |
JUL2021 (19.12.0.0.0) | 32904851 | 32895426 | 32832237 |
APR2021 (19.11.0.0.0) | 32545013 | 32545008 | 32409154 |
JAN2021 (19.10.0.0.0) | 32218454 | 32226239 | 32062765 |
OCT2020 (19.9.0.0.0) | 31771877 | 31750108 | 31719903 |
JUL2020 (19.8.0.0.0) | 31281355 | 31305339 | 31247621 |
APR2020 (19.7.0.0.0) | 30869156 | 30899722 | 30901317 |
JAN2020 (19.6.0.0.0) | 30557433 | 30501910 | 30445947 |
OCT2019 (19.5.0.0.0) | 30125133 | 30116789 | 30151705 |
JUL2019 (19.4.0.0.0) | 29834717 | 29708769 | NA |
APR2019 (19.3.0.0.0) | 29517242 | 29517302 | NA |
18.0.0.0 | |||
Description | OJVM Update | OJVM + DB Update | OJVM + GI Update |
APR2021 (18.14.0.0.210420) | 32552752 | 32579022 | 32579024 |
JAN2021 (18.13.0.0.210119) | 32119939 | 32126855 | 32126862 |
OCT2020 (18.12.0.0.201020) | 31668892 | 31720435 | 31720457 |
JUL2020 (18.11.0.0.200714) | 31219909 | 31326374 | 31326376 |
APR2020 (18.10.0.0.200414) | 30805598 | 30783603 | 30783607 |
JAN2020 (18.9.0.0.200114) | 30501926 | 30463620 | 30463635 |
OCT2019 (18.8.0.0.191015) | 30133603 | 30133203 | 30133246 |
JUL2091 (18.7.0.0.190716) | 29774410 | 29699112 | 29699160 |
APR2019 (18.6.0.0.190416) | 29249584 | 29249695 | 29251992 |
JAN2019 (18.5.0.0.190115) | 28790647 | 28980087 | 28980105 |
OCT2018 (18.4.0.0.181016) | 28502229 | 28689117 | 28689122 |
JUL2018 (18.3.0.0.180717) | 27923415 | 28317326 | 28317346 |
APR2018 (18.2.0.0.180417) | 27636900 | 27726465 | 27726470 |
18.0.0.0 | |||
Description | Database Update | GI Update | Windows Bundle Patch |
APR2021 (18.14.0.0.0) | 32524155 | 32524152 | 32438481 |
JAN2021 (18.13.0.0.0) | 32204699 | 32226219 | 32062760 |
OCT2020 (18.12.0.0.0) | 31730250 | 31748523 | 31629682 |
JUL2020 (18.11.0.0.0) | 31308624 | 31305362 | 31247612 |
APR2020 (18.10.0.0.0) | 30872794 | 30899645 | 30901451 |
JAN2020 (18.9.0.0.0) | 30480385 | 30480702 | 30445951 |
OCT2019 (18.8.0.0.0) | 30112122 | 30116795 | 30150321 |
JUL2019 (18.7.0.0.0) | 29757256 | 29708703 | 29859180 |
APR2019 (18.6.0.0.0) | 29301631 | 29301682 | 29589622 |
JAN2019 (18.5.0.0.0) | 28822489 | 28828717 | 29124511 |
OCT2018 (18.4.0.0.0) | 28655784 | 28659165 | NA |
JUL2018 (18.3.0.0.0) | 28090523 | 28096386 | NA |
APR2018 (18.2.0.0.0) | 27676517 | 27681568 | NA |
12.2.0.1 | ||||
Description | OJVM Update | OJVM Windows Bundle Patch | Combo OJVM + DB Update | Combo OJVM + GI Update |
OCT2021 (12.2.0.1.211019) | 33192662 | 33248852 | 33248521 | 33248546 |
JUL2021 (12.2.0.1.210720) | 32876409 | 32905896 | 32900144 | 32900156 |
APR2021 (12.2.0.1.210420) | 32473172 | 32427674 | 32579049 | 32579057 |
JAN2021 (12.2.0.1.210119) | 32119931 | 32142294 | 32126871 | 32226491 |
OCT2020 (12.2.0.1.201020) | 31668898 | 31740064 | 31720473 | 31720486 |
JUL2020 (12.2.0.1.200714) | 31219919 | 31465105 | 31326379 | 31326390 |
APR2020 (12.2.0.1.200414) | 30805580 | 31035002 | 30783641 | 30783652 |
JAN2020 (12.2.0.1.200114) | 30502018 | 30525838 | 30463660 | 30463673 |
OCT2019 (12.2.0.1.191015) | 30133625 | 30268021 | 30133374 | 30133386 |
JUL2019 (12.2.0.1.190716) | 29774415 | 29837425 | 29699168 | 29699173 |
APR2019 (12.2.0.1.190416) | 29249637 | 29281550 | 29252035 | 29252072 |
JAN2019 (12.2.0.1.190115) | 28790651 | 28994068 | 28980102 | 28980109 |
NOV2018 (12.2.0.1.181130) | NA | 28412314 | NA | NA |
OCT2018 (12.2.0.1.181016) | 28440725 | 28412312 | 28689128 | 28689130 |
JUL2018 (12.2.0.1.180717) | 27923353 | 28135129 | 28317292 | 28317269 |
APR2018 (12.2.0.1.180417) | 27475613 | 27650410 | 27726453 | 27726454 |
JAN2018 (12.2.0.1.180116) | 27001739 | 27162975 | 27010695 | 27010711 |
OCT2017 (12.2.0.1.171017) | 26635944 | 26792369 | 26636004 | 26636246 |
AUG2017 (12.2.0.1.170814) | N/A | 26565082 | 26550033 | 26550314 |
JUL2017 (12.2.0.1.170718) | 25811364 | 26182467 | 26146314 | 26146318 |
12.2.0.1 | |||
Description | Database Update | GI Update | Windows Bundle Patch |
OCT2021 (12.2.0.1.211019) | 33261817 | 33290750 | 33174380 |
JUL2021 (12.2.0.1.210720) | 32916808 | 32928749 | 32775037 |
APR2021 (12.2.0.1.210420) | 32507738 | 32540149 | 32392089 |
JAN2021 (12.2.0.1.210119) | 32228578 | 32226491 | 31987852 |
OCT2020 (12.2.0.1.201020) | 31741641 | 31750094 | 31654782 |
JUL2020 (12.2.0.1.200714) | 31312468 | 31305382 | 31210848 |
APR2020 (12.2.0.1.200414) | 30886680 | 30920127 | 30861472 |
JAN2020 (12.2.0.1.200114) | 30593149 | 30501932 | 30446296 |
OCT2019 (12.2.0.1.191015) | 30138470 | 30116802 | 30150416 |
JUL2019 (12.2.0.1.190716) | 29757449 | 29708720 | 29832062 |
APR2019 (12.2.0.1.190416) | 29314339 | 29301687 | 29394003 |
JAN2019 (12.2.0.1.190115) | 28822515 | 28828733 | 28810696 |
NOV2018 (12.2.0.1.181130) | NA | NA | 28810550 (64bit) |
OCT2018 (12.2.0.1.181016) | 28662603 | 28714316 | 28574555 |
JUL2018 (12.2.0.1.180717) | 28163133 | NA | 27937914 |
APR2018 (12.2.0.1.180417) | 27674384 | 27468969 | 27426753 |
JAN2018 (12.2.0.1.180116) | 27105253 | 27100009 | 27162931 |
NOV2017 (12.2.0.1.171121) | NA | 27010638 | NA |
OCT2017 (12.2.0.1.171017) | 26710464 | 26737266 | 26758841 |
AUG2017 (12.2.0.1.170814) | 26609817 | 26610291 | 26204214 |
JUL2017 (12.2.0.1.170718) | 26123830 | 26133434 | 26204212 |
参考:Assistant: Download Reference for Oracle Database/GI Update, Revision, PSU, SPU(CPU), Bundle Patches, Patchsets and Base Releases (Doc ID 2118136.2)
19c 非第一个节点执行root.sh报Error 4 opening dom ASM/Self in 错误
在linux 7.9的系统中安装oracle 19c的rac,在第二个节点执行root.sh报以下错误
Error 4 opening dom ASM/Self in 0x425a470
Domain name to open is ASM/Self
Error 4 opening dom ASM/Self in 0x425a470
[root@rac2 tmp]# /u01/app/19c/grid/root.sh Performing root user operation. The following environment variables are set as: ORACLE_OWNER= grid ORACLE_HOME= /u01/app/19c/grid Enter the full pathname of the local bin directory: [/usr/local/bin]: Copying dbhome to /usr/local/bin ... Copying oraenv to /usr/local/bin ... Copying coraenv to /usr/local/bin ... Creating /etc/oratab file... Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root script. Now product-specific root actions will be performed. Relinking oracle with rac_on option Using configuration parameter file: /u01/app/19c/grid/crs/install/crsconfig_params The log of current session can be found at: /u01/app/grid/crsdata/rac2/crsconfig/rootcrs_rac2_2021-08-27_10-54-04AM.log 2021/08/27 10:54:07 CLSRSC-594: Executing installation step 1 of 19: 'SetupTFA'. 2021/08/27 10:54:07 CLSRSC-594: Executing installation step 2 of 19: 'ValidateEnv'. 2021/08/27 10:54:07 CLSRSC-594: Executing installation step 3 of 19: 'CheckFirstNode'. 2021/08/27 10:54:07 CLSRSC-594: Executing installation step 4 of 19: 'GenSiteGUIDs'. 2021/08/27 10:54:08 CLSRSC-594: Executing installation step 5 of 19: 'SetupOSD'. Redirecting to /bin/systemctl restart rsyslog.service 2021/08/27 10:54:08 CLSRSC-594: Executing installation step 6 of 19: 'CheckCRSConfig'. 2021/08/27 10:54:08 CLSRSC-594: Executing installation step 7 of 19: 'SetupLocalGPNP'. 2021/08/27 10:54:09 CLSRSC-594: Executing installation step 8 of 19: 'CreateRootCert'. 2021/08/27 10:54:09 CLSRSC-594: Executing installation step 9 of 19: 'ConfigOLR'. 2021/08/27 10:54:18 CLSRSC-594: Executing installation step 10 of 19: 'ConfigCHMOS'. 2021/08/27 10:54:18 CLSRSC-594: Executing installation step 11 of 19: 'CreateOHASD'. 2021/08/27 10:54:19 CLSRSC-594: Executing installation step 12 of 19: 'ConfigOHASD'. 2021/08/27 10:54:21 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service' 2021/08/27 10:55:06 CLSRSC-594: Executing installation step 13 of 19: 'InstallAFD'. 2021/08/27 10:55:18 CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector. 2021/08/27 10:55:35 CLSRSC-594: Executing installation step 14 of 19: 'InstallACFS'. 2021/08/27 10:56:07 CLSRSC-594: Executing installation step 15 of 19: 'InstallKA'. 2021/08/27 10:56:08 CLSRSC-594: Executing installation step 16 of 19: 'InitConfig'. 2021/08/27 10:56:15 CLSRSC-594: Executing installation step 17 of 19: 'StartCluster'. 2021/08/27 10:57:01 CLSRSC-343: Successfully started Oracle Clusterware stack 2021/08/27 10:57:01 CLSRSC-594: Executing installation step 18 of 19: 'ConfigNode'. 2021/08/27 10:57:10 CLSRSC-594: Executing installation step 19 of 19: 'PostConfig'. 2021/08/27 10:57:15 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded Error 4 opening dom ASM/Self in 0x425a470 Domain name to open is ASM/Self Error 4 opening dom ASM/Self in 0x425a470 [root@rac2 tmp]#
通过查询mos,发现相关文档:19C: While Executing Root.sh on Remote Nodes HIT UNEXPECTED “ERROR 4 OPENING DOM ASM/SELF IN 0x57f7d60″ (Doc ID 2571719.1)
确认是oracle一个bug,在20c版本中修复(20c没有对外发布,应该在21c中修复),这个bug不影响,可以忽略
12.1.0.2扩展补丁信息-202107
12.1.0.2版本早进入了扩展服务期,这里提供相关信息,便于大家查找
Release Date | Version | Download link | Included in Windows Bundle |
20-Jul-2021 | 12.1.0.2.210720 (Jul 2021) Database Patch Set Update (DB PSU) | Patch 32768233 | 12.1.0.2.210720 WIN DB BP Patch 32774982 |
20-Apr-2021 | 12.1.0.2.210420 (Apr 2021) Database Patch Set Update (DB PSU) | Patch 32328635 | 12.1.0.2.210420 WIN DB BP Patch 32396181 |
19-Jan-2021 | 12.1.0.2.210119 (Jan 2021) Database Patch Set Update (DB PSU) | Patch 31985579 | 12.1.0.2.210119 WIN DB BP Patch 32000405 |
20-Oct-2020 | 12.1.0.2.201020 (Oct 2020) Database Patch Set Update (DB PSU) | Patch 31550110 | 12.1.0.2.201020 WIN DB BP Patch 31658987 |
14-Jul-2020 | 12.1.0.2.200714 (Jul 2020) Database Patch Set Update (DB PSU) | Patch 31113348 | 12.1.0.2.200714 WIN DB BP Patch 31211574 |
14-Apr-2020 | 12.1.0.2.200414 (Apr 2020) Database Patch Set Update (DB PSU) | Patch 30700212 | 12.1.0.2.200414 WIN DB BP Patch 30861721 |
14-Jan-2020 | 12.1.0.2.200114 (Jan 2020) Database Patch Set Update (DB PSU) | Patch 30340202 | 12.1.0.2.200114 WIN DB BP Patch 30455401 |
Release Date | Version | Download link |
20-Jul-2021 | 12.1.0.2.210720 (Jul 2021) Grid Infrastructure Patch Set Update (GI PSU) | Patch 32917447 |
20-Apr-2021 | 12.1.0.2.210420 (Apr 2021) Grid Infrastructure Patch Set Update (GI PSU) | Patch 32495126 |
19-Jan-2021 | 12.1.0.2.210119 (Jan 2021) Grid Infrastructure Patch Set Update (GI PSU) | Patch 32131261 |
20-Oct-2020 | 12.1.0.2.201020 (Oct 2020) Grid Infrastructure Patch Set Update (GI PSU) | Patch 31718737 |
14-Jul-2020 | 12.1.0.2.200714 (Jul 2020) Grid Infrastructure Patch Set Update (GI PSU) | Patch 31305174 |
14-Apr-2020 | 12.1.0.2.200414 (Apr 2020) Grid Infrastructure Patch Set Update (GI PSU) | Patch 30805421 |
14-Jan-2020 | 12.1.0.2.200114 (Jan 2020) Grid Infrastructure Patch Set Update (GI PSU) | Patch 30464119 |
Release Date | Version | Includes GI PSU | Download link |
20-Jul-2021 | 12.1.0.2.210720 Database Proactive Bundle Patch (Jul 2021) | 12.1.0.2.210720 | Patch 32917362 |
20-Apr-2021 | 12.1.0.2.210420 Database Proactive Bundle Patch (Apr 2021) | 12.1.0.2.210420 | Patch 32518631 |
19-Jan-2021 | 12.1.0.2.210119 Database Proactive Bundle Patch (Jan 2021) | 12.1.0.2.210119 | Patch 32131231 |
20-Oct-2020 | 12.1.0.2.201020 Database Proactive Bundle Patch (Oct 2020) | 12.1.0.2.201020 | Patch 31718813 |
14-Jul-2020 | 12.1.0.2.200714 Database Proactive Bundle Patch (Jul 2020) | 12.1.0.2.200714 | Patch 31307682 |
14-Apr-2020 | 12.1.0.2.200414 Database Proactive Bundle Patch (Apr 2020) | 12.1.0.2.200414 | Recommend Patch 31307682 or later |
14-Jan-2020 | 12.1.0.2.200114 Database Proactive Bundle Patch (Jan 2020) | 12.1.0.2.200114 | Recommend Patch 31307682 or later |
Release Date | Version | Unix PSU Patch | Windows Bundle Patch |
20-Jul-2021 | 12.1.0.2.210720 (Jul 2021) OJVM Component Patch Set Update | Patch 32876425 | Patch 32905878 |
20-Apr-2021 | 12.1.0.2.210420 (Apr 2021) OJVM Component Patch Set Update | Patch 32473164 | Patch 32427683 |
19-Jan-2021 | 12.1.0.2.210119 (Jan 2021) OJVM Component Patch Set Update | Patch 32119956 | Patch 32142066 |
20-Oct-2020 | 12.1.0.2.201020 (Oct 2020) OJVM Component Patch Set Update | Patch 31668915 | Patch 31740134 |
14-Jul-2020 | 12.1.0.2.200714 (Jul 2020) OJVM Component Patch Set Update | Patch 31219939 | Patch 31465095 |
14-Apr-2020 | 12.1.0.2.200414 (Apr 2020) OJVM Component Patch Set Update | Patch 30805558 | Patch 31037459 |
14-Jan-2020 | 12.1.0.2.200114 (Jan 2020) OJVM Component Patch Set Update | Patch 30502041 | Patch 30671054 |
Release Date | Version | Download Link |
20-Jul-2021 | Combo OJVM PSU 12.1.0.2.210720 and DB PSU 12.1.0.2.210720 | Patch 32900172 |
20-Apr-2021 | Combo OJVM PSU 12.1.0.2.210420 and DB PSU 12.1.0.2.210420 | Patch 32579074 |
19-Jan-2021 | Combo OJVM PSU 12.1.0.2.210119 and DB PSU 12.1.0.2.210119 | Patch 32126886 |
20-Oct-2020 | Combo OJVM PSU 12.1.0.2.201020 and DB PSU 12.1.0.2.201020 | Patch 31720729 |
14-Jul-2020 | Combo OJVM PSU 12.1.0.2.200714 and DB PSU 12.1.0.2.200714 | Patch 31326396 |
14-Apr-2020 | Combo OJVM PSU 12.1.0.2.200414 and DB PSU 12.1.0.2.200414 | Patch 30783658 |
14-Jan-2020 | Combo OJVM PSU 12.1.0.2.200114 and DB PSU 12.1.0.2.200114 | Patch 30463684 |
Release Date | Version | Download Link |
20-Jul-2021 | Combo OJVM PSU 12.1.0.2.210720 and DBBP 12.1.0.2.210720 | Patch 32900201 |
20-Apr-2021 | Combo OJVM PSU 12.1.0.2.210420 and DBBP 12.1.0.2.210420 | Patch 32579100 |
19-Jan-2021 | Combo OJVM PSU 12.1.0.2.210119 and DBBP 12.1.0.2.210119 | Patch 32126908 |
20-Oct-2020 | Combo OJVM PSU 12.1.0.2.201020 and DBBP 12.1.0.2.201020 | Patch 31720769 |
14-Jul-2020 | Combo OJVM PSU 12.1.0.2.200714 and DBBP 12.1.0.2.200714 | Patch 31326402 |
14-Apr-2020 | Combo OJVM PSU 12.1.0.2.200414 and DBBP 12.1.0.2.200414 | Recommend Patch 31326402 or later |
14-Jan-2020 | Combo OJVM PSU 12.1.0.2.200114 and DBBP 12.1.0.2.200114 | Recommend Patch 31326402 or later |
Release Date | Version | Download Link |
20-Jul-2021 | Combo OJVM PSU 12.1.0.2.210720 and GI PSU 12.1.0.2.210720 | Patch 32900185 |
20-Apr-2021 | Combo OJVM PSU 12.1.0.2.210420 and GI PSU 12.1.0.2.210420 | Patch 32579077 |
19-Jan-2021 | Combo OJVM PSU 12.1.0.2.210119 and GI PSU 12.1.0.2.210119 | Patch 32126899 |
20-Oct-2020 | Combo OJVM PSU 12.1.0.2.201020 and GI PSU 12.1.0.2.201020 | Patch 31720761 |
14-Jul-2020 | Combo OJVM PSU 12.1.0.2.200714 and GI PSU 12.1.0.2.200714 | Patch 31326400 |
14-Apr-2020 | Combo OJVM PSU 12.1.0.2.200414 and GI PSU 12.1.0.2.200414 | Patch 30783882 |
14-Jan-2020 | Combo OJVM PSU 12.1.0.2.200114 and GI PSU 12.1.0.2.200114 | Patch 30463691 |