11.2.0.4最新psu-202404

联系:手机/微信(+86 17813235971) QQ(107644445)QQ咨询惜分飞

标题:11.2.0.4最新psu-202404

作者:惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]

最近发现11.2.0.4的版本在2024年4月份又更新了新的psu,证明在即将进入23ai的时代该版本还有万千的生命力

11.2.0.4 Database Patch Set Update

Release Date Version Download link Included in Windows Bundle
16-Apr-2024 11.2.0.4.240416 (Apr 2024) Database Patch Set Update (DB PSU) Patch 36222299 * Out of Error Correction
16-Jan-2024 ** * Out of Error Correction
17-Oct-2023 11.2.0.4.231017 (Oct 2023) Database Patch Set Update (DB PSU) Patch 35574075 * Out of Error Correction
18-Jul-2023 11.2.0.4.230718 (Jul 2023) Database Patch Set Update (DB PSU) Patch 35269283 * Out of Error Correction
18-Apr-2023 11.2.0.4.230418 (Apr 2023) Database Patch Set Update (DB PSU) Patch 34998337 * Out of Error Correction
17-Jan-2023 11.2.0.4.230117 (Jan 2023) Database Patch Set Update (DB PSU) Patch 34677698 * Out of Error Correction
18-Oct-2022 11.2.0.4.221018 (Oct 2022) Database Patch Set Update (DB PSU) Patch 34386237 Patch 34474433
19-Jul-2022 11.2.0.4.220719 (Jul 2022) Database Patch Set Update (DB PSU) Patch 34057724 Patch 33883353
19-Apr-2022 11.2.0.4.220419 (Apr 2022) Database Patch Set Update (DB PSU) Patch 33711103 Patch 33776715
18-Jan-2022 11.2.0.4.220118 (Jan 2022) Database Patch Set Update (DB PSU) Patch 33477185 Patch 33488457
19-Oct-2021 11.2.0.4.211019 (Oct 2021) Database Patch Set Update (DB PSU) Patch 33128584 Patch 33174351
20-Jul-2021 11.2.0.4.210720 (Jul 2021) Database Patch Set Update (DB PSU) Patch 32758711 Patch 32775108
20-Apr-2021 11.2.0.4.210420 (Apr 2021) Database Patch Set Update (DB PSU) Patch 32328626 Patch 32392141
19-Jan-2021 11.2.0.4.210119 (Jan 2021) Database Patch Set Update (DB PSU) Patch 31983472 Patch 32003403
20-Oct-2020 11.2.0.4.201020 (Oct 2020) Database Patch Set Update (DB PSU) Patch 31537677 Patch 31659823
14-Jul-2020 11.2.0.4.200714 (Jul 2020) Database Patch Set Update (DB PSU) Patch 31103343 Patch 31169916
14-Apr-2020 11.2.0.4.200414 (Apr 2020) Database Patch Set Update (DB PSU) Patch 30670774 Patch 31169916
14-Jan-2020 11.2.0.4.200114 (Jan 2020) Database Patch Set Update (DB PSU) Patch 30298532 Patch 30502376
15-Oct-2019 11.2.0.4.191015 (Oct 2019) Database Patch Set Update (DB PSU) Patch 29913194 Patch 30151661
16-Jul-2019 11.2.0.4.190716 (Jul 2019) Database Patch Set Update (DB PSU) Patch 29497421 Patch 29596609
16-Apr-2019 11.2.0.4.190416 (Apr 2019) Database Patch Set Update (DB PSU) Patch 29141056 Patch 29218820
15-Jan-2019 11.2.0.4.190115 (Jan 2019) Database Patch Set Update (DB PSU) Patch 28729262 Patch 28761877
16-Oct-2018 11.2.0.4.181016 (Oct 2018) Database Patch Set Update (DB PSU) Patch 28204707 Patch 28265827
17-Jul-2018 11.2.0.4.180717 (Jul 2018) Database Patch Set Update (DB PSU) Patch 27734982 Patch 27695940
17-Apr-2018 11.2.0.4.180417 (Apr 2018) Database Patch Set Update (DB PSU) Patch 27338049 Patch 27426753
16-Jan-2018 11.2.0.4.180116 (Jan 2018) Database Patch Set Update (DB PSU) Patch 26925576 Patch 26925576
17-Oct-2017 11.2.0.4.171017 (Oct 2017) Database Patch Set Update (DB PSU) Patch 26392168 Patch 26581376
14-Aug-2017 11.2.0.4.170814 (Jul 2017) Database Patch Set Update (DB PSU) Patch 26609445 Patch 26194138
18-Jul-2017 11.2.0.4.170718 (Jul 2017) Database Patch Set Update (DB PSU) Patch 25869727 Patch 26194136
18-Apr-2017 11.2.0.4.170418 (Apr 2017) Database Patch Set Update (DB PSU) Patch 24732075 Patch 25632525
17-Jan-2017 **
18-Oct-2016 11.2.0.4.161018 (Oct 2016) Database Patch Set Update (DB PSU) Patch 24006111 Patch 24591646
19-Jul-2016 11.2.0.4.160719 (Jul 2016) Database Patch Set Update (DB PSU) Patch 23054359 Patch 23530402
19-Apr-2016 11.2.0.4.160419 (Apr 2016) Database Patch Set Update (DB PSU) Patch 22502456 Patch 22839608
19-Jan-2016 11.2.0.4.160119 (Jan 2016) Database Patch Set Update (DB PSU) Patch 21948347 Patch 22310544
20-Oct-2015 11.2.0.4.8 (Oct 2015) Database Patch Set Update (DB PSU) Patch 21352635 Patch 21821802
14-Jul-2015 11.2.0.4.7 (Jul 2015) Database Patch Set Update (DB PSU) Patch 20760982 Patch 20833831
14-Apr-2015 11.2.0.4.6 (Apr 2015) Database Patch Set Update (DB PSU) Patch 20299013 Patch 20544696
20-Jan-2015 11.2.0.4.5 (Jan 2015) Database Patch Set Update (DB PSU) Patch 19769489 Patch 20127071
14-Oct-2014 11.2.0.4.4 (Oct 2014) Database Patch Set Update (DB PSU) Patch 19121551 Patch 19651773
14-Jul-2014 11.2.0.4.3 (Jul 2014) Database Patch Set Update (DB PSU) Patch 18522509 Patch 18842982
15-Apr-2014 11.2.0.4.2 (Apr 2014) Database Patch Set Update (PSU) Patch 18031668 Patch 18296644
15-Jan-2014 11.2.0.4.1 (Jan 2014) Database Patch Set Update (PSU) Patch 17478514 Patch 17987366

11.2.0.4 Grid Infrastructure Patch Set Update

Release Date Version Download link
16-Apr-2024 11.2.0.4.240416 (Apr 2024) Grid Infrastructure Patch Set Update (GI PSU) Patch 36360774
16-Jan-2024 **
17-Oct-2023 11.2.0.4.231017 (Oct 2023) Grid Infrastructure Patch Set Update (GI PSU) Patch 35685688
18-Jul-2023 11.2.0.4.230718 (Jul 2023) Grid Infrastructure Patch Set Update (GI PSU) Patch 35369867
18-Apr-2023 11.2.0.4.230418 (Apr 2023) Grid Infrastructure Patch Set Update (GI PSU) Patch 35058300
17-Jan-2023 11.2.0.4.230117 (Jan 2023) Grid Infrastructure Patch Set Update (GI PSU) Patch 34774506
18-Oct-2022 11.2.0.4.221018 (Oct 2022) Grid Infrastructure Patch Set Update (GI PSU) Patch 34536853
19-Jul-2022 11.2.0.4.220719 (Jul 2022) Grid Infrastructure Patch Set Update (GI PSU) Patch 34204533
19-Apr-2022 11.2.0.4.220419 (Apr 2022) Grid Infrastructure Patch Set Update (GI PSU) Patch 33829709
18-Jan-2022 11.2.0.4.220118 (Jan 2022) Grid Infrastructure Patch Set Update (GI PSU) Patch 33575261
19-Oct-2021 11.2.0.4.211019 (Oct 2021) Grid Infrastructure Patch Set Update (GI PSU) Patch 33248354
20-Jul-2021 11.2.0.4.210720 (Jul 2021) Grid Infrastructure Patch Set Update (GI PSU) Patch 32917428
20-Apr-2021 11.2.0.4.210420 (Apr 2021) Grid Infrastructure Patch Set Update (GI PSU) Patch 32495145
19-Jan-2021 11.2.0.4.210119 (Jan 2021) Grid Infrastructure Patch Set Update (GI PSU) Patch 32131250
20-Oct-2020 11.2.0.4.201020 (Oct 2020) Grid Infrastructure Patch Set Update (GI PSU) Patch 31718723
14-Jul-2020 11.2.0.4.200714 (Jul 2020) Grid Infrastructure Patch Set Update (GI PSU) Patch 31305209
14-Apr-2020 11.2.0.4.200414 (Apr 2020) Grid Infrastructure Patch Set Update (GI PSU) Patch 30805461
14-Jan-2020 11.2.0.4.200114 (Jan 2020) Grid Infrastructure Patch Set Update (GI PSU) Patch 30501155
15-Oct-2019 11.2.0.4.191015 (Oct 2019) Grid Infrastructure Patch Set Update (GI PSU) Patch 30070097
16-Jul-2019 11.2.0.4.190716 (Jul 2019) Grid Infrastructure Patch Set Update (GI PSU) Patch 29698727
16-Apr-2019 11.2.0.4.190416 (Apr 2019) Grid Infrastructure Patch Set Update (GI PSU) Patch 29255947
15-Jan-2019 11.2.0.4.190115 (Jan 2019) Grid Infrastructure Patch Set Update (GI PSU) Patch 28813878
16-Oct-2018 11.2.0.4.181016 (Oct 2018) Grid Infrastructure Patch Set Update (GI PSU) Patch 28429134
17-Jul-2018 11.2.0.4.180717 (Jul 2018) Grid Infrastructure Patch Set Update (GI PSU) Patch 27967757
17-Apr-2018 11.2.0.4.180417 (Apr 2018) Grid Infrastructure Patch Set Update (GI PSU) Patch 27475913
16-Jan-2018 11.2.0.4.180116 (Jan 2018) Grid Infrastructure Patch Set Update (GI PSU) Patch 27107360
17-Oct-2017 11.2.0.4.171017 (Oct 2017) Grid Infrastructure Patch Set Update (GI PSU) Patch 26635745
14-Aug-2017 11.2.0.4.170814 (Jul 2017) Grid Infrastructure Patch Set Update (GI PSU) Patch 26610246
18-Jul-2017 11.2.0.4.170718 (Jul 2017) Grid Infrastructure Patch Set Update (GI PSU) Patch 26030799
18-Apr-2017 11.2.0.4.170418 (Apr 2017) Grid Infrastructure Patch Set Update (GI PSU) Patch 25476126
17-Jan-2017 **
18-Oct-2016 11.2.0.4.161018 (Oct 2016) Grid Infrastructure Patch Set Update (GI PSU) Patch 24436338
19-Jul-2016 11.2.0.4.160719 (Jul 2016) Grid Infrastructure Patch Set Update (GI PSU) Patch 23274134
19-Apr-2016 11.2.0.4.160419 (Apr 2016) Grid Infrastructure Patch Set Update (GI PSU) Patch 22646198
19-Jan-2016 11.2.0.4.160119 (Jan 2016) Grid Infrastructure Patch Set Update (GI PSU) Patch 22191577
20-Oct-2015 11.2.0.4.8 (Oct 2015) Grid Infrastructure Patch Set Update (GI PSU) Patch 21523375
14-Jul-2015 11.2.0.4.7 (Jul 2015) Grid Infrastructure Patch Set Update (GI PSU) Patch 20996923
14-Apr-2015 11.2.0.4.6 (Apr 2015) Grid Infrastructure Patch Set Update (GI PSU) Patch 20485808
20-Jan-2015 11.2.0.4.5 (Jan 2015) Grid Infrastructure Patch Set Update (GI PSU) Patch 19955028
14-Oct-2014 11.2.0.4.4 (Oct 2014) Grid Infrastructure Patch Set Update (GI PSU) Patch 19380115
15-Jul-2014 11.2.0.4.3 (Jul 2014) Grid Infrastructure Patch Set Update (GI PSU) Patch 18706472
15-Apr-2014 11.2.0.4.2 (Apr 2014) Grid Infrastructure Patch Set Update (GI PSU) Patch 18139609

11.2.0.4 OJVM Patch Set Update

