标签云
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)
- 操作系统 (103)
- 数据库 (1,702)
- DB2 (22)
- MySQL (74)
- Oracle (1,563)
- 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)
-
最近发表
- Oracle各种类型坏块说明和处理
- fio测试io,导致磁盘文件系统损坏故障恢复
- 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恢复咨询
分类目录归档:Oracle安装升级
数据库升级遭遇ORA-04063: package body “SYS.DBMS_SQLTUNE”
数据库从11.2.0.2升级到11.2.0.4,遇到一下错误
Oracle Database 11.2 Post-Upgrade Status Tool 08-21-2020 20:43:36 . Component Current Version Elapsed Time Name Status Number HH:MM:SS . Oracle Server . ORA-04063: package body "SYS.DBMS_SQLTUNE" 有错误 . ORA-06508: PL/SQL: 无法找到正在调用 : "SYS.DBMS_SQLTUNE" 的程序单元 . ORA-06512: 在 line 8 . INVALID 11.2.0.4.0 00:07:28 JServer JAVA Virtual Machine . VALID 11.2.0.4.0 00:01:45 Oracle Workspace Manager . VALID 11.2.0.4.0 00:00:20 OLAP Analytic Workspace . VALID 11.2.0.4.0 00:00:35 OLAP Catalog . VALID 11.2.0.4.0 00:00:57 Oracle OLAP API . VALID 11.2.0.4.0 00:00:12 Oracle Enterprise Manager . ORA-01422: 实际返回的行数超出请求的行数 . ORA-06512: 在 line 6 . ORA-01422: 实际返回的行数超出请求的行数 . ORA-06512: 在 line 5 . SP2-1506: START, @ 或 @@ 命令没有参数 . ORA-01422: 实际返回的行数超出请求的行数 . ORA-06512: 在 line 5 . SP2-1506: START, @ 或 @@ 命令没有参数 . ORA-01422: 实际返回的行数超出请求的行数 . ORA-06512: 在 line 5 . SP2-1506: START, @ 或 @@ 命令没有参数 . ORA-01422: 实际返回的行数超出请求的行数 . ORA-06512: 在 line 5 . SP2-1506: START, @ 或 @@ 命令没有参数 . ORA-01422: 实际返回的行数超出请求的行数 . ORA-06512: 在 line 5 . SP2-1506: START, @ 或 @@ 命令没有参数 . ORA-01422: 实际返回的行数超出请求的行数 . ORA-06512: 在 line 5 . SP2-1506: START, @ 或 @@ 命令没有参数 . ORA-01422: 实际返回的行数超出请求的行数 . ORA-06512: 在 line 5 . SP2-1506: START, @ 或 @@ 命令没有参数 . ORA-01422: 实际返回的行数超出请求的行数 . VALID 11.2.0.4.0 00:00:24 Oracle XDK . VALID 11.2.0.4.0 00:00:16 Oracle Text . VALID 11.2.0.4.0 00:00:33 Oracle XML Database . VALID 11.2.0.4.0 00:01:21 Oracle Database Java Packages . VALID 11.2.0.4.0 00:00:05 Oracle Multimedia . ORA-04063: package body "SYS.DBMS_SQLTUNE" 有错误 . ORA-06508: PL/SQL: 无法找到正在调用 : "SYS.DBMS_SQLTUNE" 的程序单元 . ORA-06512: 在 "SYS.UTL_RECOMP", line 865 . ORA-06512: 在 "SYS.UTL_RECOMP", line 878 . ORA-06512: 在 line 1 . VALID 11.2.0.4.0 00:00:53 Spatial . VALID 11.2.0.4.0 00:03:25 Oracle Expression Filter . VALID 11.2.0.4.0 00:00:08 Oracle Rules Manager . VALID 11.2.0.4.0 00:00:06 Oracle Application Express . VALID 3.2.1.00.10 Final Actions . 00:00:00 Total Upgrade Time: 00:18:38 PL/SQL 过程已成功完成。
查询mos发现类似解决方案
SQL> select owner, object_name, object_type, status from dba_objects where object_name = 'DBMS_STATS'; OWNER OBJECT_NAME OBJECT_TYPE STATUS ------------------------------ ----------------------------------------------------------------------------------------- --------------------------------------- ------------------- ------- SYS DBMS_STATS PACKAGE VALID SYS DBMS_STATS PACKAGE BODY VALID PUBLIC DBMS_STATS SYNONYM VALID SQL> select owner, object_name, object_type, status from dba_objects where object_name = 'DBMS_SQLTUNE' 2 / OWNER OBJECT_NAME OBJECT_TYPE STATUS ------------------------------ ----------------------------------------------------------------------------------------- --------------------------------------- ------------------- ------- SYS DBMS_SQLTUNE PACKAGE VALID SYS DBMS_SQLTUNE PACKAGE BODY INVALID PUBLIC DBMS_SQLTUNE SYNONYM INVALID SQL> alter package DBMS_SQLTUNE compile body; 警告: 更改的包体带有编译错误。 SQL> show error; PACKAGE BODY DBMS_SQLTUNE 出现错误: LINE/COL ERROR -------- ----------------------------------------------------------------- 0/0 PLS-00801: 内部错误 [phdite:node kind] 10210/5 PL/SQL: ORA-01775: 同义词的循环链 10210/5 PL/SQL: SQL Statement ignored 13917/7 PL/SQL: Statement ignored 16995/5 PL/SQL: SQL Statement ignored 17060/12 PL/SQL: ORA-01775: 同义词的循环链 17657/7 PL/SQL: Statement ignored 17660/31 PLS-00231: 函数 'SQLERRM' 不能在 SQL 中使用 19718/5 PL/SQL: SQL Statement ignored 19718/12 PL/SQL: ORA-01775: 同义词的循环链 19782/5 PL/SQL: Statement ignored LINE/COL ERROR -------- ----------------------------------------------------------------- 19782/17 PLS-00231: 函数 'BUILD_SQL_DETAIL_XML' 不能在 SQL 中使用 SQL> select owner, object_name, object_type, status from dba_objects where object_name = 'XMLCONCAT'; OWNER ------------------------------ OBJECT_NAME -------------------------------------------------------------------------------- OBJECT_TYPE STATUS ------------------- ------- PUBLIC XMLCONCAT SYNONYM VALID SQL> drop public synonym XMLCONCAT; 同义词已删除。 SQL> alter package DBMS_SQLTUNE compile body; 程序包体已变更。
重新跑升级脚本catupgrd.sql,一切正常
Oracle Database 11.2 Post-Upgrade Status Tool 08-21-2020 21:08:31 . Component Current Version Elapsed Time Name Status Number HH:MM:SS . Oracle Server . VALID 11.2.0.4.0 00:06:44 JServer JAVA Virtual Machine . VALID 11.2.0.4.0 00:00:00 Oracle Workspace Manager . VALID 11.2.0.4.0 00:00:00 OLAP Analytic Workspace . VALID 11.2.0.4.0 00:00:00 OLAP Catalog . VALID 11.2.0.4.0 00:00:00 Oracle OLAP API . VALID 11.2.0.4.0 Oracle Enterprise Manager . VALID 11.2.0.4.0 00:00:00 Oracle XDK . VALID 11.2.0.4.0 00:00:00 Oracle Text . VALID 11.2.0.4.0 00:00:00 Oracle XML Database . VALID 11.2.0.4.0 00:00:00 Oracle Database Java Packages . VALID 11.2.0.4.0 00:00:00 Oracle Multimedia . VALID 11.2.0.4.0 00:00:00 Spatial . VALID 11.2.0.4.0 00:00:00 Oracle Expression Filter . VALID 11.2.0.4.0 00:00:00 Oracle Rules Manager . VALID 11.2.0.4.0 Oracle Application Express . VALID 3.2.1.00.10 Final Actions . 00:00:00 Total Upgrade Time: 00:06:51 PL/SQL 过程已成功完成。
参考解决方案:Upgrade From 10G To 11G Fails On Dbms_sqltune : ORA-04063: Package Body “SYS.DBMS_SQLTUNE” Has Errors (Doc ID 1271490.1)
DBMS_STATS , DBMS_SQLTUNE_INTERNAL , DBMS_SQLTUNE Package Can Not be Recompiled during/After Upgrade reporting “ORA-04063″ , “ORA-06508″ . “ORA-06512″ (Doc ID 761961.1)
Assistant: Download Reference for Oracle Database/GI PSU, SPU(CPU), Bundle Patches, Patchsets and Base Releases-202007
Patchsets |
|
12.1.0.2 (12.1.0.2.0 PATCH SET FOR ORACLE DATABASE SERVER) |
|
11.2.0.4 (11.2.0.4.0 PATCH SET FOR ORACLE DATABASE SERVER) |
|
11.2.0.3 (11.2.0.3.0 PATCH SET FOR ORACLE DATABASE SERVER) |
|
11.2.0.2 (11.2.0.2.0 PATCH SET FOR ORACLE DATABASE SERVER) |
|
11.1.0.7 (11.1.0.7.0 PATCH SET FOR ORACLE DATABASE SERVER) |
|
10.2.0.5 (10.2.0.5 PATCH SET FOR ORACLE DATABASE SERVER) |
|
A10.2.0.4 (10.2.0.4.0 PATCH SET FOR ORACLE DATABASE SERVER) |
|
B10.2.0.3 (10.2.0.3 PATCH SET FOR ORACLE DATABASE SERVER) |
|
10.2.0.2 (10.2.0.2 PATCH SET FOR ORACLE DATABASE SERVER) |
|
10.1.0.5 (10.1.0.5 PATCH SET FOR ORACLE DATABASE SERVER) |
|
10.1.0.4 (10.1.0.4 PATCH SET FOR ORACLE DATABASE SERVER) |
|
10.1.0.3 (10.1.0.3 PATCH SET FOR ORACLE DATABASE SERVER) |
|
9.2.0.8 (9.2.0.8 PATCH SET FOR ORACLE DATABASE SERVER) |
|
9.2.0.7 (9.2.0.7 PATCH SET FOR ORACLE DATABASE SERVER) |
|
9.2.0.6 (9.2.0.6 PATCH SET FOR ORACLE DATABASE SERVER) |
|
9.2.0.5 (ORACLE 9I DATABASE SERVER RELEASE 2 – PATCH SET 4 VERSION 9.2.0.5.0) |
|
9.2.0.4 (9.2.0.4 PATCH SET FOR ORACLE DATABASE SERVER) |
|
9.2.0.3 (9.2.0.3 PATCH SET FOR ORACLE DATABASE SERVER) |
|
9.2.0.2 (9.2.0.2 PATCH SET FOR ORACLE DATABASE SERVER) |
|
9.0.1.5 (9.0.1.5 PATCHSET) |
|
9.0.1.4 (9.0.1.4 PATCH SET FOR ORACLE DATABASE SERVER) |
|
9.0.1.3 (9.0.1.3. PATCH SET FOR ORACLE DATA SERVER) |
|
8.1.7.4 (8.1.7.4 PATCH SET FOR ORACLE DATA SERVER) |
|
8.1.7.3 (8.1.7.3 PATCH SET FOR ORACLE DATA SERVER) |
|
8.1.7.2 (8.1.7.2.1 PATCH SET FOR ORACLE DATA SERVER) |
19.0.0.0 |
||||
Release |
DB Revision 1 |
DB Revision 2 |
GI Revision 1 |
GI Revision 2 |
JUL2020 |
31204483 (19.7.1.0.0) |
31212138 (19.6.2.0.0) |
31326441 (19.7.1.0.0) |
31326451 (19.6.2.0.0) |
APR2020 |
30797938 (19.6.1.0.0) |
30830913 (19.5.2.0.0) |
30923276 (19.6.1.0.0) |
30923448 (19.5.2.0.0) |
JAN2020 |
30446054 (19.5.1.0.0) |
30446228 (19.4.2.0.0) |
30464035 (19.5.1.0.0) |
30463911 (19.4.2.0.0) |
OCT2019 |
30080447 (19.4.1.0.0) |
30087906 (19.3.2.0.0) |
30134717 (19.4.1.0.0) |
30135696 (19.3.2.0.0) |
19.0.0.0 |
|||
Description |
OJVM Update |
OJVM + DB Update |
OJVM + GI Update |
JUL2020 (19.8.0.0.200714) |
|||
APR2020 (19.7.0.0.200414) |
|||
JAN2020 (19.6.0.0.200114) |
|||
OCT2019 (19.5.0.0.191015) |
|||
JUL2019 (19.4.0.0.190716) |
|||
APR2019 (19.3.0.0.190416) |
18.0.0.0 |
||||
Release |
DB Revision 1 |
DB Revision 2 |
GI Revision 1 |
GI Revision 2 |
JUL2020 |
31211410(18.10.1.0.0) |
31212186 (18.9.2.0.0) |
31326437 (18.10.1.0.0) |
31326455 (18.9.2.0.0) |
APR2020 |
30798089 (18.9.1.0.0) |
30830887 (18.8.2.0.0) |
30923313 (18.9.1.0.0) |
30923359 (18.8.2.0.0) |
JAN2020 |
30445895 (18.8.1.0.0) |
30446239(18.7.2.0.0) |
30463999 (18.8.1.0.0) |
30463931 (18.7.2.0.0) |
OCT2019 |
30080518 (18.7.1.0.0) |
30087881(18.6.2.0.0) |
30135098 (18.7.1.0.0) |
30134851 (18.6.2.0.0) |
JUL2019 |
29708235 (18.6.1.0.0) |
29708437(18.5.2.0.0) |
29708736 (18.6.1.0.0) |
29708805 (18.5.2.0.0) |
APR2019 |
29230887 (18.5.1.0.0) |
29230809(18.4.2.0.0) |
29231062 (18.5.1.0.0) |
29230841 (18.4.2.0.0) |
JAN2019 |
28822587 (18.4.1.0.0) |
28790643(18.3.2.0.0) |
28833172 (18.4.1.0.0) |
28833251 (18.3.1.0.0) |
OCT2018 |
28507480 (18.3.1.0.0) |
28601267(18.2.2.0.0) |
28660077 (18.3.1.0.0) |
28702032 (18.2.2.0.0) |
JUL2018 |
28346593 (18.2.1.0.0) |
|
28276290 (18.2.1.0.0) |
|
18.0.0.0 |
|||
Description |
OJVM Update |
OJVM + DB Update |
OJVM + GI Update |
JUL2020 (18.11.0.0.200714) |
|||
APR2020 (18.10.0.0.200414) |
|||
JAN2020 (18.9.0.0.200114) |
|||
OCT2019 (18.8.0.0.191015) |
|||
JUL2091 (18.7.0.0.190716) |
|||
APR2019 (18.6.0.0.190416) |
|||
JAN2019 (18.5.0.0.190115) |
|||
OCT2018 (18.4.0.0.181016) |
|||
JUL2018 (18.3.0.0.180717) |
|||
APR2018 (18.2.0.0.180417) |
12.2.0.1 |
|||||||||
Release |
DB Update |
DB Revision 1 |
DB Revision 2 |
GI Update |
GI Revision 1 |
GI Revision 2 |
|||
JUL2020 |
31312468 (12.2.0.1.200714) |
31199988 (APR2020) |
31212219 (JAN2020) |
31305382 (12.2.0.1.200714) |
31326445 (APR2020) |
31326459 (JAN2020) |
|||
APR2020 |
30886680 (12.2.0.1.200414) |
30799484 (JAN2020) |
30831066 (OCT2019) |
30920127 (12.2.0.1.200414) |
30820944 (JAN2020) |
30820785 (OCT2019) |
|||
JAN2020 |
30593149 (12.2.0.1.200114) |
30445968 (OCT2020) |
30446254 (JUL2019) |
30501932 (12.2.0.1.200114) |
30464069 (OCT2019) |
30463942 (JUL2019) |
|||
OCT2019 |
30138470 (12.2.0.1.191015) |
30087824 (JUL2019) |
30087848 (APR2019) |
30116802 (12.2.0.1.191015) |
30135070 (JUL2019) |
30134879 (APR2019) |
|||
JUL2019 |
29757449 (12.2.0.1.190716) |
29708381 (APR2019) |
29708478 (JAN2019) |
29708720 (12.2.0.1.190716) |
29708786 (APR2019) |
29708822 (JAN2019) |
|||
APR2019 |
29314339 (12.2.0.1.190416) |
29230950 (JAN2019) |
29230821 (OCT2018) |
29301687 (12.2.0.1.190416) |
29231084 (JAN2019) |
29230829 (OCT2018) |
|||
JAN2019 |
28822515 (12.2.0.1.190115) |
28822638 (OCT2018) |
28790640 (JUL2018) |
28828733 (12.2.0.1.190115) |
28833185 (OCT2018) |
28833258 (JUL2018) |
|||
OCT2018 |
28662603 (12.2.0.1.181016) |
28507553 (JUL2018) |
28507749 (APR2018) |
28714316 (12.2.0.1.181016) |
28507693 (JUL2018) |
28507711 (APR2018) |
|||
JUL2018 |
28163133 (12.2.0.1.180717) |
27848049 (APR2018) |
27872031 (JAN2018) |
NA |
28251239 (APR2018) |
28251142 (JAN2018) |
|||
APR2018 |
27674384 (12.2.0.1.180417) |
27856791 (JAN2018) |
27427077 (OCT2017) |
27468969 (12.2.0.1.180417) |
27696736 (JAN2018) |
27696758 (OCT2017) |
|||
JAN2018 |
27105253 (12.2.0.1.180116) |
27013510(OCT2017) |
27013506 (JUL2017) |
27100009 ((12.2.0.1.180116) |
27224075 (OCT2017) |
27224023 (JUL2017) |
|||
OCT2017 |
26710464 (12.2.0.1.171017) |
26518812 (JUL2017) |
|
26737266 (12.2.0.1.171017) |
26878187 (JUL2017) |
|
|||
JUL2017 |
26123830 (12.2.0.1.170718) |
|
|
26133434((12.2.0.1.170718) |
|
|
|||
12.2.0.1 |
|||||||||
Description |
OJVM Update |
OJVM Windows Bundle Patch |
Combo OJVM + DB Update |
Combo OJVM + GI Update |
|||||
JUL2020 (12.2.0.1.200714) |
|||||||||
APR2020 (12.2.0.1.200414) |
|||||||||
JAN2020 (12.2.0.1.200114) |
|||||||||
OCT2019 (12.2.0.1.191015) |
|||||||||
JUL2019 (12.2.0.1.190716) |
|||||||||
APR2019 (12.2.0.1.190416) |
|||||||||
JAN2019 (12.2.0.1.190115) |
|||||||||
NOV2018 (12.2.0.1.181130) |
NA |
NA |
NA |
||||||
OCT2018 (12.2.0.1.181016) |
|||||||||
JUL2018 (12.2.0.1.180717) |
|||||||||
APR2018 (12.2.0.1.180417) |
|||||||||
JAN2018 (12.2.0.1.180116) |
|||||||||
OCT2017 (12.2.0.1.171017) |
|||||||||
AUG2017 (12.2.0.1.170814) |
N/A |
||||||||
JUL2017 (12.2.0.1.170718) |
12.1.0.2 |
||||||
Description |
OJVM PSU (Linux/Unix) |
OJVM BP (Windows) |
Combo OJVM + DB PSU |
Combo OJVM + GI PSU |
Combo OJVM + DB Proactive BP |
Generic JDBC |
JUL2020 (12.1.0.2.200714) |
Included in OJVM PSU |
|||||
APR2020 (12.1.0.2.200414) |
Included in OJVM PSU |
|||||
JAN2020 (12.1.0.2.200114) |
Included in OJVM PSU |
|||||
OCT2019 (12.1.0.2.191015) |
Included in OJVM PSU |
|||||
JUL2019 (12.1.0.2.190716) |
Included in OJVM PSU |
|||||
APR2019 (12.1.0.2.190416) |
Included in OJVM PSU |
|||||
JAN2019 (12.1.0.2.190115) |
Included in OJVM PSU |
|||||
NOV2018 (12.1.0.2.181130) |
NA |
NA |
NA |
NA |
Included in OJVM PSU |
|
OCT2018 (12.1.0.2.181016) |
Included in OJVM PSU |
|||||
JUL2018 (12.1.0.2.180717) |
Included in OJVM PSU |
|||||
APR2018 (12.1.0.2.180417) |
Included in OJVM PSU |
|||||
JAN2018 (12.1.0.2.180116) |
Included in OJVM PSU |
|||||
OCT2017 (12.1.0.2.171017) |
Included in OJVM PSU |
|||||
AUG2017 (12.1.0.2.170814) |
N/A |
Included in OJVM PSU |
||||
JUL2017 (12.1.0.2.170718) |
Included in OJVM PSU |
|||||
APR2017 (12.1.0.2.170418) |
Included in OJVM PSU |
|||||
JAN2017 (12.1.0.2.170117) |
Included in OJVM PSU |
|||||
OCT2016 (12.1.0.2.161018) |
Included in OJVM PSU |
|||||
JUL2016 (12.1.0.2.160719) |
23727148(Included in OJVM PSU) |
|||||
APR2016 (12.1.0.2.160419) |
N/A |
|||||
JAN2016 (12.1.0.2.160119) |
||||||
OCT2015 |
21555660(12.1.0.2.5) |
21788394(12.1.0.2.4) |
||||
JUL2015 |
21068507(12.1.0.2.4) |
21153530(12.1.0.2.3) |
||||
APR2015 |
20415564(12.1.0.2.3) |
20391199(12.1.0.2.2) |
||||
JAN2015 |
19877336(12.1.0.2.2) |
20225938(12.1.0.2.1) |
||||
OCT2014 (12.1.0.2.1) |
|
12.1.0.1 |
|||||
Description |
PSU |
GI PSU |
Bundle Patch |
||
A |
B |
Windows 64 bit |
Windows 32 bit |
||
JUL2016 (12.1.0.1.160719) |
|||||
APR2016 (12.1.0.1.160419) |
|||||
JAN2016 (12.1.0.1.160119) |
|||||
OCT2015 |
21352619(12.1.0.1.9) |
21551666(12.1.0.1.9) |
21551685(12.1.0.1.9) |
21744907 (12.1.0.1.21) |
|
JUL2015 |
20831107(12.1.0.1.8) |
20996901(12.1.0.1.8) |
20996911(12.1.0.1.8) |
21076681 (12.1.0.1.20) |
|
APR2015 |
20299016(12.1.0.1.7) |
20485762(12.1.0.1.7) |
19971331(12.1.0.1.7) |
20558101 (12.1.0.1.18) |
|
JAN2015 |
19769486(12.1.0.1.6) |
19971324(12.1.0.1.6) |
19971331(12.1.0.1.6) |
20160748 (12.1.0.1.16) |
|
OCT2014 |
19121550(12.1.0.1.5) |
19392372(12.1.0.1.5) |
19392451(12.1.0.1.5) |
19542943 (12.1.0.1.14) |
|
JUL2014 |
18522516(12.1.0.1.4) |
18705901(12.1.0.1.4) |
18705972(12.1.0.1.4) |
19062327 (12.1.0.1.11) |
|
APR2014 |
18031528(12.1.0.1.3) |
18139660(12.1.0.1.3) |
18413105(12.1.0.1.3) |
18448604 (12.1.0.1.7) |
|
JAN2014 |
17552800(12.1.0.1.2) |
17735306 (12.1.0.1.2) |
17977915 (12.1.0.1.3) |
||
OCT2013 |
17027533(12.1.0.1.1) |
17272829 (12.1.0.1.1) |
17363796(12.1.0.1.1) |
17363795(12.1.0.1.1) |
11.2.0.4 |
||||||
Description |
OJVM PSU (Linux/Unix) |
OJVM BP (Windows) |
Combo OJVM + DB PSU |
Combo OJVM + DB SPU |
Combo OJVM + GI PSU |
Generic JDBC |
JUL2020 (11.2.0.4.200714) |
Included in OJVM PSU |
|||||
APR2020 (11.2.0.4.200414) |
Included in OJVM PSU |
|||||
JAN2020 (11.2.0.4.200114) |
Included in OJVM PSU |
|||||
OCT2019 (11.2.0.4.191015) |
Included in OJVM PSU |
|||||
JUL2019 (11.2.0.4.190716) |
N/A |
Included in OJVM PSU |
||||
APR2019 (11.2.0.4.190416) |
N/A |
Included in OJVM PSU |
||||
JAN2019 (11.2.0.4.190115) |
Included in OJVM PSU |
|||||
OCT2018 (11.2.0.4.181016) |
Included in OJVM PSU |
|||||
JUL2018 (11.2.0.4.180717) |
Included in OJVM PSU |
|||||
APR2018 (11.2.0.4.180417) |
Included in OJVM PSU |
|||||
JAN2018 (11.2.0.4.180116) |
Included in OJVM PSU |
|||||
OCT2017 (11.2.0.4.171017) |
Included in OJVM PSU |
|||||
AUG2017 (11.2.0.4.170814) |
N/A |
N/A |
Included in OJVM PSU |
|||
JUL2017 (11.2.0.4.170718) |
Included in OJVM PSU |
|||||
APR2017 (11.2.0.4.170418) |
Included in OJVM PSU |
|||||
JAN2017 (11.2.0.4.170117) |
Included in OJVM PSU |
|||||
OCT2016 (11.2.0.4.161018) |
Included in OJVM PSU |
|||||
JUL2016 (11.2.0.4.160719) |
23727132(Included in OJVM PSU) |
|||||
APR2016 (11.2.0.4.160419) |
Included in OJVM PSU |
|||||
JAN2016 (11.2.0.4.160119) |
||||||
OCT2015 (11.2.0.4.5) |
||||||
JUL2015 (11.2.0.4.4) |
||||||
APR2015 (11.2.0.4.3) |
||||||
JAN2015 (11.2.0.4.2) |
||||||
OCT2014 (11.2.0.4.1) |
11.2.0.4 |
||||
Description |
PSU |
SPU(CPU) |
GI PSU |
Bundle Patch (Windows 32bit & 64bit) |
JUL2020 (11.2.0.4.200714) |
||||
APR2020 (11.2.0.4.200414) |
||||
JAN2020 (11.2.0.4.200114) |
||||
OCT2019 (11.2.0.4.191015) |
N/A |
|||
JUL2019 (11.2.0.4.190716) |
N/A |
|||
APR2019 (11.2.0.4.190416) |
||||
JAN2019 (11.2.0.4.190115) |
||||
OCT2018 (11.2.0.4.181016) |
||||
JUL2018 (11.2.0.4.180717) |
||||
APR2018 (11.2.0.4.180417) |
||||
JAN2018 (11.2.0.4.180116) |
N/A |
|||
OCT2017 (11.2.0.4.171017) |
||||
AUG2017 (11.2.0.4.170814) |
N/A |
|||
JUL2017 (11.2.0.4.170718) |
||||
APR2017 (11.2.0.4.170418) |
||||
JAN2017 |
N/A |
N/A |
N/A |
N/A |
OCT2016 (11.2.0.4.161018) |
||||
JUL2016 (11.2.0.4.160719) |
23530402 |
|||
APR2016 (11.2.0.4.160419) |
22839608 |
|||
JAN2016 (11.2.0.4.160119) |
22310544 |
|||
OCT2015 |
21352635 (11.2.0.4.8) |
21523375 (11.2.0.4.8) |
21821802 (11.2.0.4.20) |
|
JUL2015 |
20760982 (11.2.0.4.7) |
20996923 (11.2.0.4.7) |
21469106 (11.2.0.4.18) |
|
APR2015 |
20299013 (11.2.0.4.6) |
20485808 (11.2.0.4.6) |
20544696 (11.2.0.4.15) |
|
JAN2015 |
19769489 (11.2.0.4.5) |
19955028 (11.2.0.4.5) |
20127071 (11.2.0.4.12) |
|
OCT2014 |
19121551 (11.2.0.4.4) |
19380115 (11.2.0.4.4) |
19651773 (11.2.0.4.10) |
|
JUL2014 |
18522509 (11.2.0.4.3) |
18706472 (11.2.0.4.3) |
18842982 (11.2.0.4.7) |
|
APR2014 |
18031668 (11.2.0.4.2) |
18139609 (11.2.0.4.2) |
18296644 (11.2.0.4.4) |
|
JAN2014 |
17478514 (11.2.0.4.1) |
N/A |
17987366 (11.2.0.4.1) |
11.2.0.3 |
|||||
Description |
PSU |
SPU(CPU) |
GI PSU |
Bundle Patch (Windows 64bit) |
Bundle Patch (Windows 32bit) |
JUL2015 |
20760997 (11.2.0.3.15) |
20996944 (11.2.0.3.15) |
|||
APR2015 |
20299017 (11.2.0.3.14) |
20485830 (11.2.0.3.14) |
|||
JAN2015 |
19769496 (11.2.0.3.13) |
19971343 (11.2.0.3.13) |
|||
OCT2014 |
19121548 (11.2.0.3.12) |
19440385 (11.2.0.3.12) |
|||
JUL2014 |
18522512 (11.2.0.3.11) |
18706488 (11.2.0.3.11) |
|||
APR2014 |
18031683 (11.2.0.3.10) |
18139678 (11.2.0.3.10) |
|||
JAN2014 |
17540582 (11.2.0.3.9) |
17735354 (11.2.0.3.9) |
|||
OCT2013 |
16902043 (11.2.0.3.8) |
17272731 (11.2.0.3.8) |
|||
JUL2013 |
16619892 (11.2.0.3.7) |
16742216 (11.2.0.3.7) |
|||
APR2013 |
16056266 (11.2.0.3.6) |
16083653 (11.2.0.3.6) |
|||
JAN2013 |
14727310 (11.2.0.3.5) |
14727347 (11.2.0.3.5) |
|||
OCT2012 |
14275605 (11.2.0.3.4) |
14275572 (11.2.0.3.4) |
|||
JUL2012 |
13923374 (11.2.0.3.3) |
13919095 (11.2.0.3.3) |
|||
APR2012 |
13696216 (11.2.0.3.2) |
13696251 (11.2.0.3.2) |
|||
JAN2012 |
13343438 (11.2.0.3.1) |
13348650 (11.2.0.3.1) |
11.2.0.2 |
|||||
Description |
PSU |
SPU(CPU) |
GI PSU |
Bundle Patch (Windows 64bit) |
Bundle Patch (Windows 32bit) |
OCT2013 |
17082367 (11.2.0.2.12) |
17272753 (11.2.0.2.12) |
|||
JUL2013 |
16619893 (11.2.0.2.11) |
16742320 (11.2.0.2.11) |
|||
APR2013 |
16056267 (11.2.0.2.10) |
16166868 (11.2.0.2.10) |
|||
JAN2013 |
14727315 (11.2.0.2.9) |
14841385 (11.2.0.2.9) |
|||
OCT2012 |
14275621 (11.2.0.2.8) |
14390437 (11.2.0.2.8) |
|||
JUL2012 |
13923804 (11.2.0.2.7) |
14192201 (11.2.0.2.7) |
|||
APR2012 |
13696224 (11.2.0.2.6) |
13696242 (11.2.0.2.6) |
|||
JAN2012 |
13343424 (11.2.0.2.5) |
13653086 (11.2.0.2.5) |
|||
OCT2011 |
12827726 (11.2.0.2.4) |
12827731 (11.2.0.2.4) |
|||
JUL2011 |
12419331 (11.2.0.2.3) |
12419353 (11.2.0.2.3) |
|||
APR2011 |
11724916 (11.2.0.2.2) |
12311357 (11.2.0.2.2) |
|||
JAN2011 |
10248523 (11.2.0.2.1) |
N/A |
N/A |
11.2.0.1 |
||||
Description |
PSU |
CPU |
Bundle Patch (Windows 64bit) |
Bundle Patch (Windows 32bit) |
JUL2011 |
12419378 (11.2.0.1.6) |
|||
APR2011 |
11724930 (11.2.0.1.5) |
|||
JAN2011 |
10248516 (11.2.0.1.4) |
|||
OCT2010 |
9952216 (11.2.0.1.3) |
|||
JUL2010 |
9654983 (11.2.0.1.2) |
|||
APR2010 |
9352237 (11.2.0.1.1) |
N/A |
N/A |
10.2.0.5 |
|||||
Description |
PSU |
SPU(CPU) |
Bundle Patch (Windows 64bit) |
Bundle Patch (Windows 32bit) |
Bundle Patch (Windows Itanium) |
JUL2015 |
20299014(10.2.0.5.19) |
N/A |
|||
APR2015 |
N/A |
N/A |
N/A |
N/A |
N/A |
JAN2015 |
19769505(10.2.0.5.18) |
N/A |
|||
OCT2014 |
19274523(10.2.0.5.17) |
N/A |
|||
JUL2014 |
18522511(10.2.0.5.16) |
N/A |
|||
APR2014 |
18031728(10.2.0.5.15) |
N/A |
|||
JAN2014 |
17465584(10.2.0.5.14) |
N/A |
|||
OCT2013 |
17082365(10.2.0.5.13) |
N/A |
N/A |
||
JUL2013 |
16619894(10.2.0.5.12) |
||||
APR2013 |
16056270(10.2.0.5.11) |
||||
JAN2013 |
14727319(10.2.0.5.10) |
||||
OCT2012 |
14275629(10.2.0.5.9) |
||||
JUL2012 |
13923855(10.2.0.5.8) |
||||
APR2012 |
13632743(10.2.0.5.7) |
||||
JAN2012 |
13343471(10.2.0.5.6) |
N/A |
|||
OCT2011 |
12827745(10.2.0.5.5) |
N/A |
N/A |
||
JUL2011 |
12419392(10.2.0.5.4) |
N/A |
|||
APR2011 |
11724962(10.2.0.5.3) |
N/A |
|||
JAN2011 |
10248542(10.2.0.5.2) |
N/A |
|||
OCT2010 |
9952230(10.2.0.5.1) |
N/A |
10.2.0.4 |
|||||
Description |
PSU |
SPU(CPU) |
Bundle Patch (Windows 32bit) |
Bundle Patch (Windows 64bit) |
Bundle Patch (Windows Itanium) |
JUL2013 |
16619897 (10.2.0.4.17) |
N/A |
N/A |
N/A |
|
APR2013 |
16056269 (10.2.0.4.16) |
N/A |
N/A |
N/A |
|
JAN2013 |
14736542 (10.2.0.4.15) |
N/A |
N/A |
N/A |
|
OCT2012 |
14275630 (10.2.0.4.14) |
N/A |
N/A |
N/A |
|
JUL2012 |
13923851 (10.2.0.4.13) |
N/A |
N/A |
N/A |
|
APR2012 |
12879933 (10.2.0.4.12) |
N/A |
|||
JAN2012 |
12879929 (10.2.0.4.11) |
N/A |
N/A |
||
OCT2011 |
12827778 (10.2.0.4.10) |
||||
JUL2011 |
12419397 (10.2.0.4.9) |
||||
APR2011 |
11724977 (10.2.0.4.8) |
||||
JAN2011 |
10248636 (10.2.0.4.7) |
||||
OCT2010 |
9952234 (10.2.0.4.6) |
||||
JUL2010 |
9654991 (10.2.0.4.5) |
||||
APR2010 |
9352164 (10.2.0.4.4) |
||||
JAN2010 |
9119284 (10.2.0.4.3) |
||||
OCT2009 |
8833280 (10.2.0.4.2) |
||||
JUL2009 |
8576156 (10.2.0.4.1) |
||||
APR2009 |
N/A |
||||
JAN2009 |
N/A |
N/A |
|||
OCT2008 |
N/A |
N/A |
|||
JUL2008 |
N/A |
N/A |
10.2.0.3 |
||||
Description |
CPU (Unix/Linux) |
Bundle Patch (Windows 32bit) |
Bundle Patch (Windows Itanium) |
Bundle Patch (Windows 64bit) |
JAN2009 |
||||
OCT2008 |
||||
JUL2008 |
||||
APR2008 |
||||
JAN2008 |
||||
OCT2007 |
||||
JUL2007 |
||||
APR2007 |
||||
JAN2007 |
10.2.0.2 |
||||
Description |
CPU (Unix/Linux) |
Bundle Patch (Windows 32bit) |
Bundle Patch (Windows 64bit) |
Bundle Patch (Windows Itanium) |
JAN2009 |
N/A |
N/A |
N/A |
|
OCT2008 |
N/A |
N/A |
N/A |
|
JUL2008 |
N/A |
N/A |
N/A |
|
APR2008 |
N/A |
N/A |
N/A |
|
JAN2008 |
N/A |
N/A |
N/A |
|
OCT2007 |
||||
JUL2007 |
||||
APR2007 |
||||
JAN2007 |
||||
OCT2006 |
||||
JUL2006 |
||||
APR2006 |
10.2.0.1 |
||||
Description |
CPU (Unix/Linux) |
Bundle Patch (Windows 32bit) |
Bundle Patch (Windows 64bit) |
Bundle Patch (Windows Itanium) |
APR2007 |
N/A |
N/A |
N/A |
|
JAN2007 |
||||
OCT2006 |
||||
JUL2006 |
||||
APR2006 |
||||
JAN2006 |
10.1.0.5 |
|||
Description |
CPU (Unix/Linux) |
Bundle Patch (Windows 32bit) |
Bundle Patch (Windows Itanium) |
JAN2012 |
|||
OCT2011 |
|||
JUL2011 |
|||
APR2011 |
|||
JAN2011 |
N/A |
N/A |
N/A |
OCT2010 |
|||
JUL2010 |
|||
APR2010 |
|||
JAN2010 |
|||
OCT2009 |
|||
JUL2009 |
|||
APR2009 |
|||
JAN2009 |
|||
OCT2008 |
|||
JUL2008 |
|||
APR2008 |
|||
JAN2008 |
|||
OCT2007 |
|||
JUL2007 |
|||
APR2007 |
|||
JAN2007 |
|||
OCT2006 |
|||
JUL2006 |
|||
APR2006 |
|||
JAN2006 |
10.1.0.4 |
|||
Description |
CPU (Unix/Linux) |
Bundle Patch (Windows 32bit) |
Bundle Patch (Windows Itanium) |
APR2007 |
|||
JAN2007 |
|||
OCT2006 |
|||
JUL2006 |
|||
APR2006 |
|||
JAN2006 |
|||
OCT2005 |
|||
JUL2005 |
|||
APR2005 |
10.1.0.3 |
|||
Description |
CPU (Unix/Linux) |
Bundle Patch (Windows 32bit) |
Bundle Patch (Windows Itanium) |
JAN2007 |
N/A |
N/A |
|
OCT2006 |
N/A |
N/A |
|
JUL2006 |
N/A |
N/A |
|
APR2006 |
N/A |
N/A |
|
JAN2006 |
|||
OCT2005 |
|||
JUL2005 |
|||
APR2005 |
|||
JAN2005 |
10.1.0.2 |
|||
Description |
CPU (Unix/Linux) |
Bundle Patch (Windows 32bit) |
Bundle Patch (Windows Itanium) |
APR2005 |
|||
JUL2005 |
|||
JAN2005 |
9.2.0.8 |
|||
Description |
CPU (Unix/Linux) |
Bundle Patch (Windows 32bit) |
Bundle Patch (Windows Itanium) |
JUL2010 |
|||
APR2010 |
N/A |
||
JAN2010 |
N/A |
||
OCT2009 |
|||
JUL2009 |
|||
APR2009 |
|||
JAN2009 |
|||
OCT2008 |
|||
JUL2008 |
|||
APR2008 |
|||
JAN2008 |
|||
OCT2007 |
|||
JUL2007 |
|||
APR2007 |
|||
JAN2007 |
N/A |
N/A |
N/A |
OCT2006 |
9.2.0.7 |
|||
Description |
CPU (Unix/Linux) |
Bundle Patch (Windows 32bit) |
Bundle Patch (Windows Itanium) |
JUL2007 |
|||
APR2007 |
|||
JAN2007 |
|||
OCT2006 |
|||
JUL2006 |
|||
APR2006 |
|||
JAN2006 |
|||
OCT2005 |
|||
JUL2005 |
N/A |
N/A |
9.2.0.6 |
|||
Description |
CPU (Unix/Linux) |
Bundle Patch (Windows 32bit) |
Bundle Patch (Windows Itanium) |
OCT2006 |
|||
JUL2006 |
|||
APR2006 |
|||
JAN2006 |
|||
OCT2005 |
|||
JUL2005 |
|||
APR2005 |
9.2.0.5 |
|||
Description |
CPU (Unix/Linux) |
Bundle Patch (Windows 32bit) |
Bundle Patch (Windows Itanium) |
OCT2006 |
N/A |
N/A |
|
JUL2006 |
N/A |
N/A |
|
APR2006 |
N/A |
N/A |
|
OCT2005 |
N/A |
N/A |
|
JUL2005 |
|||
APR2005 |
|||
JAN2005 |
9.2.0.4 |
|||
Description |
CPU (Unix/Linux) |
Bundle Patch (Windows 32bit) |
Bundle Patch (Windows Itanium) |
JAN2005 |
8.1.7.4 |
||
Description |
CPU (Unix/Linux) |
Bundle Patch (Windows 32bit) |
JAN2007 |
||
OCT2006 |
||
JUL2006 |
||
APR2006 |
||
JAN2006 |
||
OCT2005 |
||
JUL2005 |
||
APR2005 |
||
JAN2005 |
参考:Assistant: Download Reference for Oracle Database/GI Update, Revision, PSU, SPU(CPU), Bundle Patches, Patchsets and Base Releases (文档 ID 2118136.2)
无法启动此程序,因为计算机中丢失api-ms-win-crt-runtime-l1-1-0.dll
在新安装的win操作操作系统中安装oracle 19.3版本数据库,结果不幸遭遇到如下错误
查询oracle 19c对于win操作系统认证列表
本机操作系统为win 2012,在此认证列表中
通过上述认证查询以及是新安装的原版系统,很可能是由于19c安装特殊之处导致,通过查询mos,确认是由于19c的数据库在安装之时perl需要VS 2017的运行库进行一些操作的依赖,因此安装Microsoft Visual C++ Redistributable for Visual Studio 2017或者更高版本即可.下载link:https://aka.ms/vs/16/release/vc_redist.x64.exe
具体参考MOS:Oracle DB 19C Install fails with the error – “THE PROCEDURE ENTRY POINT _REGISTER_ONEXIT_FUNCTION COULD NOT BE LOCATED IN THE DYNAMIC LINK LIBRARY