分类目录归档：Oracle

ORA-600 kzrini:!uprofile处理

发表于 2023 年 4 月 27 日 由 惜分飞

朋友反馈,oracle expdp导出数据hang住,然后重启数据库,启动成功,但是执行导出的时候报ORA-600 kzrini:!uprofile错误
kzrini uprofile

因为有过大量类似故障的恢复case,所以第一反应这种故障很可能就是tab$被清空的故障,参见:警告：互联网中有oracle介质被注入恶意程序导致—ORA-600 16703,对于这类故障,我们是国内第一个发现并且进行预警(在blog,qq/微信群,oracle技术大会等),但是还有很多朋友中招.今天这个发现故障之后没有重启,比较顺利，进行反删除插入即可,参考以前的处理:ORA-600 16703直接把orachk备份表插入到tab$恢复

发表在 Oracle备份恢复 | 标签为 , , , , | 评论关闭

数据库open报ORA-07445 kglsget错误处理

发表于 2023 年 4 月 21 日 由 惜分飞

有朋友反馈,数据库服务器断电之后,强制拉库无法open成功

Wed Apr 19 18:13:30 2023
ALTER DATABASE OPEN
Beginning crash recovery of 1 threads
 parallel recovery started with 32 processes
Started redo scan
Completed redo scan
 read 35 KB redo, 20 data blocks need recovery
Started redo application at
 Thread 1: logseq 4, block 3
Recovery of Online Redo Log: Thread 1 Group 1 Seq 4 Reading mem 0
  Mem# 0: E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO01.LOG
Completed redo application of 0.02MB
Completed crash recovery at
 Thread 1: logseq 4, block 73, scn 157134992
 20 data blocks read, 20 data blocks written, 35 redo k-bytes read
Thread 1 advanced to log sequence 5 (thread open)
Thread 1 opened at log sequence 5
  Current log# 2 seq# 5 mem# 0: E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO02.LOG
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
SMON: enabling cache recovery
Successfully onlined Undo Tablespace 2.
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Database Characterset is ZHS16GBK
No Resource Manager plan active
Starting background process QMNC
Wed Apr 19 18:13:34 2023
QMNC started with pid=56, OS id=6380 
Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0x12] [PC:0x9068BE9, kglsget()+547]
ERROR: Unable to normalize symbol name for the following short stack (at offset 199):
dbgexProcessError()+193<-dbgeExecuteForError()+65<-dbgePostErrorKGE()+1726
<-dbkePostKGE_kgsf()+75<-kgeade()+560<-kgerev()+125<-kgerec5()+60<-sss_xcpt_EvalFilterEx()+1869
<-sss_xcpt_EvalFilter()+174<-.1.6_8+59<-00007FFB13102316<-00007FFB1311398D<-00007FFB130D93A7
<-00007FFB13112B1A<-kglsget()+547<-qcdolci()+80<-qcdoloi()+167<-qcdlgcd()+940<-kkdlgcd()+129
<-PGOSF158_kkmfbtcn()+17<-qcsIsColInFro()+474<-qcsRslvColWithinQbc()+304<-qcsStrongColRslv()+632
<-qcsRslvName()+212<-qcsridn()+104<-qcsraic()+736<-qcspqbDescendents()+485<-qcspqb()+154<-kkmdrv()+200
<-opiSem()+2560<-opiDeferredSem()+565<-opitca()+391<-PGOSF525_kksFullTypeCheck()+27<-rpiswu2()+2757
<-kksLoadChild()+9357<-kxsGetRuntimeLock()+2320<-kksfbc()+15225<-kkspsc0()+2117<-kksParseCursor()+181
<-opiosq0()+2538<-opiall0()+6705<-opikpr()+699<-opiodr()+1662<-rpidrus()+862<-rpidru()+154<-rpiswu2()+2757
<-kprball()+1610<-qmCheckIfXdbInstalled()+1059<-qm_open_db()+11<-kscnfy()+778
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_6036.trc  (incident=113085):
ORA-07445: 出现异常错误: 核心转储 [kglsget()+547] [ACCESS_VIOLATION] [ADDR:0x12] [PC:0x9068BE9] [UNABLE_TO_READ] []
Incident details in: e:\app\administrator\diag\rdbms\orcl\orcl\incident\incdir_113085\orcl_ora_6036_i113085.trc
Wed Apr 19 18:13:36 2023
Trace dumping is performing id=[cdmp_20230419181336]
Wed Apr 19 18:13:39 2023
PMON (ospid: 6624): terminating the instance due to error 397
Instance terminated by PMON, pid = 6624

查看trace文件

*** 2023-04-21 17:29:42.077
*** SESSION ID:(898.359) 2023-04-21 17:29:42.077
*** CLIENT ID:() 2023-04-21 17:29:42.077
*** SERVICE NAME:(SYS$USERS) 2023-04-21 17:29:42.077
*** MODULE NAME:(sqlplus.exe) 2023-04-21 17:29:42.077
*** ACTION NAME:() 2023-04-21 17:29:42.077
 