Release Date Version Unix PSU Patch Windows Bundle Patch
16-Apr-2024 11.2.0.4.240416 (Apr 2024) OJVM Component Patch Set Update Patch 36222352 * Out of Error Correction
16-Jan-2024 11.2.0.4.240116 (Jan 2024) OJVM Component Patch Set Update Patch 35926733 * Out of Error Correction
17-Oct-2023 11.2.0.4.231017 (Oct 2023) OJVM Component Patch Set Update Patch 35685663 * Out of Error Correction
18-Jul-2023 11.2.0.4.230718 (Jul 2023) OJVM Component Patch Set Update Patch 35349843 * Out of Error Correction
18-Apr-2023 11.2.0.4.230418 (Apr 2023) OJVM Component Patch Set Update Patch 35039831 * Out of Error Correction
17-Jan-2023 11.2.0.4.230117 (Jan 2023) OJVM Component Patch Set Update Patch 34763334 * Out of Error Correction
18-Oct-2022 11.2.0.4.221018 (Oct 2022) OJVM Component Patch Set Update Patch 34412266 Patch 34513867
19-Jul-2022 11.2.0.4.220719 (Jul 2022) OJVM Component Patch Set Update Patch 34085652 Patch 34185082
19-Apr-2022 11.2.0.4.220419 (Apr 2022) OJVM Component Patch Set Update Patch 33829826 Patch 33881335
18-Jan-2022 11.2.0.4.220118 (Jan 2022) OJVM Component Patch Set Update Patch 33561250 Patch 33577510
19-Oct-2021 11.2.0.4.211019 (Oct 2021) OJVM Component Patch Set Update Patch 33192642 Patch 33248711
20-Jul-2021 11.2.0.4.210720 (Jul 2021) OJVM Component Patch Set Update Patch 32876451 Patch 32905855
20-Apr-2021 11.2.0.4.210420 (Apr 2021) OJVM Component Patch Set Update Patch 32671980 Patch 32428494
19-Jan-2021 11.2.0.4.210119 (Jan 2021) OJVM Component Patch Set Update ** Patch 32145687
20-Oct-2020 11.2.0.4.201020 (Oct 2020) OJVM Component Patch Set Update Patch 31668908 Patch 31740195
14-Jul-2020 11.2.0.4.200714 (Jul 2020) OJVM Component Patch Set Update Patch 31219953 Patch 31169916
14-Apr-2020 11.2.0.4.200414 (Apr 2020) OJVM Component Patch Set Update Patch 30805543 Patch 31169933
14-Jan-2020 11.2.0.4.200114 (Jan 2020) OJVM Component Patch Set Update Patch 30503372 Patch 30671044
15-Oct-2019 11.2.0.4.191015 (Oct 2019) OJVM Component Patch Set Update Patch 30132974 Patch 30268157
16-Jul-2019 11.2.0.4.190716 (Jul 2019) OJVM Component Patch Set Update Patch 29610422 Patch 30012911
16-Apr-2019 11.2.0.4.190416 (Apr 2019) OJVM Component Patch Set Update Patch 29251270 Patch 29447971
15-Jan-2019 11.2.0.4.190115 (Jan 2019) OJVM Component Patch Set Update Patch 28790660 Patch 28994059
16-Oct-2018 11.2.0.4.181016 (Oct 2018) OJVM Component Patch Set Update Patch 28440700 Patch 28412269
17-Jul-2018 11.2.0.4.180717 (Jul 2018) OJVM Component Patch Set Update Patch 27923163 Patch 28135121
17-Apr-2018 11.2.0.4.180417 (Apr 2018) OJVM Component Patch Set Update Patch 27475598 Patch 27381640
16-Jan-2018 11.2.0.4.180116 (Jan 2018) OJVM Component Patch Set Update Patch 26925532 Patch 27163009
17-Oct-2017 11.2.0.4.171017 (Oct 2017) OJVM Component Patch Set Update Patch 26635834 Patch 26792358
18-Jul-2017 11.2.0.4.170718 (Jul 2017) OJVM Component Patch Set Update Patch 26027154 Patch 26182425
18-Apr-2017 11.2.0.4.170418 (Apr 2017) OJVM Component Patch Set Update Patch 25434033 Patch 25590979
17-Jan-2017 11.2.0.4.170117 (Jan 2017) OJVM Component Patch Set Update Patch 24917954 Patch 25043019
18-Oct-2016 11.2.0.4.161018 (Oct 2016) OJVM Component Patch Set Update Patch 24315821 Patch 24591637
19-Jul-2016 11.2.0.4.160719 (Jul 2016) OJVM Component Patch Set Update Patch 23177551 Patch 23515277
19-Apr-2016 11.2.0.4.160419 (Apr 2016) OJVM Component Patch Set Update Patch 22674697 Patch 22839614
19-Jan-2016 11.2.0.4.160119 (Jan 2016) OJVM Component Patch Set Update Patch 22139245 Patch 22311053
20-Oct-2015 11.2.0.4.5 (Oct 2015) OJVM Component Patch Set Update Patch 21555791 Patch 21788344
14-Jul-2015 11.2.0.4.4 (Jul 2015) OJVM Component Patch Set Update Patch 21068539 Patch 21153498
14-Apr-2015 11.2.0.4.3 (Apr 2015) OJVM Component Patch Set Update Patch 20406239 Patch 20225988
20-Jan-2015 11.2.0.4.2 (Jan 2015) OJVM Component Patch Set Update Patch 19877440 Patch 20225982
14-Oct-2014 11.2.0.4.1 (Oct 2014) OJVM Component Patch Set Update Patch 19282021 Patch 19799291

Database PSU COMBO: 11.2.0.4 Database Patch Set Update and 11.2.0.4 OJVM Patch Set Update

Release Date Version Download Link
16-Apr-2024 Combo OJVM PSU 11.2.0.4.240416 and DB PSU 11.2.0.4.240416 Patch 36517603
16-Jan-2024 **
17-Oct-2023 Combo OJVM PSU 11.2.0.4.231017 and DB PSU 11.2.0.4.231017 Patch 35742488
18-Jul-2023 Combo OJVM PSU 11.2.0.4.230718 and DB PSU 11.2.0.4.230718 Patch 35370078
18-Apr-2023 Combo OJVM PSU 11.2.0.4.230418 and DB PSU 11.2.0.4.230418 Patch 35084468
17-Jan-2023 Combo OJVM PSU 11.2.0.4.230117 and DB PSU 11.2.0.4.230117 Patch 34773608
18-Oct-2022 Combo OJVM PSU 11.2.0.4.221018 and DB PSU 11.2.0.4.221018 Patch 34449295
19-Jul-2022 Combo OJVM PSU 11.2.0.4.220719 and DB PSU 11.2.0.4.220719 Patch 34163705
19-Apr-2022 Combo OJVM PSU 11.2.0.4.220419 and DB PSU 11.2.0.4.220419 Patch 33881679
18-Jan-2022 Combo OJVM PSU 11.2.0.4.220118 and DB PSU 11.2.0.4.220118 Patch 33560092
19-Oct-2021 Combo OJVM PSU 11.2.0.4.211019 and DB PSU 11.2.0.4.211019 Patch 33248641
20-Jul-2021 Combo OJVM PSU 11.2.0.4.210720 and DB PSU 11.2.0.4.210720 Patch 32900228
20-Apr-2021 Combo OJVM PSU 11.2.0.4.201020 and DB PSU 11.2.0.4.210420 Patch 32579111
19-Jan-2021 Combo OJVM PSU 11.2.0.4.201020 and DB PSU 11.2.0.4.210119 Patch 32126939
20-Oct-2020 Combo OJVM PSU 11.2.0.4.201020 and DB PSU 11.2.0.4.201020 Patch 31720776
14-Jul-2020 Combo OJVM PSU 11.2.0.4.200714 and DB PSU 11.2.0.4.200714 Patch 31326405
14-Apr-2020 Combo OJVM PSU 11.2.0.4.200414 and DB PSU 11.2.0.4.200414 Patch 30783889
14-Jan-2020 Combo OJVM PSU 11.2.0.4.200114 and DB PSU 11.2.0.4.200114 Patch 30463718
15-Oct-2019 Combo OJVM PSU 11.2.0.4.191015 and DB PSU 11.2.0.4.191015 Patch 30133482
16-Jul-2019 Combo OJVM PSU 11.2.0.4.190716 and DB PSU 11.2.0.4.190716 Patch 29699294
16-Apr-2019 Combo OJVM PSU 11.2.0.4.190416 and DB PSU 11.2.0.4.190416 Patch 29252186
15-Jan-2019 Combo OJVM PSU 11.2.0.4.190115 and DB PSU 11.2.0.4.190115 Patch 28980129
16-Oct-2018 Combo OJVM PSU 11.2.0.4.181016 and DB PSU 11.2.0.4.181016 Patch 28689165
17-Jul-2018 Combo OJVM PSU 11.2.0.4.180717 and DB PSU 11.2.0.4.180717 Patch 28317183
17-Apr-2018 Combo OJVM PSU 11.2.0.4.180417 and DB PSU 11.2.0.4.180417 Patch 27726500
16-Jan-2018 Combo OJVM PSU 11.2.0.4.180116 and DB PSU 11.2.0.4.180116 Patch 27011017
17-Oct-2017 Combo OJVM PSU 11.2.0.4.171017 and DB PSU 11.2.0.4.171017 Patch 26636031
18-Jul-2017 Combo OJVM PSU 11.2.0.4.170718 and DB PSU 11.2.0.4.170718 Patch 26031209
18-Apr-2017 Combo OJVM PSU 11.2.0.4.170418 and DB PSU 11.2.0.4.170418 Patch 25440428
17-Jan-2017 Combo OJVM PSU 11.2.0.4.170117 and DB PSU 11.2.0.4.170117 Patch 24918033
18-Oct-2016 Combo OJVM PSU 11.2.0.4.161018 and DB PSU 11.2.0.4.161018 Patch 24436313
19-Jul-2016 Combo OJVM PSU 11.2.0.4.160719 and DB PSU 11.2.0.4.160719 Patch 23615392
19-Apr-2016 Combo OJVM PSU 11.2.0.4.160419 and DB PSU 11.2.0.4.160419 Patch 22738777
19-Jan-2016 Combo OJVM PSU 11.2.0.4.160119 and DB PSU 11.2.0.4.160119 Patch 22378146
20-Oct-2015 Combo OJVM PSU 11.2.0.4.5 and DB PSU 11.2.0.4.8 Patch 21744343
14-Jul-2015 Combo OJVM PSU 11.2.0.4.4 and DB PSU 11.2.0.4.7 Patch 21150851
14-Apr-2015 Combo OJVM PSU 11.2.0.4.3 and DB PSU 11.2.0.4.6 Patch 20834611
20-Jan-2015 Combo OJVM PSU 11.2.0.4.2 and DB PSU 11.2.0.4.5 Patch 20132580
14-Oct-2014 Combo OJVM PSU 11.2.0.4.1 and DB PSU 11.2.0.4.4 Patch 19791364

Grid Infrastructure COMBO: 11.2.0.4 Grid Infrastructure Patch Set Update and 11.2.0.4 OJVM Patch Set Update

Release Date Version Download Link
16-Apr-2024 Combo OJVM PSU 11.2.0.4.240416 and GI PSU 11.2.0.4.240416 Patch 36517615
16-Jan-2024 **
17-Oct-2023 Combo OJVM PSU 11.2.0.4.231017 and GI PSU 11.2.0.4.231017 Patch 35742504
18-Jul-2023 Combo OJVM PSU 11.2.0.4.230718 and GI PSU 11.2.0.4.230718 Patch 35370071
18-Apr-2023 Combo OJVM PSU 11.2.0.4.230418 and GI PSU 11.2.0.4.230418 Patch 35084475
17-Jan-2023 Combo OJVM PSU 11.2.0.4.230117 and GI PSU 11.2.0.4.230117 Patch 34773624
18-Oct-2022 Combo OJVM PSU 11.2.0.4.221018 and GI PSU 11.2.0.4.221018 Patch 34449296
19-Jul-2022 Combo OJVM PSU 11.2.0.4.220719 and GI PSU 11.2.0.4.220719 Patch 34163709
19-Apr-2022 Combo OJVM PSU 11.2.0.4.220419 and GI PSU 11.2.0.4.2200419 Patch 33881691
18-Jan-2022 Combo OJVM PSU 11.2.0.4.220118 and GI PSU 11.2.0.4.220118 Patch 33560103
19-Oct-2021 Combo OJVM PSU 11.2.0.4.211019 and GI PSU 11.2.0.4.211019 Patch 33248615
20-Jul-2021 Combo OJVM PSU 11.2.0.4.210720 and GI PSU 11.2.0.4.210720 Patch 32900245
20-Apr-2021 Combo OJVM PSU 11.2.0.4.201020 and GI PSU 11.2.0.4.210420 Patch 32579106
19-Jan-2021 Combo OJVM PSU 11.2.0.4.201020 and GI PSU 11.2.0.4.210119 Patch 32126942
20-Oct-2020 Combo OJVM PSU 11.2.0.4.201020 and GI PSU 11.2.0.4.201020 Patch 31720783
14-Jul-2020 Combo OJVM PSU 11.2.0.4.200714 and GI PSU 11.2.0.4.200714 Patch 31326410
14-Apr-2020 Combo OJVM PSU 11.2.0.4.200414 and GI PSU 11.2.0.4.200414 Patch 30783890
14-Jan-2020 Combo OJVM PSU 11.2.0.4.200114 and GI PSU 11.2.0.4.200114 Patch 30463729
15-Oct-2019 Combo OJVM PSU 11.2.0.4.191015 and GI PSU 11.2.0.4.191015 Patch 30133506
16-Jul-2019 Combo OJVM PSU 11.2.0.4.190716 and GI PSU 11.2.0.4.190716 Patch 29699309
16-Apr-2019 Combo OJVM PSU 11.2.0.4.190416 and GI PSU 11.2.0.4.190416 Patch 29252208
15-Jan-2019 Combo OJVM PSU 11.2.0.4.190115 and GI PSU 11.2.0.4.190115 Patch 28980134
16-Oct-2018 Combo OJVM PSU 11.2.0.4.181016 and GI PSU 11.2.0.4.181016 Patch 28689170
17-Jul-2018 Combo OJVM PSU 11.2.0.4.180717 and GI PSU 11.2.0.4.180717 Patch 28317141
17-Apr-2018 Combo OJVM PSU 11.2.0.4.180417 and GI PSU 11.2.0.4.180417 Patch 27726505
16-Jan-2018 Combo OJVM PSU 11.2.0.4.180116 and GI PSU 11.2.0.4.180116 Patch 27282436
17-Oct-2017 Combo OJVM PSU 11.2.0.4.171017 and GI PSU 11.2.0.4.171017 Patch 26636028
18-Jul-2017 Combo OJVM PSU 11.2.0.4.170718 and GI PSU 11.2.0.4.170718 Patch 26030870
18-Apr-2017 Combo OJVM PSU 11.2.0.4.170418 and GI PSU 11.2.0.4.170418 Patch 25440422
17-Jan-2017 Combo OJVM PSU 11.2.0.4.170117 and GI PSU 11.2.0.4.170117 Patch 24918228
18-Oct-2016 Combo OJVM PSU 11.2.0.4.161018 and GI PSU 11.2.0.4.161018 Patch 24436346
19-Jul-2016 Combo OJVM PSU 11.2.0.4.160719 and GI PSU 11.2.0.4.160719 Patch 23615403
19-Apr-2016 Combo OJVM PSU 11.2.0.4.160419 and GI PSU 11.2.0.4.160419 Patch 22738793
19-Jan-2016 Combo OJVM PSU 11.2.0.4.160119 and GI PSU 11.2.0.4.160119 Patch 22378167
20-Oct-2015 Combo OJVM PSU 11.2.0.4.5 and GI PSU 11.2.0.4.8 Patch 21744348
14-Jul-2015 Combo OJVM PSU 11.2.0.4.4 and GI PSU 11.2.0.4.7 Patch 21150864
14-Apr-2015 Combo OJVM PSU 11.2.0.4.3 and GI PSU 11.2.0.4.6 Patch 20834621
20-Jan-2015 Combo OJVM PSU 11.2.0.4.2 and GI PSU 11.2.0.4.5 Patch 20132615
14-Oct-2014 Combo OJVM PSU 11.2.0.4.1 and GI PSU 11.2.0.4.4 Patch 19791420

参考:Database 11.2.0.4 Proactive Patch Information (Doc ID 2285559.1)

Oracle 19c/21c最新patch信息-202404

联系:手机/微信(+86 17813235971) QQ(107644445)QQ咨询惜分飞

标题:Oracle 19c/21c最新patch信息-202404

作者:惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]

 

21.0.0.0
 Description  Database Update  GI Update  Windows Bundle Patch
  APR2024 (21.14.0.0.0) 36352352  36352207  36219877
  JAN2024 (21.13.0.0.0) 36041222  36031790  35962857
  OCT2023 (21.12.0.0.0) 35740258  35738010  35681617
  JUL2023  (21.11.0.0.0) 35428978  35427907  35347974
  APR2023 (21.10.0.0.0) 35134934  35132566  35046488
  JAN2023 (21.9.0.0.0) 34839741  34838415  34750812
  Oct2022 (21.8.0.0.0) 34527084  34526142  34468137
  JUL2022 (21.7.0.0.0) 34160444  34155589  34110698
  APR2022 (21.6.0.0.0) 33843745  33859395  33829143
  JAN2022 (21.5.0.0.0) 33516412  33531909  33589769
 OCT2021 (21.4.0.0.0) 33239276  33250101  NA

 

19.0.0.0
 Description  Database Update  GI Update  Windows Bundle Patch
 APR2024 (19.23.0.0.0) 36233263  36233126  36219938
 JAN2024 (19.22.0.0.0) 35943157  35940989  35962832
 OCT2023 (19.21.0.0.0) 35643107  35642822  35681552
 JUL2023 (19.20.0.0.0) 35320081  35319490  35348034
 APR2023 (19.19.0.0.0) 35042068  35037840  35046439
 JAN2023 (19.18.0.0.0) 34765931  34762026  34750795
 Oct2022 (19.17.0.0.0) 34419443  34416665  34468114
 JUL2022 (19.16.0.0.0) 34133642  34130714  34110685
 APR2022 (19.15.0.0.0) 33806152  33803476  33829175
 JAN2022 (19.14.0.0.0) 33515361  33509923  33575656
 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

 

 

19.0.0.0
 Description  OJVM Update  OJVM + DB Update  OJVM + GI Update
 APR2024 (19.23.0.0.240416)  36199232  36209492  36209493
 JAN2024 (19.22.0.0.240116)  35926646  36031426  36031453
 OCT2023 (19.21.0.0.231017)  35648110  35742413  35742441
 JUL2023 (19.20.0.0.230718)  35354406  35370174  35370167
 APR2023 (19.19.0.0.230418)  35050341  35058163  35058172
 JAN2023 (19.18.0.0.230117)  34786990  34773489  34773504
 OCT2022 (19.17.0.0.221018)  34411846  34449114  34449117
 JUL2022 (19.16.0.0.220719)  34086870  34160831  34160854
 APR2022 (19.15.0.0.220419)  33808367  33859194  33859214
 JAN2022 (19.14.0.0.220118)  33561310  33567270  33567274
 OCT2021 (19.13.0.0.211019)  33192694  33248420  33248471
 JUL2021 (19.12.0.0.210720)  32876380  32900021  32900083
 APR2021 (19.11.0.0.210420)  32399816  32578972  32578973
 JAN2021 (19.10.0.0.210119)  32067171  32126828  32126842
 OCT2020 (19.9.0.0.201020)  31668882  31720396  31720429
 JUL2020 (19.8.0.0.200714)  31219897  31326362  31326369
 APR2020 (19.7.0.0.200414)  30805684  30783543  30783556
 JAN2020 (19.6.0.0.200114)  30484981  30463595  30463609
 OCT2019 (19.5.0.0.191015)  30128191  30133124  30133178
 JUL2019 (19.4.0.0.190716)  29774421  29699079  29699097
 APR2019 (19.3.0.0.190416)  29548437  29621253  29621299

参考:Assistant: Download Reference for Oracle Database/GI Update, Revision, PSU, SPU(CPU), Bundle Patches, Patchsets and Base Releases (Doc ID 2118136.2)

Oracle 19c/21c最新patch信息-202401

联系:手机/微信(+86 17813235971) QQ(107644445)QQ咨询惜分飞

标题:Oracle 19c/21c最新patch信息-202401

作者:惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]

2024年1月份,19c和21c最新patch信息

21.0.0.0
 Description  Database Update  GI Update  Windows Bundle Patch
  JAN2024 (21.13.0.0.0) 36041222  36031790  35962857
  OCT2023 (21.12.0.0.0) 35740258  35738010  35681617
  JUL2023  (21.11.0.0.0) 35428978  35427907  35347974
  APR2023 (21.10.0.0.0) 35134934  35132566  35046488
  JAN2023 (21.9.0.0.0) 34839741  34838415  34750812
  Oct2022 (21.8.0.0.0) 34527084  34526142  34468137
  JUL2022 (21.7.0.0.0) 34160444  34155589  34110698
  APR2022 (21.6.0.0.0) 33843745  33859395  33829143
  JAN2022 (21.5.0.0.0) 33516412  33531909  33589769
 OCT2021 (21.4.0.0.0) 33239276  33250101  NA
19.0.0.0
 Description  Database Update  GI Update  Windows Bundle Patch
 JAN2024 (19.22.0.0.0) 35943157  35940989  35962832
 OCT2023 (19.21.0.0.0) 35643107  35642822  35681552
 JUL2023 (19.20.0.0.0) 35320081  35319490  35348034
 APR2023 (19.19.0.0.0) 35042068  35037840  35046439
 JAN2023 (19.18.0.0.0) 34765931  34762026  34750795
 Oct2022 (19.17.0.0.0) 34419443  34416665  34468114
 JUL2022 (19.16.0.0.0) 34133642  34130714  34110685
 APR2022 (19.15.0.0.0) 33806152  33803476  33829175
 JAN2022 (19.14.0.0.0) 33515361  33509923  33575656
 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

 

 

19.0.0.0
 Description  OJVM Update  OJVM + DB Update  OJVM + GI Update
 JAN2024 (19.22.0.0.240116)  35926646  36031426  36031453
 OCT2023 (19.21.0.0.231017)  35648110  35742413  35742441
 JUL2023 (19.20.0.0.230718)  35354406  35370174  35370167
 APR2023 (19.19.0.0.230418)  35050341  35058163  35058172
 JAN2023 (19.18.0.0.230117)  34786990  34773489  34773504
 OCT2022 (19.17.0.0.221018)  34411846  34449114  34449117
 JUL2022 (19.16.0.0.220719)  34086870  34160831  34160854
 APR2022 (19.15.0.0.220419)  33808367  33859194  33859214
 JAN2022 (19.14.0.0.220118)  33561310  33567270  33567274
 OCT2021 (19.13.0.0.211019)  33192694  33248420  33248471
 JUL2021 (19.12.0.0.210720)  32876380  32900021  32900083
 APR2021 (19.11.0.0.210420)  32399816  32578972  32578973
 JAN2021 (19.10.0.0.210119)  32067171  32126828  32126842
 OCT2020 (19.9.0.0.201020)  31668882  31720396  31720429
 JUL2020 (19.8.0.0.200714)  31219897  31326362  31326369
 APR2020 (19.7.0.0.200414)  30805684  30783543  30783556
 JAN2020 (19.6.0.0.200114)  30484981  30463595  30463609
 OCT2019 (19.5.0.0.191015)  30128191  30133124  30133178
 JUL2019 (19.4.0.0.190716)  29774421  29699079  29699097
 APR2019 (19.3.0.0.190416)  29548437  29621253  29621299

参考:Assistant: Download Reference for Oracle Database/GI Update, Revision, PSU, SPU(CPU), Bundle Patches, Patchsets and Base Releases (Doc ID 2118136.2)

数据库打patch建议设置nls_language为英文

联系:手机/微信(+86 17813235971) QQ(107644445)QQ咨询惜分飞

标题:数据库打patch建议设置nls_language为英文

作者:惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]

昨晚给客户11.2.0.4打比较新的psu和ojvm patch(主要为了修复安全扫描漏洞)
20231203185616


结果今天早上客户那边反馈应用有报ORA-29548错
ORA-29548

该错误比较明显应该是和java有关系,在本次变更中最大可能就是ojvm有关系,查看ojvm的postinstall.sql执行日志,发现如下问题

 34  -- Check the validity of JAVAVM and let the registry be updated accordingly.
 35  
 36      initjvmaux.validate_javavm;
 37  
 38  -- Add a row in registry$history to indicate this script was run.
 39  
 40      EXECUTE IMMEDIATE 'insert into registry$history
 41                         (action_time, action, namespace, version, id, comments)
 42                         values(SYSTIMESTAMP, ''jvmpsu.sql'', ''SERVER'',
 43                                ''11.2.0.4.221018OJVMPSU'', 0, ''RAN jvmpsu.sql'')';
 44  
 45    END IF;
 46  
 47    EXECUTE IMMEDIATE 'alter system set java_jit_enabled = ' || :jitstate;
 48  
 49  END;
 50  /
BEGIN
*
第 1 行出现错误:
ORA-01843: 无效的月份
ORA-06512: 在 line 8

查询组件有效性

SQL> select comp_name,version,status from dba_registry order by 1;

COMP_NAME
--------------------------------------------------------------------------------
VERSION                        STATUS
------------------------------ ----------------------
JServer JAVA Virtual Machine
11.2.0.4.0                     INVALID