Dump continued from file: e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_9648.trc
ORA-07445: 出现异常错误: 核心转储 [kglsget()+547] [ACCESS_VIOLATION] [ADDR:0x12] [PC:0x9138BE9] [UNABLE_TO_READ] []

========= Dump for incident 444285 (ORA 7445 [kglsget()+547]) ========
----- Beginning of Customized Incident Dump(s) -----
Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0x12] [PC:0x9138BE9, kglsget()+547]

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
Process Id: 0x00000a8c  Thread Id : 0x000025b0    Time : Fri Apr 21 17:29:42 
Excp. Code: 0xc0000005  Excp. Type: ACCESS_VIO    Flags: 0x00000000

------------------- Registers ----------------------------
ip=0000000009138BE9 sp=00000000276FA470 rp=0000000A0BF280D0
r1=000000001089AFE0 r2=0000000000000000 r3=0000000000000101 
r4=00000009BDFE40B0 r5=00000000276FA470 r6=0000000A0BF280D0 r7=00000000000005C0 
r8=00000009B9DC4F48 r9=0000000A0BF280D0 r10=0000000000000200 r11=00000000276FA590 
r12=00000009ED85F4C0 r13=000000000CB3C070 r14=0000000000000001 r15=0000000000000001 
------------------- End of Registers ---------------------


*** 2023-04-21 17:29:42.077
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x3, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=gtf6tgc2ycgxx) -----
select count(*) from XDB.XDB$SCHEMA s where s.xmldata.schema_url = 'http://xmlns.oracle.com/xdb/XDBSchema.xsd'

----- Call Stack Trace -----
calling              call     entry                argument values in hex      
location             type     point                (? means dubious value)     
-------------------- -------- -------------------- ----------------------------
kglsget()+547                 0000000000000000     009962700 00996270C 000000000
                                                   0276DCCA0
qcdolci()+80         CALL???  kglsget()+347        9C5F9E7D0 009138AE2 000000018
                                                   000000001
qcdoloi()+167        CALL???  qcdolci()            00000DC7E 008D52DEF 000000006
                                                   00CB5BEE8
qcdlgcd()+940        CALL???  qcdoloi()            000000000 000000000 000000000
                                                   000000000
kkdlgcd()+129        CALL???  qcdlgcd()            000000000 9B9DC6C78 000000000
                                                   01089AA20
__PGOSF158_kkmfbtcn  CALL???  kkdlgcd()            01089AFE0 00CB5BEE8 000000000
()+17                                              000000000
qcsIsColInFro()+474  CALL???  __PGOSF158_kkmfbtcn  000000001 9BDFE41E0 000000000
                              ()                   000000001
qcsRslvColWithinQbc  CALL???  qcsIsColInFro()      900000000 01089AFE0 0276FCFC0
()+304                                             742E204F1B71
qcsStrongColRslv()+  CALL???  qcsRslvColWithinQbc  000000010 27F00000000
632                           ()+73                000000000 000000000
qcsRslvName()+212    CALL???  qcsStrongColRslv()+  0276FA9E0 9C3F136C0 00764E4E0
                              516                  0093A505B
qcsridn()+104        CALL???  qcsRslvName()        101000000000000 000000000
                                                   000000000 0276FAE90
qcsraic()+736        CALL???  qcsridn()            0276FACB0 0276FACB0 000000000
                                                   000000001
qcspqbDescendents()  CALL???  qcsraic()            0276FAE90 01089AFE0 00CB5D030
+485                                               00CB5CEE8
qcspqb()+154         CALL???  qcspqbDescendents()  00000002A 008D53029 01089AFE0
                                                   000000000
kkmdrv()+200         CALL???  qcspqb()             000000029 00895C700 0276FAF90
                                                   00895C700
opiSem()+2560        CALL???  kkmdrv()             00CB31730 0108B7820 000000001
                                                   9C3F13730
opiDeferredSem()+56  CALL???  opiSem()             0276FCFC0 A09FA3D68 00000006E
5                                                  000000001
opitca()+391         CALL???  opiDeferredSem()     000000001 000000000 006F7AC18
                                                   000000000
__PGOSF525_kksFullT  CALL???  opitca()             037615F10 9C3F138D0 0277000A0
ypeCheck()+27                                      00895C700
rpiswu2()+2757       CALL???  __PGOSF525_kksFullT  0276FEB98 000004018 0108A04E0
                              ypeCheck()           0108A0700
kksLoadChild()+9357  CALL???  rpiswu2()            9F86A81C8 000000000 9C5F9D1E4
                                                   000000002
kxsGetRuntimeLock()  CALL???  kksLoadChild()       01089AFE0 A09FA39D8 0276FF400
+2320                                              A09FA39D8
kksfbc()+15225       CALL???  kxsGetRuntimeLock()  01089AFE0 037615F10 0276FF400
                                                   000000103
kkspsc0()+2117       CALL???  kksfbc()             037615F10 000000003 A00000108
                                                   0076D1C80