OLAP Analytic Workspace
11.2.0.4.0                     VALID

OLAP Catalog
11.2.0.4.0                     VALID


COMP_NAME
--------------------------------------------------------------------------------
VERSION                        STATUS
------------------------------ ----------------------
OWB
11.2.0.1.0                     VALID

Oracle Application Express
3.2.1.00.10                    VALID

Oracle Database Catalog Views
11.2.0.4.0                     VALID


COMP_NAME
--------------------------------------------------------------------------------
VERSION                        STATUS
------------------------------ ----------------------
Oracle Database Java Packages
11.2.0.4.0                     VALID

Oracle Database Packages and Types
11.2.0.4.0                     VALID

Oracle Enterprise Manager
11.2.0.4.0                     VALID


COMP_NAME
--------------------------------------------------------------------------------
VERSION                        STATUS
------------------------------ ----------------------
Oracle Expression Filter
11.2.0.4.0                     VALID

Oracle Multimedia
11.2.0.4.0                     VALID

Oracle OLAP API
11.2.0.4.0                     VALID


COMP_NAME
--------------------------------------------------------------------------------
VERSION                        STATUS
------------------------------ ----------------------
Oracle Rules Manager
11.2.0.4.0                     VALID

Oracle Text
11.2.0.4.0                     VALID

Oracle Workspace Manager
11.2.0.4.0                     VALID


COMP_NAME
--------------------------------------------------------------------------------
VERSION                        STATUS
------------------------------ ----------------------
Oracle XDK
11.2.0.4.0                     VALID

Oracle XML Database
11.2.0.4.0                     VALID

Spatial
11.2.0.4.0                     VALID


已选择18行。

确认JServer JAVA Virtual Machine组件无效,很可能是ojvm的postinstall.sql执行失败有关系,而引起这个失败的原因是由于“ORA-01843: 无效的月份”,根据经验,引起这个问题的可能是由于win汉语环境中日期/时间的显示格式导致

SQL> select sysdate from dual;

SYSDATE
--------------
03-12月-23

设置为英文格式显示

SQL> alter session set nls_language='American';

Session altered.

SQL> select sysdate from dual;

SYSDATE
------------
03-DEC-23

重新执行postdeinstall和postinstall脚本之后,组件状态恢复正常,软件功能也恢复正常

SQL> select comp_name,version,status from dba_registry order by 1;

JServer JAVA Virtual Machine
11.2.0.4.0                     VALID

OLAP Analytic Workspace
11.2.0.4.0                     VALID

OLAP Catalog
11.2.0.4.0                     VALID

OWB
11.2.0.1.0                     VALID

Oracle Application Express
3.2.1.00.10                    VALID

Oracle Database Catalog Views
11.2.0.4.0                     VALID

Oracle Database Java Packages
11.2.0.4.0                     VALID

Oracle Database Packages and Types
11.2.0.4.0                     VALID

Oracle Enterprise Manager
11.2.0.4.0                     VALID

Oracle Expression Filter
11.2.0.4.0                     VALID

Oracle Multimedia
11.2.0.4.0                     VALID

Oracle OLAP API
11.2.0.4.0                     VALID

Oracle Rules Manager
11.2.0.4.0                     VALID

Oracle Text
11.2.0.4.0                     VALID

Oracle Workspace Manager
11.2.0.4.0                     VALID

Oracle XDK
11.2.0.4.0                     VALID

Oracle XML Database
11.2.0.4.0                     VALID

Spatial
11.2.0.4.0                     VALID


18 rows selected.

自此提醒由于oracle 环境语言默认显示的问题导致某些patch不能正常打成功,建议在执行数据库patch或者升级之时,把数据库语言环境调整为英文nls_language=’American’,以避免本次出现的不必要的麻烦(以前由于大部分客户没有是使用jvm这个功能组件因此没有暴露该问题)

Assistant: Download Reference for Oracle Database/GI PSU, SPU(CPU), Bundle Patches, Patchsets and Base Releases-202307

联系:手机/微信(+86 17813235971) QQ(107644445)QQ咨询惜分飞

标题:Assistant: Download Reference for Oracle Database/GI PSU, SPU(CPU), Bundle Patches, Patchsets and Base Releases-202307

作者:惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]

由于19c之前版本的patch,oracle在标准补丁中,已经不再提供,这里主要列举19c/21c相关主要patch

 

21.0.0.0 RUs
 Description  Database Update  GI Update  Windows Bundle Patch
  JUL2023  (21.11.0.0.0) 35428978  35427907  35347974
  APR2023 (21.10.0.0.0) 35134934  35132566  35046488
  JAN2023 (21.9.0.0.0) 34839741  34838415  34750812
  Oct2022 (21.8.0.0.0) 34527084  34526142  34468137
  JUL2022 (21.7.0.0.0) 34160444  34155589  34110698
  APR2022 (21.6.0.0.0) 33843745  33859395  33829143
  JAN2022 (21.5.0.0.0) 33516412  33531909  33589769
 OCT2021 (21.4.0.0.0) 33239276  33250101  NA

 

19.0.0.0 RUs
 Description  Database Update  GI Update  Windows Bundle Patch
 JUL2023 (19.20.0.0.0) 35320081  35332145  35348034
 APR2023 (19.19.0.0.0) 35042068  35037840  35046439
 JAN2023 (19.18.0.0.0) 34765931  34762026  34750795
 Oct2022 (19.17.0.0.0) 34419443  34416665  34468114
 JUL2022 (19.16.0.0.0) 34133642  34130714  34110685
 APR2022 (19.15.0.0.0) 33806152  33803476  33829175
 JAN2022 (19.14.0.0.0) 33515361  33509923  33575656
 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

 

19.0.0.0 OJVM
 Description  OJVM Update  OJVM + DB Update  OJVM + GI Update
 JUL2023 (19.20.0.0.230718)  35354406  35370174  35370167
 APR2023 (19.19.0.0.230418)  35050341  35058163  35058172
 JAN2023 (19.18.0.0.230117)  34786990  34773489  34773504
 OCT2022 (19.17.0.0.221018)  34411846  34449114  34449117
 JUL2022 (19.16.0.0.220719)  34086870  34160831  34160854
 APR2022 (19.15.0.0.220419)  33808367  33859194  33859214
 JAN2022 (19.14.0.0.220118)  33561310  33567270  33567274
 OCT2021 (19.13.0.0.211019)  33192694  33248420  33248471
 JUL2021 (19.12.0.0.210720)  32876380  32900021  32900083
 APR2021 (19.11.0.0.210420)  32399816  32578972  32578973
 JAN2021 (19.10.0.0.210119)  32067171  32126828  32126842
 OCT2020 (19.9.0.0.201020)  31668882  31720396  31720429
 JUL2020 (19.8.0.0.200714)  31219897  31326362  31326369
 APR2020 (19.7.0.0.200414)  30805684  30783543  30783556
 JAN2020 (19.6.0.0.200114)  30484981  30463595  30463609
 OCT2019 (19.5.0.0.191015)  30128191  30133124  30133178
 JUL2019 (19.4.0.0.190716)  29774421  29699079  29699097
 APR2019 (19.3.0.0.190416)  29548437  29621253  29621299

 

 

19.0.0.0 MRPs
 Description  DBMRP  GIMRP
 19.19.0.0.230718 35573556 35573568
 19.18.0.0.230620 35449858 35449877
 19.18.0.0.230516 35333818 35333842

 

 

19.18.0.0 MRPs
 Description  DBMRP  GIMRP
 19.18.0.0.230718 35573556 35573568
 19.18.0.0.230620 35449858 35449877
 19.18.0.0.230516 35333818 35333842

参考:Assistant: Download Reference for Oracle Database/GI Update, Revision, PSU, SPU(CPU), Bundle Patches, Patchsets and Base Releases (Doc ID 2118136.2)

ARM Linux(麒麟操作系统)安装Oracle数据库

联系:手机/微信(+86 17813235971) QQ(107644445)QQ咨询惜分飞

标题:ARM Linux(麒麟操作系统)安装Oracle数据库

作者:惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]

Oracle在6月底发布了支持ARM cpu的oracle数据库版本19.9,下载页面,选择Oracle Database 19c for LINUX ARM (aarch64)
oracle-arm


安装技术文档参考:database-installation-guide-linux,其中描述目前for arm版本oracle只是认证了操作系统oracle linux(for arm) 8.6+
arm-liunx

在信创平台中没有oracle linux选项,为了让oracle数据库尽可能的运行在信创的硬件和系统上,我选择的麒麟V10版本进行测试安装测试(该版本未被oracle认证,仅供测试),在安装过程中遇到的几个主要坑分享下:
1. 执行runInstaller报错

[oracle@www.xifenfei.com db_1]$ ./runInstaller 
/u01/app/oracle/product/19c/db_1/perl/bin/perl: error while loading shared libraries: 
libnsl.so.1: cannot open shared object file: No such file or directory
[oracle@www.xifenfei.com db_1]$ perl -version

This is perl 5, version 28, subversion 3 (v5.28.3) built for aarch64-linux-thread-multi

Copyright 1987-2020, Larry Wall

Perl may be copied only under the terms of either the Artistic License or the
GNU General Public License, which may be found in the Perl 5 source kit.

Complete documentation for Perl, including FAQ lists, should be found on
this system using "man perl" or "perldoc perl".  If you have access to the
Internet, point your browser at http://www.perl.org/, the Perl Home Page.

这个是由于oracle自带的perl版本依赖包操作系统中不具备,对数据库软件中的perl进行降级即可
2. 安装图形化界面报PRVG-0282 : failed to retrieve the operating system distribution ID错误
PRVG-0282


由于在该版本的cvu_prereq.xml文件中只是写了oel支持,现在的操作系统是Kylin Linux Advanced Server,不在他的列表里面,因此提示该错误,解决方案参考:19.x:Database software installation failed with ” PRVG-0282 : failed to retrieve the operating system distribution ID ” (Doc ID 2894095.1),设置CV_ASSUME_DISTID解决该问题

3. 编译报错类似:
Error in invoking target ‘clean rat_on part_on dm_on olap_on sdo_on rac_off dnfs_off’
Error in invoking target ‘mkldflags ntcontab.o nnfgt.o’
通过查看日志发现是类似以下错误
ar

确认是由于缺少了/opt/rh/devtoolset-8/root/usr/bin/ar程序导致,对其进行安装然后重试编译(出现错误类似一个个分析处理)
经过上述一系列处理,数据库软件终于顺利安装
20230708211250

4. dbca无法正常启动,静默方式直接退出,选择命令方式创建库

--准备好pfile文件,启动库到nomount
CREATE DATABASE armdb
USER SYS IDENTIFIED BY oracle
USER SYSTEM IDENTIFIED BY oracle
LOGFILE GROUP 1 
('/u01/app/oracle/oradata/armdb/redo01a.log') SIZE 200M BLOCKSIZE 512,
GROUP 2 ('/u01/app/oracle/oradata/armdb/redo02a.log') SIZE 200M BLOCKSIZE 512,
GROUP 3 ('/u01/app/oracle/oradata/armdb/redo03a.log') SIZE 200M BLOCKSIZE 512
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 8192
CHARACTER SET AL32UTF8
NATIONAL CHARACTER SET AL16UTF16
EXTENT MANAGEMENT LOCAL
DATAFILE '/u01/app/oracle/oradata/armdb/system01.dbf'
SIZE 700M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
SYSAUX DATAFILE '/u01/app/oracle/oradata/armdb/sysaux01.dbf'
SIZE 550M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
DEFAULT TABLESPACE users
DATAFILE '/u01/app/oracle/oradata/armdb/users01.dbf'
SIZE 5M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE temp
TEMPFILE '/u01/app/oracle/oradata/armdb/temp01.dbf'
SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
UNDO TABLESPACE undotbs1
DATAFILE '/u01/app/oracle/oradata/armdb/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED;


--执行以下脚本
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql
@?/rdbms/admin/utlrp.sql
@?/sqlplus/admin/pupbld.sql

上述操作之后,在ARM平台的麒麟V10上安装oracle 数据库的事情基本上完成

[oracle@www.xifenfei.com ~]$ uname -a
Linux www.xifenfei.com.localdomain 4.19.90-24.4.v2101.ky10.aarch64 
#1 SMP Mon May 24 14:45:37 CST 2021 aarch64 aarch64 aarch64 GNU/Linux
[oracle@www.xifenfei.com ~]$ cat /etc/os-release 
NAME="Kylin Linux Advanced Server"
VERSION="V10 (Sword)"
ID="kylin"
VERSION_ID="V10"
PRETTY_NAME="Kylin Linux Advanced Server V10 (Sword)"
ANSI_COLOR="0;31"

[oracle@www.xifenfei.com ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sat Jul 8 23:46:42 2023
Version 19.19.0.0.0

Copyright (c) 1982, 2023, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.19.0.0.0

SQL> select name,created ,PLATFORM_NAME from v$database;

NAME      CREATED
--------- ------------------
PLATFORM_NAME
--------------------------------------------------------------------------------
ARMDB     08-JUL-23
Linux OS (AARCH64)

本次测试是基于Oracle官方没有认证的麒麟V10进行,如果希望安装的顺利一些,稳定一些,建议选择Oracle linux(for ARM)8.6+版本

12.1.0.2最新patch信息—202304

联系:手机/微信(+86 17813235971) QQ(107644445)QQ咨询惜分飞

标题:12.1.0.2最新patch信息—202304

作者:惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]

Database Patch Set Update (PSU)

Release Date Version Download link Included in Windows Bundle
18-Apr-2023 12.1.0.2.230418 (Apr 2023) Database Patch Set Update (DB PSU) Patch 34998358 NA – out of error correction
17-Jan-2023 12.1.0.2.230117 (Jan 2023) Database Patch Set Update (DB PSU) Patch 34677720 NA – out of error correction
18-Oct-2022 12.1.0.2.221018 (Oct 2022) Database Patch Set Update (DB PSU) Patch 34386266 NA – out of error correction
19-Jul-2022 12.1.0.2.220719 (Jul 2022) Database Patch Set Update (DB PSU) Patch 34057742 12.1.0.2.220719 WIN DB BP Patch 33883271
19-Apr-2022 12.1.0.2.220419 (Apr 2022) Database Patch Set Update (DB PSU) Patch 33711081 12.1.0.2.220419 WIN DB BP Patch 33777450
18-Jan-2022 12.1.0.2.220118 (Jan 2022) Database Patch Set Update (DB PSU) Patch 33477199 12.1.0.2.220118 WIN DB BP Patch 33492893
19-Oct-2021 12.1.0.2.211019 (Oct 2021) Database Patch Set Update (DB PSU) Patch 33128590 12.1.0.2.211019 WIN DB BP Patch 33174365
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
15-Oct-2019 12.1.0.2.191015 (Oct 2019) Database Patch Set Update (DB PSU) Patch 29918340 12.1.0.2.191015 WIN DB BP Patch 30049606
16-Jul-2019 12.1.0.2.190716 (Jul 2019) Database Patch Set Update (DB PSU) Patch 29494060 12.1.0.2.190716 WIN DB BP Patch 29831650
16-Apr-2019 12.1.0.2.190416 (Apr 2019) Database Patch Set Update (DB PSU) Patch 29141015 12.1.0.2.190416 WIN DB BP Patch 29413116
15-Jan-2019 12.1.0.2.190115 (Jan 2019) Database Patch Set Update (DB PSU) Patch 28729169 12.1.0.2.190115 WIN DB BP Patch 28810679
16-Oct-2018 12.1.0.2.181016 (Oct 2018) Database Patch Set Update (DB PSU) Patch 28259833 12.1.0.2.181016 WIN DB BP Patch 28563501
17-Jul-2018 12.1.0.2.180717 (Jul 2018) Database Patch Set Update (DB PSU) Patch 27547329 12.1.0.2.180717 WIN DB BP Patch 27937907
17-Apr-2018 12.1.0.2.180417 (Apr 2018) Database Patch Set Update (DB PSU) Patch 27338041 12.1.0.2.180417 WIN DB BP Patch 27440294
16-Jan-2018 12.1.0.2.180116 (Jan 2018) Database Patch Set Update (DB PSU) Patch 26925311 12.1.0.2.180116 WIN DB BP Patch 27162953
17-Oct-2017 12.1.0.2.171017 (Oct 2017) Database Patch Set Update (DB PSU) Patch 26713565 12.1.0.2.171017 WIN DB BP Patch 26720785
14-Aug-2017 12.1.0.2.170814 (Jul 2017) Database Patch Set Update (DB PSU) Patch 26609783 12.1.0.2.170814 WIN DB BP Patch 26161726
18-Jul-2017 12.1.0.2.170718 (Jul 2017) Database Patch Set Update (DB PSU) Patch 25755742 12.1.0.2.170718 WIN DB BP Patch 26161724
18-Apr-2017 12.1.0.2.170418 (Apr 2017) Database Patch Set Update (DB PSU) Patch 25171037 12.1.0.2.170418 WIN DB BP Patch 25632533
17-Jan-2017 12.1.0.2.170117 (Jan 2017) Database Patch Set Update (DB PSU) Patch 24732082 12.1.0.2.170117 WIN DB BP Patch 25115951
18-Oct-2016 12.1.0.2.161018 (Oct 2016) Database Patch Set Update (DB PSU) Patch 24006101 12.1.0.2.161018 WIN DB BP Patch 24591642
19-Jul-2016 12.1.0.2.160719 (Jul 2016) Database Patch Set Update (DB PSU) Patch 23054246 12.1.0.2.160719 WIN DB BP Patch 23530387
19-Apr-2016 12.1.0.2.160419 (Apr 2016) Database Patch Set Update (DB PSU) Patch 22291127 12.1.0.2.160419 WIN DB BP Patch 22809813
19-Jan-2016 12.1.0.2.160119 (Jan 2016) Database Patch Set Update (DB PSU) Patch 21948354 12.1.0.2.160119 WIN DB BP Patch 22310559
20-Oct-2015 12.1.0.2.5 (Oct 2015) Database Patch Set Update (DB PSU) Patch 21359755 12.1.0.2 Patch 10 Patch 21821214
14-Jul-2015 12.1.0.2.4 (Jul 2015) Database Patch Set Update (DB PSU) Patch 20831110 12.1.0.2 Patch 7 Patch 21126814
14-Apr-2015 12.1.0.2.3 (Apr 2015) Database Patch Set Update (DB PSU) Patch 20299023 12.1.0.2 Patch 4 Patch 20684004
20-Jan-2015 12.1.0.2.2 (Jan 2015) Database Patch Set Update (DB PSU) Patch 19769480 12.1.0.2 Patch 1 Patch 19720843
14-Oct-2014 12.1.0.2.1 (Oct 2014) Database Patch Set Update (DB PSU) Patch 19303936 none

Grid Infrastructure Patch Set Update (PSU)

Release Date Version Download link
18-Apr-2023 12.1.0.2.230418 (Apr 2023) Grid Infrastructure Patch Set Update (GI PSU) Patch 35058268
17-Jan-2023 12.1.0.2.230117 (Jan 2023) Grid Infrastructure Patch Set Update (GI PSU) Patch 34774519
18-Oct-2022 12.1.0.2.221018 (Oct 2022) Grid Infrastructure Patch Set Update (GI PSU) Patch 34535560
19-Jul-2022 12.1.0.2.220719 (Jul 2022) Grid Infrastructure Patch Set Update (GI PSU) Patch 34204576
19-Apr-2022 12.1.0.2.220419 (Apr 2022) Grid Infrastructure Patch Set Update (GI PSU) Patch 33829718
18-Jan-2022 12.1.0.2.220118 (Jan 2022) Grid Infrastructure Patch Set Update (GI PSU) Patch 33575274
19-Oct-2021 12.1.0.2.211019 (Oct 2021) Grid Infrastructure Patch Set Update (GI PSU) Patch 33248367
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
15-Oct-2019 12.1.0.2.191015 (Oct 2019) Grid Infrastructure Patch Set Update (GI PSU) Patch 30070257
16-Jul-2019 12.1.0.2.190716 (Jul 2019) Grid Infrastructure Patch Set Update (GI PSU) Patch 29698592
16-Apr-2019 12.1.0.2.190416 (Apr 2019) Grid Infrastructure Patch Set Update (GI PSU) Patch 29176115
15-Jan-2019 12.1.0.2.190115 (Jan 2019) Grid Infrastructure Patch Set Update (GI PSU) Patch 28813884
16-Oct-2018 12.1.0.2.181016 (Oct 2018) Grid Infrastructure Patch Set Update (GI PSU) Patch 28349311
17-Jul-2018 12.1.0.2.180717 (Jul 2018) Grid Infrastructure Patch Set Update (GI PSU) Patch 27967747
17-Apr-2018 12.1.0.2.180417 (Apr 2018) Grid Infrastructure Patch Set Update (GI PSU) Patch 27468957
16-Jan-2018 12.1.0.2.180116 (Jan 2018) Grid Infrastructure Patch Set Update (GI PSU) Patch 27010872
17-Oct-2017 12.1.0.2.171017 (Oct 2017) Grid Infrastructure Patch Set Update (GI PSU) Patch 26635815
14-Aug-2017 12.1.0.2.170814 (Jul 2017) Grid Infrastructure Patch Set Update (GI PSU) Patch 26610308
18-Jul-2017 12.1.0.2.170718 (Jul 2017) Grid Infrastructure Patch Set Update (GI PSU) Patch 25901062
18-Apr-2017 12.1.0.2.170418 (Apr 2017) Grid Infrastructure Patch Set Update (GI PSU) Patch 25434003
17-Jan-2017 12.1.0.2.170117 (Jan 2017) Grid Infrastructure Patch Set Update (GI PSU) Patch 24917825
18-Oct-2016 12.1.0.2.161018 (Oct 2016) Grid Infrastructure Patch Set Update (GI PSU) Patch 24412235
19-Jul-2016 12.1.0.2.160719 (Jul 2016) Grid Infrastructure Patch Set Update (GI PSU) Patch 23273629
19-Apr-2016 12.1.0.2.160419 (Apr 2016) Grid Infrastructure Patch Set Update (GI PSU) Patch 22646084
19-Jan-2016 12.1.0.2.160119 (Jan 2016) Grid Infrastructure Patch Set Update (GI PSU) Patch 22191349
20-Oct-2015 12.1.0.2.5 (Oct 2015) Grid Infrastructure Patch Set Update (GI PSU) Patch 21523234
14-Jul-2015 12.1.0.2.4 (Jul 2015) Grid Infrastructure Patch Set Update (GI PSU) Patch 20996835
14-Apr-2015 12.1.0.2.3 (Apr 2015) Grid Infrastructure Patch Set Update (GI PSU) Patch 20485724
20-Jan-2015 12.1.0.2.2 (Jan 2015) Grid Infrastructure Patch Set Update (GI PSU) Patch 19954978
14-Oct-2014 12.1.0.2.1 (Oct 2014) Grid Infrastructure Patch Set Update (GI PSU) Patch 19392646

OJVM Component Patch Set Update (PSU)

Release Date Version Unix PSU Patch Windows Bundle Patch
18-Apr-2023 12.1.0.2.230418 (Apr 2023) OJVM Component Patch Set Update Patch 35077439 NA – out of error correction
17-Jan-2023 12.1.0.2.230117 (Jan 2023) OJVM Component Patch Set Update Patch 34763317 NA – out of error correction
18-Oct-2022 12.1.0.2.221018 (Oct 2022) OJVM Component Patch Set Update Patch 34412250 NA – out of error correction
19-Jul-2022 12.1.0.2.220719 (Jul 2022) OJVM Component Patch Set Update Patch 34086863 Patch 34185253
19-Apr-2022 12.1.0.2.220419 (Apr 2022) OJVM Component Patch Set Update Patch 33808385 Patch 33881387
18-Jan-2022 12.1.0.2.220118 (Jan 2022) OJVM Component Patch Set Update Patch 33561268 Patch 33577533
19-Oct-2021 12.1.0.2.211019 (Oct 2021) OJVM Component Patch Set Update Patch 33192628 Patch 33248785
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
15-Oct-2019 12.1.0.2.191015 (Oct 2019) OJVM Component Patch Set Update Patch 30128197 Patch 30268189
16-Jul-2019 12.1.0.2.190716 (Jul 2019) OJVM Component Patch Set Update Patch 29774383 Patch 29837393
16-Apr-2019 12.1.0.2.190416 (Apr 2019) OJVM Component Patch Set Update Patch 29251241 Patch 29447962
15-Jan-2019 12.1.0.2.190115 (Jan 2019) OJVM Component Patch Set Update Patch 28790654 Patch 28994063
16-Oct-2018 12.1.0.2.181016 (Oct 2018) OJVM Component Patch Set Update Patch 28440711 Patch 28412299
17-Jul-2018 12.1.0.2.180717 (Jul 2018) OJVM Component Patch Set Update Patch 27923320 Patch 28135126
17-Apr-2018 12.1.0.2.180417 (Apr 2018) OJVM Component Patch Set Update Patch 27475603 Patch 27440294
16-Jan-2018 12.1.0.2.180116 (Jan 2018) OJVM Component Patch Set Update Patch 27001733 Patch 27001733
17-Oct-2017 12.1.0.2.171017 (Oct 2017) OJVM Component Patch Set Update Patch 26635845 Patch 26792364
18-Jul-2017 12.1.0.2.170718 (Jul 2017) OJVM Component Patch Set Update Patch 26027162 Patch 26182439
18-Apr-2017 12.1.0.2.170418 (Apr 2017) OJVM Component Patch Set Update Patch 25437695 Patch 25590993
17-Jan-2017 12.1.0.2.170117 (Jan 2017) OJVM Component Patch Set Update Patch 24917972 Patch 25112498
18-Oct-2016 12.1.0.2.161018 (Oct 2016) OJVM Component Patch Set Update Patch 24315824 Patch 24591630
19-Jul-2016 12.1.0.2.160719 (Jul 2016) OJVM Component Patch Set Update Patch 23177536 Patch 23515290
19-Apr-2016 12.1.0.2.160419 (Apr 2016) OJVM Component Patch Set Update Patch 22674709 Patch 22839633
19-Jan-2016 12.1.0.2.160119 (Jan 2016) OJVM Component Patch Set Update Patch 22139226 Patch 22311086
20-Oct-2015 12.1.0.2.5 (Oct 2015) OJVM Component Patch Set Update Patch 21555660 Patch 21788394
14-Jul-2015 12.1.0.2.4 (Jul 2015) OJVM Component Patch Set Update Patch 21068507 Patch 21153530
14-Apr-2015 12.1.0.2.3 (Apr 2015) OJVM Component Patch Set Update Patch 20415564 Patch 20391199
20-Jan-2015 12.1.0.2.2 (Jan 2015) OJVM Component Patch Set Update Patch 19877336 Patch 20225938
14-Oct-2014 12.1.0.2.1 (Oct 2014) OJVM Component Patch Set Update Patch 19282028 -