kksParseCursor()+18  CALL???  kkspsc0()            00CAD1DA8 0076D1C80 00000006F
1                                                  000000003
opiosq0()+2538       CALL???  kksParseCursor()     00CACF990 000000000 00895C700
                                                   027700940
opiall0()+6705       CALL???  opiosq0()            000000003 00000000E 0277010C0
                                                   000000020
opikpr()+699         CALL???  opiall0()            000000065 000000022 0277018C8
                                                   000000000
opiodr()+1662        CALL???  opikpr()             000000065 90000001C 027703208
                                                   01089AA20
rpidrus()+862        CALL???  opiodr()             000000065 00000001C 027703208
                                                   000000000
rpidru()+154         CALL???  rpidrus()            0277027F8 000000000 000000000
                                                   000000000
rpiswu2()+2757       CALL???  rpidru()             027703030 000000000 000000000
                                                   000000000
kprball()+1610       CALL???  rpiswu2()            9F86A81C8 000000000 027702E50
                                                   000000002
qmCheckIfXdbInstall  CALL???  kprball()            027703208 000000100 000000002
ed()+1059                                          00CAEC188
qm_open_db()+11      CALL???  qmCheckIfXdbInstall  000000000 000000000 000000000
                              ed()                 00895C700
kscnfy()+778         CALL???  qm_open_db()         657FC5CD00000019 000000000
                                                   000000000 100000000
adbdrv()+45489       CALL???  kscnfy()             000000019 000000000 000000000
                                                   000000000
opiexe()+20842       CALL???  adbdrv()             000000023 000000003 A00000102
                                                   000000000
opiosq0()+5129       CALL???  opiexe()+16981       000000004 000000000 02770A8C0
                                                   009121AB3
kpooprx()+357        CALL???  opiosq0()            000000003 00000000E 02770AB90
                                                   0000000A4
kpoal8()+940         CALL???  kpooprx()            01089AFE0 0090CC0A8 01089AFE0
                                                   000000001
opiodr()+1662        CALL???  kpoal8()             00000005E 00000001C 02770E100
                                                   00ABBF224
ttcpip()+1325        CALL???  opiodr()             00000005E 00000001C 02770E100
                                                   4100200000000000
opitsk()+2040        CALL???  ttcpip()             0108B4D00 000000000 000000000
                                                   000000000
opiino()+1258        CALL???  opitsk()             00000001E 000000000 000000000
                                                   02770F9F8
opiodr()+1662        CALL???  opiino()             00000003C 000000004 02770FAB0
                                                   000000000
opidrv()+864         CALL???  opiodr()             00000003C 000000004 02770FAB0
                                                   615C3A6500000000
sou2o()+98           CALL???  opidrv()+150         00000003C 000000004 02770FAB0
                                                   000000000
opimai_real()+158    CALL???  sou2o()              064425745 000000000 000000000
                                                   02770FBA4
opimai()+191         CALL???  opimai_real()        7FFA241388C0 7FFA24138A49
                                                   000000000 00895C700

*** 2023-04-21 17:29:42.343
OracleThreadStart()  CALL???  opimai()             000401452 000000002 0085DFE20
+724                                               0000025B0
00007FFA246713D2     CALL???  OracleThreadStart()  00FCAFF18 000000000 000000000
                                                   000000000
00007FFA26D403C4     CALL???  00007FFA246713B0     7FFA246713B0 000000000
                                                   000000000 000000000
 

--------------------- Binary Stack Dump ---------------------

确定报错是在select count(*) from XDB.XDB$SCHEMA s where s.xmldata.schema_url = ‘http://xmlns.oracle.com/xdb/XDBSchema.xsd’这个sql语句中,对其数据库启动过程进行跟踪，没有发现该语句而是只有报错

EXEC #6:c=0,e=181,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,plh=3755742892,tim=22655713465
FETCH #6:c=0,e=12,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=4,plh=3755742892,tim=22655713503
CLOSE #6:c=0,e=6,dep=2,type=3,tim=22655713532
Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0x12] [PC:0x9138BE9, kglsget()+547]
 dump file: e:\app\administrator\diag\rdbms\orcl\orcl\incident\incdir_452285\orcl_ora_9848_i452285.trc
ORA-07445: 出现异常错误: 核心转储 [kglsget()+547] [ACCESS_VIOLATION] [ADDR:0x12] [PC:0x9138BE9] [UNABLE_TO_READ] []

证明ORA-07445 kglsget错误的语句没有到sql执行阶段,而是在解析阶段就开始报错.通过对oracle启动过程进行处理(因为该语句不是数据库启动个必须的语句)，规避掉该sql执行,实现数据库正常open
20230421223825

发表在 Oracle备份恢复 | 标签为 , , | 评论关闭

12.1.0.2最新patch信息—202304

发表于 2023 年 4 月 21 日 由 惜分飞

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)

发表在 Oracle安装升级 | 标签为 , , , | 评论关闭