参考:Database 12.1.0.2 Proactive Patch Information (Doc ID 2285558.1)

11.2.0.4最新patch信息—202304

联系:手机/微信(+86 17813235971) QQ(107644445)QQ咨询惜分飞

标题:11.2.0.4最新patch信息—202304

作者:惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]

Database Patch Set Update

Release Date Version Download link Included in Windows Bundle
18-Apr-2023 11.2.0.4.230418 (Apr 2023) Database Patch Set Update (DB PSU) Patch 34998337 * Out of Error Correction
17-Jan-2023 11.2.0.4.230117 (Jan 2023) Database Patch Set Update (DB PSU) Patch 34677698 * Out of Error Correction
18-Oct-2022 11.2.0.4.221018 (Oct 2022) Database Patch Set Update (DB PSU) Patch 34386237 Patch 34474433
19-Jul-2022 11.2.0.4.220719 (Jul 2022) Database Patch Set Update (DB PSU) Patch 34057724 Patch 33883353
19-Apr-2022 11.2.0.4.220419 (Apr 2022) Database Patch Set Update (DB PSU) Patch 33711103 Patch 33776715
18-Jan-2022 11.2.0.4.220118 (Jan 2022) Database Patch Set Update (DB PSU) Patch 33477185 Patch 33488457
19-Oct-2021 11.2.0.4.211019 (Oct 2021) Database Patch Set Update (DB PSU) Patch 33128584 Patch 33174351
20-Jul-2021 11.2.0.4.210720 (Jul 2021) Database Patch Set Update (DB PSU) Patch 32758711 Patch 32775108
20-Apr-2021 11.2.0.4.210420 (Apr 2021) Database Patch Set Update (DB PSU) Patch 32328626 Patch 32392141
19-Jan-2021 11.2.0.4.210119 (Jan 2021) Database Patch Set Update (DB PSU) Patch 31983472 Patch 32003403
20-Oct-2020 11.2.0.4.201020 (Oct 2020) Database Patch Set Update (DB PSU) Patch 31537677 Patch 31659823
14-Jul-2020 11.2.0.4.200714 (Jul 2020) Database Patch Set Update (DB PSU) Patch 31103343 Patch 31169916
14-Apr-2020 11.2.0.4.200414 (Apr 2020) Database Patch Set Update (DB PSU) Patch 30670774 Patch 31169916
14-Jan-2020 11.2.0.4.200114 (Jan 2020) Database Patch Set Update (DB PSU) Patch 30298532 Patch 30502376
15-Oct-2019 11.2.0.4.191015 (Oct 2019) Database Patch Set Update (DB PSU) Patch 29913194 Patch 30151661
16-Jul-2019 11.2.0.4.190716 (Jul 2019) Database Patch Set Update (DB PSU) Patch 29497421 Patch 29596609
16-Apr-2019 11.2.0.4.190416 (Apr 2019) Database Patch Set Update (DB PSU) Patch 29141056 Patch 29218820
15-Jan-2019 11.2.0.4.190115 (Jan 2019) Database Patch Set Update (DB PSU) Patch 28729262 Patch 28761877
16-Oct-2018 11.2.0.4.181016 (Oct 2018) Database Patch Set Update (DB PSU) Patch 28204707 Patch 28265827
17-Jul-2018 11.2.0.4.180717 (Jul 2018) Database Patch Set Update (DB PSU) Patch 27734982 Patch 27695940
17-Apr-2018 11.2.0.4.180417 (Apr 2018) Database Patch Set Update (DB PSU) Patch 27338049 Patch 27426753
16-Jan-2018 11.2.0.4.180116 (Jan 2018) Database Patch Set Update (DB PSU) Patch 26925576 Patch 26925576
17-Oct-2017 11.2.0.4.171017 (Oct 2017) Database Patch Set Update (DB PSU) Patch 26392168 Patch 26581376
14-Aug-2017 11.2.0.4.170814 (Jul 2017) Database Patch Set Update (DB PSU) Patch 26609445 Patch 26194138
18-Jul-2017 11.2.0.4.170718 (Jul 2017) Database Patch Set Update (DB PSU) Patch 25869727 Patch 26194136
18-Apr-2017 11.2.0.4.170418 (Apr 2017) Database Patch Set Update (DB PSU) Patch 24732075 Patch 25632525
17-Jan-2017 **
18-Oct-2016 11.2.0.4.161018 (Oct 2016) Database Patch Set Update (DB PSU) Patch 24006111 Patch 24591646
19-Jul-2016 11.2.0.4.160719 (Jul 2016) Database Patch Set Update (DB PSU) Patch 23054359 Patch 23530402
19-Apr-2016 11.2.0.4.160419 (Apr 2016) Database Patch Set Update (DB PSU) Patch 22502456 Patch 22839608
19-Jan-2016 11.2.0.4.160119 (Jan 2016) Database Patch Set Update (DB PSU) Patch 21948347 Patch 22310544
20-Oct-2015 11.2.0.4.8 (Oct 2015) Database Patch Set Update (DB PSU) Patch 21352635 Patch 21821802
14-Jul-2015 11.2.0.4.7 (Jul 2015) Database Patch Set Update (DB PSU) Patch 20760982 Patch 20833831
14-Apr-2015 11.2.0.4.6 (Apr 2015) Database Patch Set Update (DB PSU) Patch 20299013 Patch 20544696
20-Jan-2015 11.2.0.4.5 (Jan 2015) Database Patch Set Update (DB PSU) Patch 19769489 Patch 20127071
14-Oct-2014 11.2.0.4.4 (Oct 2014) Database Patch Set Update (DB PSU) Patch 19121551 Patch 19651773
14-Jul-2014 11.2.0.4.3 (Jul 2014) Database Patch Set Update (DB PSU) Patch 18522509 Patch 18842982
15-Apr-2014 11.2.0.4.2 (Apr 2014) Database Patch Set Update (PSU) Patch 18031668 Patch 18296644
15-Jan-2014 11.2.0.4.1 (Jan 2014) Database Patch Set Update (PSU) Patch 17478514 Patch 17987366

Grid Infrastructure Patch Set Update

Release Date Version Download link
18-Apr-2023 11.2.0.4.230418 (Apr 2023) Grid Infrastructure Patch Set Update (GI PSU) Patch 35058300
17-Jan-2023 11.2.0.4.230117 (Jan 2023) Grid Infrastructure Patch Set Update (GI PSU) Patch 34774506
18-Oct-2022 11.2.0.4.221018 (Oct 2022) Grid Infrastructure Patch Set Update (GI PSU) Patch 34536853
19-Jul-2022 11.2.0.4.220719 (Jul 2022) Grid Infrastructure Patch Set Update (GI PSU) Patch 34204533
19-Apr-2022 11.2.0.4.220419 (Apr 2022) Grid Infrastructure Patch Set Update (GI PSU) Patch 33829709
18-Jan-2022 11.2.0.4.220118 (Jan 2022) Grid Infrastructure Patch Set Update (GI PSU) Patch 33575261
19-Oct-2021 11.2.0.4.211019 (Oct 2021) Grid Infrastructure Patch Set Update (GI PSU) Patch 33248354
20-Jul-2021 11.2.0.4.210720 (Jul 2021) Grid Infrastructure Patch Set Update (GI PSU) Patch 32917428
20-Apr-2021 11.2.0.4.210420 (Apr 2021) Grid Infrastructure Patch Set Update (GI PSU) Patch 32495145
19-Jan-2021 11.2.0.4.210119 (Jan 2021) Grid Infrastructure Patch Set Update (GI PSU) Patch 32131250
20-Oct-2020 11.2.0.4.201020 (Oct 2020) Grid Infrastructure Patch Set Update (GI PSU) Patch 31718723
14-Jul-2020 11.2.0.4.200714 (Jul 2020) Grid Infrastructure Patch Set Update (GI PSU) Patch 31305209
14-Apr-2020 11.2.0.4.200414 (Apr 2020) Grid Infrastructure Patch Set Update (GI PSU) Patch 30805461
14-Jan-2020 11.2.0.4.200114 (Jan 2020) Grid Infrastructure Patch Set Update (GI PSU) Patch 30501155
15-Oct-2019 11.2.0.4.191015 (Oct 2019) Grid Infrastructure Patch Set Update (GI PSU) Patch 30070097
16-Jul-2019 11.2.0.4.190716 (Jul 2019) Grid Infrastructure Patch Set Update (GI PSU) Patch 29698727
16-Apr-2019 11.2.0.4.190416 (Apr 2019) Grid Infrastructure Patch Set Update (GI PSU) Patch 29255947
15-Jan-2019 11.2.0.4.190115 (Jan 2019) Grid Infrastructure Patch Set Update (GI PSU) Patch 28813878
16-Oct-2018 11.2.0.4.181016 (Oct 2018) Grid Infrastructure Patch Set Update (GI PSU) Patch 28429134
17-Jul-2018 11.2.0.4.180717 (Jul 2018) Grid Infrastructure Patch Set Update (GI PSU) Patch 27967757
17-Apr-2018 11.2.0.4.180417 (Apr 2018) Grid Infrastructure Patch Set Update (GI PSU) Patch 27475913
16-Jan-2018 11.2.0.4.180116 (Jan 2018) Grid Infrastructure Patch Set Update (GI PSU) Patch 27107360
17-Oct-2017 11.2.0.4.171017 (Oct 2017) Grid Infrastructure Patch Set Update (GI PSU) Patch 26635745
14-Aug-2017 11.2.0.4.170814 (Jul 2017) Grid Infrastructure Patch Set Update (GI PSU) Patch 26610246
18-Jul-2017 11.2.0.4.170718 (Jul 2017) Grid Infrastructure Patch Set Update (GI PSU) Patch 26030799
18-Apr-2017 11.2.0.4.170418 (Apr 2017) Grid Infrastructure Patch Set Update (GI PSU) Patch 25476126
17-Jan-2017 **
18-Oct-2016 11.2.0.4.161018 (Oct 2016) Grid Infrastructure Patch Set Update (GI PSU) Patch 24436338
19-Jul-2016 11.2.0.4.160719 (Jul 2016) Grid Infrastructure Patch Set Update (GI PSU) Patch 23274134
19-Apr-2016 11.2.0.4.160419 (Apr 2016) Grid Infrastructure Patch Set Update (GI PSU) Patch 22646198
19-Jan-2016 11.2.0.4.160119 (Jan 2016) Grid Infrastructure Patch Set Update (GI PSU) Patch 22191577
20-Oct-2015 11.2.0.4.8 (Oct 2015) Grid Infrastructure Patch Set Update (GI PSU) Patch 21523375
14-Jul-2015 11.2.0.4.7 (Jul 2015) Grid Infrastructure Patch Set Update (GI PSU) Patch 20996923
14-Apr-2015 11.2.0.4.6 (Apr 2015) Grid Infrastructure Patch Set Update (GI PSU) Patch 20485808
20-Jan-2015 11.2.0.4.5 (Jan 2015) Grid Infrastructure Patch Set Update (GI PSU) Patch 19955028
14-Oct-2014 11.2.0.4.4 (Oct 2014) Grid Infrastructure Patch Set Update (GI PSU) Patch 19380115
15-Jul-2014 11.2.0.4.3 (Jul 2014) Grid Infrastructure Patch Set Update (GI PSU) Patch 18706472
15-Apr-2014 11.2.0.4.2 (Apr 2014) Grid Infrastructure Patch Set Update (GI PSU) Patch 18139609

11.2.0.4 OJVM Patch Set Update

Release Date Version Unix PSU Patch Windows Bundle Patch
18-Apr-2023 11.2.0.4.230418 (Apr 2023) OJVM Component Patch Set Update Patch 35039831 * Out of Error Correction
17-Jan-2023 11.2.0.4.230117 (Jan 2023) OJVM Component Patch Set Update Patch 34763334 * Out of Error Correction
18-Oct-2022 11.2.0.4.221018 (Oct 2022) OJVM Component Patch Set Update Patch 34412266 Patch 34513867
19-Jul-2022 11.2.0.4.220719 (Jul 2022) OJVM Component Patch Set Update Patch 34085652 Patch 34185082
19-Apr-2022 11.2.0.4.220419 (Apr 2022) OJVM Component Patch Set Update Patch 33829826 Patch 33881335
18-Jan-2022 11.2.0.4.220118 (Jan 2022) OJVM Component Patch Set Update Patch 33561250 Patch 33577510
19-Oct-2021 11.2.0.4.211019 (Oct 2021) OJVM Component Patch Set Update Patch 33192642 Patch 33248711
20-Jul-2021 11.2.0.4.210720 (Jul 2021) OJVM Component Patch Set Update Patch 32876451 Patch 32905855
20-Apr-2021 11.2.0.4.210420 (Apr 2021) OJVM Component Patch Set Update Patch 32671980 Patch 32428494
19-Jan-2021 11.2.0.4.210119 (Jan 2021) OJVM Component Patch Set Update ** Patch 32145687
20-Oct-2020 11.2.0.4.201020 (Oct 2020) OJVM Component Patch Set Update Patch 31668908 Patch 31740195
14-Jul-2020 11.2.0.4.200714 (Jul 2020) OJVM Component Patch Set Update Patch 31219953 Patch 31169916
14-Apr-2020 11.2.0.4.200414 (Apr 2020) OJVM Component Patch Set Update Patch 30805543 Patch 31169933
14-Jan-2020 11.2.0.4.200114 (Jan 2020) OJVM Component Patch Set Update Patch 30503372 Patch 30671044
15-Oct-2019 11.2.0.4.191015 (Oct 2019) OJVM Component Patch Set Update Patch 30132974 Patch 30268157
16-Jul-2019 11.2.0.4.190716 (Jul 2019) OJVM Component Patch Set Update Patch 29610422 Patch 30012911
16-Apr-2019 11.2.0.4.190416 (Apr 2019) OJVM Component Patch Set Update Patch 29251270 Patch 29447971
15-Jan-2019 11.2.0.4.190115 (Jan 2019) OJVM Component Patch Set Update Patch 28790660 Patch 28994059
16-Oct-2018 11.2.0.4.181016 (Oct 2018) OJVM Component Patch Set Update Patch 28440700 Patch 28412269
17-Jul-2018 11.2.0.4.180717 (Jul 2018) OJVM Component Patch Set Update Patch 27923163 Patch 28135121
17-Apr-2018 11.2.0.4.180417 (Apr 2018) OJVM Component Patch Set Update Patch 27475598 Patch 27381640
16-Jan-2018 11.2.0.4.180116 (Jan 2018) OJVM Component Patch Set Update Patch 26925532 Patch 27163009
17-Oct-2017 11.2.0.4.171017 (Oct 2017) OJVM Component Patch Set Update Patch 26635834 Patch 26792358
18-Jul-2017 11.2.0.4.170718 (Jul 2017) OJVM Component Patch Set Update Patch 26027154 Patch 26182425
18-Apr-2017 11.2.0.4.170418 (Apr 2017) OJVM Component Patch Set Update Patch 25434033 Patch 25590979
17-Jan-2017 11.2.0.4.170117 (Jan 2017) OJVM Component Patch Set Update Patch 24917954 Patch 25043019
18-Oct-2016 11.2.0.4.161018 (Oct 2016) OJVM Component Patch Set Update Patch 24315821 Patch 24591637
19-Jul-2016 11.2.0.4.160719 (Jul 2016) OJVM Component Patch Set Update Patch 23177551 Patch 23515277
19-Apr-2016 11.2.0.4.160419 (Apr 2016) OJVM Component Patch Set Update Patch 22674697 Patch 22839614
19-Jan-2016 11.2.0.4.160119 (Jan 2016) OJVM Component Patch Set Update Patch 22139245 Patch 22311053
20-Oct-2015 11.2.0.4.5 (Oct 2015) OJVM Component Patch Set Update Patch 21555791 Patch 21788344
14-Jul-2015 11.2.0.4.4 (Jul 2015) OJVM Component Patch Set Update Patch 21068539 Patch 21153498
14-Apr-2015 11.2.0.4.3 (Apr 2015) OJVM Component Patch Set Update Patch 20406239 Patch 20225988
20-Jan-2015 11.2.0.4.2 (Jan 2015) OJVM Component Patch Set Update Patch 19877440 Patch 20225982
14-Oct-2014 11.2.0.4.1 (Oct 2014) OJVM Component Patch Set Update Patch 19282021 Patch 19799291

参考:Database 11.2.0.4 Proactive Patch Information (Doc ID 2285559.1)

win平台 UtilSession 失败: Prerequisite check “CheckActiveFilesAndExecutables” failed. 处理

联系:手机/微信(+86 17813235971) QQ(107644445)QQ咨询惜分飞

标题:win平台 UtilSession 失败: Prerequisite check “CheckActiveFilesAndExecutables” failed. 处理

作者:惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]

win平台打patch,提示UtilSession 失败: Prerequisite check “CheckActiveFilesAndExecutables” failed.

C:\Users\Administrator\Desktop\nmgOracle补丁\34474433>E:\app\Administrator\produ
ct\11.2.0\dbhome_1\OPatch\opatch apply ./
Oracle 临时补丁程序安装程序版本 11.2.0.3.40
版权所有 (c) 2023, Oracle Corporation。保留所有权利。


Oracle 主目录       :E:\app\ADMINI~1\product\112~1.0\dbhome_1
主产品清单:C:\Program Files\Oracle\Inventory
   来自           :
OPatch 版本    :11.2.0.3.40
OUI 版本       :11.2.0.4.0
日志文件位置:E:\app\ADMINI~1\product\112~1.0\dbhome_1\cfgtoollogs\opatch\opatch
2023-04-20_18-05-20下午_1.log

Verifying environment and performing prerequisite checks...
Prerequisite check "CheckActiveFilesAndExecutables" failed.
The details are:

Following active files/executables/libs are used by ORACLE_HOME :E:\app\ADMINI~1
\product\112~1.0\dbhome_1
E:\app\ADMINI~1\product\112~1.0\dbhome_1\bin\oraxml11.dll
E:\app\ADMINI~1\product\112~1.0\dbhome_1\bin\orahasgen11.dll
E:\app\ADMINI~1\product\112~1.0\dbhome_1\bin\oraocr11.dll
E:\app\ADMINI~1\product\112~1.0\dbhome_1\bin\oraocrb11.dll
E:\app\ADMINI~1\product\112~1.0\dbhome_1\bin\oraocrutl11.dll
E:\app\ADMINI~1\product\112~1.0\dbhome_1\bin\oran11.dll
E:\app\ADMINI~1\product\112~1.0\dbhome_1\bin\orantcp11.dll
E:\app\ADMINI~1\product\112~1.0\dbhome_1\bin\oranl11.dll
E:\app\ADMINI~1\product\112~1.0\dbhome_1\bin\orancrypt11.dll
E:\app\ADMINI~1\product\112~1.0\dbhome_1\bin\orapls11.dll
E:\app\ADMINI~1\product\112~1.0\dbhome_1\bin\orageneric11.dll
E:\app\ADMINI~1\product\112~1.0\dbhome_1\bin\oraclient11.dll
E:\app\ADMINI~1\product\112~1.0\dbhome_1\bin\oracommon11.dll
E:\app\ADMINI~1\product\112~1.0\dbhome_1\rdbms\mesg\diaus.msb
E:\app\ADMINI~1\product\112~1.0\dbhome_1\bin\oraplc11.dll
E:\app\ADMINI~1\product\112~1.0\dbhome_1\bin\oraplp11.dll
E:\app\ADMINI~1\product\112~1.0\dbhome_1\bin\orannzsbb11.dll
E:\app\ADMINI~1\product\112~1.0\dbhome_1\bin\orazt11.dll
E:\app\ADMINI~1\product\112~1.0\dbhome_1\bin\oraztkg11.dll
E:\app\ADMINI~1\product\112~1.0\dbhome_1\bin\oraldapclnt11.dll
E:\app\ADMINI~1\product\112~1.0\dbhome_1\bin\oracore11.dll
E:\app\ADMINI~1\product\112~1.0\dbhome_1\bin\oracell11.dll
E:\app\ADMINI~1\product\112~1.0\dbhome_1\bin\oraasmclnt11.dll
E:\app\ADMINI~1\product\112~1.0\dbhome_1\bin\orannzsbb11.dll
E:\app\ADMINI~1\product\112~1.0\dbhome_1\bin\orazt11.dll
E:\app\ADMINI~1\product\112~1.0\dbhome_1\bin\oraztkg11.dll

UtilSession 失败: Prerequisite check "CheckActiveFilesAndExecutables" failed.
Log file location: E:\app\ADMINI~1\product\112~1.0\dbhome_1\cfgtoollogs\opatch\o
patch2023-04-20_18-05-20下午_1.log

OPatch failed with error code = 73

通过tasklist命令找出来占用的进程名称和进程号

E:\app\Administrator\product\11.2.0\dbhome_1\OPatch>tasklist /M ora*

映像名称                       PID 模块
========================= ======== ============================================
esfdaemon.exe                 1296 oracleclientsvc.dll, oracleengine.dll,
                                   oracledatasource.dll, oraclecore.dll,
                                   OraClient11.Dll, oracore11.dll,
                                   oranls11.dll, oraunls11.dll, orauts.dll,
                                   oracommon11.dll, orasnls11.dll,
                                   orageneric11.dll, oraxml11.dll, oran11.dll,
                                   oranl11.dll, orantcp11.dll, oranldap11.dll,
                                   orannzsbb11.dll, oraldapclnt11.dll,
                                   orancrypt11.dll, orazt11.dll, oranro11.dll,
                                   oranhost11.dll, orancds11.dll,
                                   orantns11.dll, oraztkg11.dll, orapls11.dll,
                                   oraslax11.dll, oravsn11.dll, oraplp11.dll,
                                   orahasgen11.dll, oraocr11.dll,
                                   oraocrb11.dll, oraasmclnt11.dll,
                                   oracell11.dll, oraocrutl11.dll,
                                   orasql11.dll, OraPlc11.Dll, oranbeq11.dll
plsqldev.exe                 29840 OraClient11.Dll, oracore11.dll,
                                   oranls11.dll, oraunls11.dll, orauts.dll,
                                   oracommon11.dll, orasnls11.dll,
                                   orageneric11.dll, oraxml11.dll, oran11.dll,
                                   oranl11.dll, orantcp11.dll, oranldap11.dll,
                                   orannzsbb11.dll, oraldapclnt11.dll,
                                   orancrypt11.dll, orazt11.dll, oranro11.dll,
                                   oranhost11.dll, orancds11.dll,
                                   orantns11.dll, oraztkg11.dll, orapls11.dll,
                                   oraslax11.dll, oravsn11.dll, oraplp11.dll,
                                   orahasgen11.dll, oraocr11.dll,
                                   oraocrb11.dll, oraasmclnt11.dll,
                                   oracell11.dll, oraocrutl11.dll,
                                   orasql11.dll, OraPlc11.Dll

可以在任务管理器中直接把相关进程kill掉,也可以通过taskkill /F /im 进程名方式杀掉进程,然后再次检查占用情况,无任何进程占用的情况下,就可以直接打patch

E:\app\Administrator\product\11.2.0\dbhome_1\OPatch>tasklist /M ora*
信息: 没有运行的任务匹配指定标准。

12.1.0.2最新patch—202301

联系:手机/微信(+86 17813235971) QQ(107644445)QQ咨询惜分飞

标题:12.1.0.2最新patch—202301

作者:惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]

Release Date Version Download link Included in Windows Bundle
17-Jan-2023 12.1.0.2.230117 (Jan 2023) Database Patch Set Update (DB PSU) Patch 34677720 NA – out of error correction

SPARC and AIX ETA is 30-Jan-2023

18-Oct-2022 12.1.0.2.221018 (Oct 2022) Database Patch Set Update (DB PSU) Patch 34386266 NA – out of error correction
19-Jul-2022 12.1.0.2.220719 (Jul 2022) Database Patch Set Update (DB PSU) Patch 34057742 12.1.0.2.220719 WIN DB BP Patch 33883271
19-Apr-2022 12.1.0.2.220419 (Apr 2022) Database Patch Set Update (DB PSU) Patch 33711081 12.1.0.2.220419 WIN DB BP Patch 33777450
18-Jan-2022 12.1.0.2.220118 (Jan 2022) Database Patch Set Update (DB PSU) Patch 33477199 12.1.0.2.220118 WIN DB BP Patch 33492893
19-Oct-2021 12.1.0.2.211019 (Oct 2021) Database Patch Set Update (DB PSU) Patch 33128590 12.1.0.2.211019 WIN DB BP Patch 33174365
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
15-Oct-2019 12.1.0.2.191015 (Oct 2019) Database Patch Set Update (DB PSU) Patch 29918340 12.1.0.2.191015 WIN DB BP Patch 30049606
16-Jul-2019 12.1.0.2.190716 (Jul 2019) Database Patch Set Update (DB PSU) Patch 29494060 12.1.0.2.190716 WIN DB BP Patch 29831650
16-Apr-2019 12.1.0.2.190416 (Apr 2019) Database Patch Set Update (DB PSU) Patch 29141015 12.1.0.2.190416 WIN DB BP Patch 29413116
15-Jan-2019 12.1.0.2.190115 (Jan 2019) Database Patch Set Update (DB PSU) Patch 28729169 12.1.0.2.190115 WIN DB BP Patch 28810679
16-Oct-2018 12.1.0.2.181016 (Oct 2018) Database Patch Set Update (DB PSU) Patch 28259833 12.1.0.2.181016 WIN DB BP Patch 28563501
17-Jul-2018 12.1.0.2.180717 (Jul 2018) Database Patch Set Update (DB PSU) Patch 27547329 12.1.0.2.180717 WIN DB BP Patch 27937907
17-Apr-2018 12.1.0.2.180417 (Apr 2018) Database Patch Set Update (DB PSU) Patch 27338041 12.1.0.2.180417 WIN DB BP Patch 27440294
16-Jan-2018 12.1.0.2.180116 (Jan 2018) Database Patch Set Update (DB PSU) Patch 26925311 12.1.0.2.180116 WIN DB BP Patch 27162953
17-Oct-2017 12.1.0.2.171017 (Oct 2017) Database Patch Set Update (DB PSU) Patch 26713565 12.1.0.2.171017 WIN DB BP Patch 26720785
14-Aug-2017 12.1.0.2.170814 (Jul 2017) Database Patch Set Update (DB PSU) Patch 26609783 12.1.0.2.170814 WIN DB BP Patch 26161726
18-Jul-2017 12.1.0.2.170718 (Jul 2017) Database Patch Set Update (DB PSU) Patch 25755742 12.1.0.2.170718 WIN DB BP Patch 26161724
18-Apr-2017 12.1.0.2.170418 (Apr 2017) Database Patch Set Update (DB PSU) Patch 25171037 12.1.0.2.170418 WIN DB BP Patch 25632533
17-Jan-2017 12.1.0.2.170117 (Jan 2017) Database Patch Set Update (DB PSU) Patch 24732082 12.1.0.2.170117 WIN DB BP Patch 25115951
18-Oct-2016 12.1.0.2.161018 (Oct 2016) Database Patch Set Update (DB PSU) Patch 24006101 12.1.0.2.161018 WIN DB BP Patch 24591642
19-Jul-2016 12.1.0.2.160719 (Jul 2016) Database Patch Set Update (DB PSU) Patch 23054246 12.1.0.2.160719 WIN DB BP Patch 23530387
19-Apr-2016 12.1.0.2.160419 (Apr 2016) Database Patch Set Update (DB PSU) Patch 22291127 12.1.0.2.160419 WIN DB BP Patch 22809813
19-Jan-2016 12.1.0.2.160119 (Jan 2016) Database Patch Set Update (DB PSU) Patch 21948354 12.1.0.2.160119 WIN DB BP Patch 22310559
20-Oct-2015 12.1.0.2.5 (Oct 2015) Database Patch Set Update (DB PSU) Patch 21359755 12.1.0.2 Patch 10 Patch 21821214
14-Jul-2015 12.1.0.2.4 (Jul 2015) Database Patch Set Update (DB PSU) Patch 20831110 12.1.0.2 Patch 7 Patch 21126814
14-Apr-2015 12.1.0.2.3 (Apr 2015) Database Patch Set Update (DB PSU) Patch 20299023 12.1.0.2 Patch 4 Patch 20684004
20-Jan-2015 12.1.0.2.2 (Jan 2015) Database Patch Set Update (DB PSU) Patch 19769480 12.1.0.2 Patch 1 Patch 19720843
14-Oct-2014 12.1.0.2.1 (Oct 2014) Database Patch Set Update (DB PSU) Patch 19303936 none

 

Release Date Version Download link
17-Jan-2023 12.1.0.2.230117 (Jan 2023) Grid Infrastructure Patch Set Update (GI PSU) Patch 34774519

SPARC and AIX ETA is 30-Jan-2023

18-Oct-2022 12.1.0.2.221018 (Oct 2022) Grid Infrastructure Patch Set Update (GI PSU) Patch 34535560
19-Jul-2022 12.1.0.2.220719 (Jul 2022) Grid Infrastructure Patch Set Update (GI PSU) Patch 34204576
19-Apr-2022 12.1.0.2.220419 (Apr 2022) Grid Infrastructure Patch Set Update (GI PSU) Patch 33829718
18-Jan-2022 12.1.0.2.220118 (Jan 2022) Grid Infrastructure Patch Set Update (GI PSU) Patch 33575274
19-Oct-2021 12.1.0.2.211019 (Oct 2021) Grid Infrastructure Patch Set Update (GI PSU) Patch 33248367
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
15-Oct-2019 12.1.0.2.191015 (Oct 2019) Grid Infrastructure Patch Set Update (GI PSU) Patch 30070257
16-Jul-2019 12.1.0.2.190716 (Jul 2019) Grid Infrastructure Patch Set Update (GI PSU) Patch 29698592
16-Apr-2019 12.1.0.2.190416 (Apr 2019) Grid Infrastructure Patch Set Update (GI PSU) Patch 29176115
15-Jan-2019 12.1.0.2.190115 (Jan 2019) Grid Infrastructure Patch Set Update (GI PSU) Patch 28813884
16-Oct-2018 12.1.0.2.181016 (Oct 2018) Grid Infrastructure Patch Set Update (GI PSU) Patch 28349311
17-Jul-2018 12.1.0.2.180717 (Jul 2018) Grid Infrastructure Patch Set Update (GI PSU) Patch 27967747
17-Apr-2018 12.1.0.2.180417 (Apr 2018) Grid Infrastructure Patch Set Update (GI PSU) Patch 27468957
16-Jan-2018 12.1.0.2.180116 (Jan 2018) Grid Infrastructure Patch Set Update (GI PSU) Patch 27010872
17-Oct-2017 12.1.0.2.171017 (Oct 2017) Grid Infrastructure Patch Set Update (GI PSU) Patch 26635815
14-Aug-2017 12.1.0.2.170814 (Jul 2017) Grid Infrastructure Patch Set Update (GI PSU) Patch 26610308
18-Jul-2017 12.1.0.2.170718 (Jul 2017) Grid Infrastructure Patch Set Update (GI PSU) Patch 25901062
18-Apr-2017 12.1.0.2.170418 (Apr 2017) Grid Infrastructure Patch Set Update (GI PSU) Patch 25434003
17-Jan-2017 12.1.0.2.170117 (Jan 2017) Grid Infrastructure Patch Set Update (GI PSU) Patch 24917825
18-Oct-2016 12.1.0.2.161018 (Oct 2016) Grid Infrastructure Patch Set Update (GI PSU) Patch 24412235
19-Jul-2016 12.1.0.2.160719 (Jul 2016) Grid Infrastructure Patch Set Update (GI PSU) Patch 23273629
19-Apr-2016 12.1.0.2.160419 (Apr 2016) Grid Infrastructure Patch Set Update (GI PSU) Patch 22646084
19-Jan-2016 12.1.0.2.160119 (Jan 2016) Grid Infrastructure Patch Set Update (GI PSU) Patch 22191349
20-Oct-2015 12.1.0.2.5 (Oct 2015) Grid Infrastructure Patch Set Update (GI PSU) Patch 21523234
14-Jul-2015 12.1.0.2.4 (Jul 2015) Grid Infrastructure Patch Set Update (GI PSU) Patch 20996835
14-Apr-2015 12.1.0.2.3 (Apr 2015) Grid Infrastructure Patch Set Update (GI PSU) Patch 20485724
20-Jan-2015 12.1.0.2.2 (Jan 2015) Grid Infrastructure Patch Set Update (GI PSU) Patch 19954978
14-Oct-2014 12.1.0.2.1 (Oct 2014) Grid Infrastructure Patch Set Update (GI PSU) Patch 19392646

 

Release Date Version Unix PSU Patch Windows Bundle Patch
17-Jan-2023 12.1.0.2.230117 (Jan 2023) OJVM Component Patch Set Update Patch 34763317 NA – out of error correction
18-Oct-2022 12.1.0.2.221018 (Oct 2022) OJVM Component Patch Set Update Patch 34412250 NA – out of error correction
19-Jul-2022 12.1.0.2.220719 (Jul 2022) OJVM Component Patch Set Update Patch 34086863 Patch 34185253
19-Apr-2022 12.1.0.2.220419 (Apr 2022) OJVM Component Patch Set Update Patch 33808385 Patch 33881387
18-Jan-2022 12.1.0.2.220118 (Jan 2022) OJVM Component Patch Set Update Patch 33561268 Patch 33577533
19-Oct-2021 12.1.0.2.211019 (Oct 2021) OJVM Component Patch Set Update Patch 33192628 Patch 33248785
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
15-Oct-2019 12.1.0.2.191015 (Oct 2019) OJVM Component Patch Set Update Patch 30128197 Patch 30268189
16-Jul-2019 12.1.0.2.190716 (Jul 2019) OJVM Component Patch Set Update Patch 29774383 Patch 29837393
16-Apr-2019 12.1.0.2.190416 (Apr 2019) OJVM Component Patch Set Update Patch 29251241 Patch 29447962
15-Jan-2019 12.1.0.2.190115 (Jan 2019) OJVM Component Patch Set Update Patch 28790654 Patch 28994063
16-Oct-2018 12.1.0.2.181016 (Oct 2018) OJVM Component Patch Set Update Patch 28440711 Patch 28412299
17-Jul-2018 12.1.0.2.180717 (Jul 2018) OJVM Component Patch Set Update Patch 27923320 Patch 28135126
17-Apr-2018 12.1.0.2.180417 (Apr 2018) OJVM Component Patch Set Update Patch 27475603 Patch 27440294
16-Jan-2018 12.1.0.2.180116 (Jan 2018) OJVM Component Patch Set Update Patch 27001733 Patch 27001733
17-Oct-2017 12.1.0.2.171017 (Oct 2017) OJVM Component Patch Set Update Patch 26635845 Patch 26792364
18-Jul-2017 12.1.0.2.170718 (Jul 2017) OJVM Component Patch Set Update Patch 26027162 Patch 26182439
18-Apr-2017 12.1.0.2.170418 (Apr 2017) OJVM Component Patch Set Update Patch 25437695 Patch 25590993
17-Jan-2017 12.1.0.2.170117 (Jan 2017) OJVM Component Patch Set Update Patch 24917972 Patch 25112498
18-Oct-2016 12.1.0.2.161018 (Oct 2016) OJVM Component Patch Set Update Patch 24315824 Patch 24591630
19-Jul-2016 12.1.0.2.160719 (Jul 2016) OJVM Component Patch Set Update Patch 23177536 Patch 23515290
19-Apr-2016 12.1.0.2.160419 (Apr 2016) OJVM Component Patch Set Update Patch 22674709 Patch 22839633
19-Jan-2016 12.1.0.2.160119 (Jan 2016) OJVM Component Patch Set Update Patch 22139226 Patch 22311086
20-Oct-2015 12.1.0.2.5 (Oct 2015) OJVM Component Patch Set Update Patch 21555660 Patch 21788394
14-Jul-2015 12.1.0.2.4 (Jul 2015) OJVM Component Patch Set Update Patch 21068507 Patch 21153530
14-Apr-2015 12.1.0.2.3 (Apr 2015) OJVM Component Patch Set Update Patch 20415564 Patch 20391199
20-Jan-2015 12.1.0.2.2 (Jan 2015) OJVM Component Patch Set Update Patch 19877336 Patch 20225938
14-Oct-2014 12.1.0.2.1 (Oct 2014) OJVM Component Patch Set Update Patch 19282028 -

参考:Database 12.1.0.2 Proactive Patch Information (Doc ID 2285558.1)