Patches
to apply before upgrading Oracle GI and DB to 19c or downgrading to previous
release (Doc ID 2539751.1)
GI Upgrade to 19c
From Release
|
Bug#(s)
|
Patch
|
Description
|
Additional
comments
|
18c
|
28553832
|
28553832
|
LNX-191-EXA:CSSD
PROCESS CANNOT GET REAL-TIME PRIORITY
|
p28553832_183000OCWRU_<platform>.zip
|
12.2.0.1.0
|
28553832
|
28553832
|
LNX-191-EXA:CSSD
PROCESS CANNOT GET REAL-TIME PRIORITY
|
p28553832_12201190115OCWJAN2019RU_<platform>.zip
|
12.1.0.2
|
21255373
|
|
|
Recommended
to install latest 12.1.0.2 GI PSU
|
28553832
|
28553832
|
LNX-191-EXA:CSSD
PROCESS CANNOT GET REAL-TIME PRIORITY
|
p28553832_12102190115forOCW_<platform>.zip
|
11.2.0.4
|
17617807
21255373
|
GI PSU
22646198
|
11.2.0.4.160419
(Apr 2016) Grid Infrastructure Patch Set Update (GI PSU)
|
Recommended
to install latest* 11.2.0.4 GI PSU
|
28553832
|
28553832
|
LNX-191-EXA:CSSD
PROCESS CANNOT GET REAL-TIME PRIORITY
|
p28553832_11204190115forOCW_<platform>.zip
|
DB Upgrades to
19c
Note: following
patches needed if you have GI Setup
From Release
|
Bug#(s)
|
Patch
|
Description
|
Additional
comments
|
18c
|
28553832
|
28553832
|
LNX-191-EXA:CSSD
PROCESS CANNOT GET REAL-TIME PRIORITY
|
p28553832_183000OCWRU_<platform>.zip
|
12.2.0.1.0
|
28553832
|
28553832
|
LNX-191-EXA:CSSD
PROCESS CANNOT GET REAL-TIME PRIORITY
|
p28553832_12201190115OCWJAN2019RU_<platform>.zip
|
12.1.0.2
|
21255373
|
|
|
|
28553832
|
28553832
|
LNX-191-EXA:CSSD
PROCESS CANNOT GET REAL-TIME PRIORITY
|
p28553832_12102190115forOCW_<platform>.zip
|
11.2.0.4
|
17617807
21255373
|
GI PSU
22646198
|
11.2.0.4.160419
(Apr 2016) Grid Infrastructure Patch Set Update (GI PSU)
|
|
28553832
|
28553832
|
LNX-191-EXA:CSSD
PROCESS CANNOT GET REAL-TIME PRIORITY
|
p28553832_11204190115forOCW_<platform>.zip
|
Managing older
database with 19c ASM
With Release
|
Bug#(s)
|
Patch
|
Description
|
Additional
comments
|
18c DB
|
None
|
None
|
None
|
None
|
12.2.0.1 DB
|
None
|
None
|
None
|
None
|
12.1.0.2 DB
|
21626377
|
21626377
|
12.2_150812:
DBCA FAILS TO CREATE 12102 DB OVER 12.2 GI/ASM
|
Install
12.1.0.2.170718 DB PSU or later
Install
12.1.0.2.170117 DB Proactive BP or later
|
21780146
|
21780146
|
LNX64-12.2-WLM:
MGMTDB FAILED TO BE CREATED DURING POST GI INSTALLATION
|
11.2.0.4 DB
|
23519414
|
23186035
|
W2K12_122_CMP:
CREATE 11204DB WITH 122 ENV AFTER 1120419DBBP HIT ORA-00955
|
11.2.0.4.190416
(Apr 2019) GI PSU or later
|
DB Downgrades
from 19c
To Release
|
Bug#(s)
|
Patch
|
Description
|
Additional
comments
|
18c (CDB,
non-CDB, PDB unplug/plug/upgrade/downgrade/unplug/plug/catrelod)
|
28655784
|
28655784
|
Oct 2018
Database Release Update 18.4.0.0.0 or later
|
Install
latest RU
|
12.2.0.1
(CDB)
|
28822515
|
28822515
|
Jan 2019
Database Release Update 12.2.0.1.190115 or later
|
Install
latest RU
|
12.1.0.2
(with CDB)
|
28259833
|
28259833
|
Oct 2018
Database Patch Set Update 12.1.0.2.181016 or later
|
Install
latest* DB PSU patch
|
24438034
|
24438034
|
CDB_UPG:
12101 CDB UPGRADE LEFT OBJECT CDB_JAVA_POLICY INVALID
|
Available on
top of 12.1.0.2.170418
|
20348910
|
20348910
|
ALTER TYPE
REPLACE IN PRVTAQJI.SQL TO BE REPLACE WITH CREATE OR REPLACE TYPE
|
Available on
top of 12.1.0.2
Available on
top of 12.1.0.2.7 Proactive BP
|
20958816
|
20958816
|
INVALID
OBJECTS AFTER DOWNGRADE FROM 12.2.0.1 TO 12.1.0.2
|
Install
12.1.0.2.160719 Proactive BP or later
|
12.1.0.2.0
(PDB unplug/plug/upgrade/downgrade/unplug/plug/catrelod)
|
25869760
|
26022196
|
Database
Proactive Bundle Patch 12.1.0.2.170718 or later
|
|
19370504
|
19370504
|
CDB:ORA-13613
IN NONCDB 12102 UPGRADED APPS DB PLUGIN AS PDB
|
12.1.0.2.180116
(Jan 2018) Database PSU or later
12.1.0.2.180116 (Jan 2018) Database Proactive BP or later
|
21388707
|
21388707
|
LNX64-12C-UD:ENABLE
LOCAL UNDO, PLUG 12.1 NONCDB INTO 12.2CDB FAILED
|
Available on
top of 12.1.0.2.170718 ProactiveBP
|
27189168
|
27189168
|
CATRELOD.SQL
HIT ORA-65033 DURING PLUGGABLE DATABASE DOWNGRADE FROM 18C TO 12102
|
Available on
top of 12.1.0.2.170718 ProactiveBP
|
12.1.0.2(non-CDB)
|
28259833
|
28259833
|
Oct. 2018
DATABASE PATCH SET UPDATE 12.1.0.2.181016
|
Install
latest DB PSU patch
|
24438034
|
24438034
|
CDB_UPG:
12101 CDB UPGRADE LEFT OBJECT CDB_JAVA_POLICY INVALID
|
Available on
top of 12.1.0.2.160719 DB PSU
Available on
top of12.1.0.2.170418 DB PSU
Available on
top of 12.1.0.2.160719 Proactive BP
|
20348910
|
20348910
|
ALTER TYPE
REPLACE IN PRVTAQJI.SQL TO BE REPLACE WITH CREATE OR REPLACE TYPE
|
Available on
top of 12.1.0.2
Available on
top of 12.1.0.2.160719 Proactive BP
|
20958816
|
20958816
|
INVALID
OBJECTS AFTER DOWNGRADE FROM 12.2.0.1 TO 12.1.0.2
|
Install
12.1.0.2.160719 Proactive BP or later
|
|
|
|
|
|
11.2.0.4
|
28204707
|
28204707
|
Oct.
2018 DB PSU 11.2.0.4.181016
|
Install
latest DB PSU
|
20898997
|
20898997
|
XMLTYPESUP:
QCTOXSNLB SHOULD NOT CHECK AGAINST SNAPSHOT SIZE
|
On top of
11.2.0.4
|
20348910
|
20348910
|
ALTER TYPE
REPLACE IN PRVTAQJI.SQL TO BE REPLACE WITH CREATE OR REPLACE TYPE
|
Available for
11.2.0.4
|
GI Downgrades
from 19c
To 12.2.0.1
|
None
|
N/A
|
N/A
|
No additional
patches required to downgrade GI (Downgraded to the level using the same
GIPSUs they were upgraded from). More patch info is mentioned in the GI
upgrade category
|
To 12.1.0.2
|
None
|
N/A
|
N/A
|
To 12.1.0.1
|
None
|
N/A
|
N/A
|
To 11.2.0.4
|
None
|
N/A
|
N/A
|
Solaris Sparc 64
bit
GI Upgrade to
19c
From Release
|
Bug#(s)
|
Patch
|
Description
|
Additional
comments
|
18c
|
NA
|
NA
|
NA
|
NA
|
12.2.0.1.0
|
27006180
|
|
|
Fix included
in GI 12.1.0.2.180417 and latest
|
12.1.0.2
|
21255373
|
|
|
Recommended
to install latest 12.1.0.2 GI PSU
|
|
17617807
|
GI PSU
22646198
|
11.2.0.4.160419
(Apr 2016) Grid Infrastructure Patch Set Update (GI PSU)
|
Fix included
in 11.2.0.4.160419 GI PSU
Recommended
to install latest* 11.2.0.4 GI PSU
|
21255373
|
GI PSU
22646198
|
11.2.0.4.160419
(Apr 2016) Grid Infrastructure Patch Set Update (GI PSU)
|
Recommended
to install latest* 11.2.0.4 GI PSU
|
DB Upgrades to
19c
From Release
|
Bug#(s)
|
Patch
|
Description
|
Additional
comments
|
18c
|
NA
|
NA
|
NA
|
NA
|
12.2.0.1.0
|
27006180
|
|
LNX-191-EXA:CSSD
PROCESS CANNOT GET REAL-TIME PRIORITY
|
Fix included
in GI 12.1.0.2.180417 and latest
|
12.1.0.2
|
21255373
|
|
|
|
11.2.0.4
|
17617807
|
GI PSU
22646198
|
11.2.0.4.160419
(Apr 2016) Grid Infrastructure Patch Set Update (GI PSU)
|
|
21255373
|
GI PSU
22646198
|
11.2.0.4.160419
(Apr 2016) Grid Infrastructure Patch Set Update (GI PSU)
|
|
Managing
older database with 19c ASM
With Release
|
Bug#(s)
|
Patch
|
Description
|
Additional
comments
|
18c DB
|
None
|
None
|
None
|
None
|
12.2.0.1 DB
|
None
|
None
|
None
|
None
|
12.1.0.2 DB
|
21626377
|
21626377
|
12.2_150812:
DBCA FAILS TO CREATE 12102 DB OVER 12.2 GI/ASM
|
Install
12.1.0.2.170718 DB PSU or later
Install
12.1.0.2.170117 DB Proactive BP or later
|
21780146
|
21780146
|
LNX64-12.2-WLM:
MGMTDB FAILED TO BE CREATED DURING POST GI INSTALLATION
|
11.2.0.4 DB
|
23519414
|
23186035
|
W2K12_122_CMP:
CREATE 11204DB WITH 122 ENV AFTER 1120419DBBP HIT ORA-00955
|
11.2.0.4.190416
(Apr 2019) GI PSU or later
|
DB Downgrades
from 19c
To Release
|
Bug#(s)
|
Patch
|
Description
|
Additional
comments
|
18c (CDB and
non-CDB, PDB unplug/plug/upgrade/downgrade/unplug/plug/catrelod)
|
28655784
|
28655784
|
Oct 2018
Database Release Update 18.4.0.0.0 or later
|
Install
latest RU
|
12.2.0.1
(CDB)
|
28822515
|
28822515
|
Jan 2019
Database Release Update 12.2.0.1.190115 or later
|
Install
latest RU
|
12.1.0.2
(with CDB)
|
28259833
|
28259833
|
Oct 2018
Database Patch Set Update 12.1.0.2.181016 or later
|
Install
latest* DB PSU patch
|
24438034
|
24438034
|
CDB_UPG:
12101 CDB UPGRADE LEFT OBJECT CDB_JAVA_POLICY INVALID
|
Available on
top of 12.1.0.2.170418
|
20348910
|
20348910
|
ALTER TYPE
REPLACE IN PRVTAQJI.SQL TO BE REPLACE WITH CREATE OR REPLACE TYPE
|
Available on
top of 12.1.0.2
Available on
top of 12.1.0.2.7 Proactive BP
|
20958816
|
20958816
|
INVALID
OBJECTS AFTER DOWNGRADE FROM 12.2.0.1 TO 12.1.0.2
|
Install
12.1.0.2.160719 Proactive BP or later
|
12.1.0.2.0
(PDB unplug/plug/upgrade/downgrade/unplug/plug/catrelod)
|
25869760
|
26022196
|
Database
Proactive Bundle Patch 12.1.0.2.170718 or later
|
|
19370504
|
19370504
|
CDB:ORA-13613
IN NONCDB 12102 UPGRADED APPS DB PLUGIN AS PDB
|
12.1.0.2.180116
(Jan 2018) Database PSU or later
12.1.0.2.180116 (Jan 2018) Database Proactive BP or later
|
27189168
|
27189168
|
CATRELOD.SQL
HIT ORA-65033 DURING PLUGGABLE DATABASE DOWNGRADE FROM 18C TO 12102
|
Available on
top of 12.1.0.2.170718 ProactiveBP
|
12.1.0.2(non-CDB)
|
28259833
|
28259833
|
Oct 2018
Database Patch Set Update 12.1.0.2.181016 or later
|
Install
latest DB PSU patch
|
24438034
|
24438034
|
CDB_UPG:
12101 CDB UPGRADE LEFT OBJECT CDB_JAVA_POLICY INVALID
|
Available on
top of 12.1.0.2.160719 DB PSU
Available on
top of12.1.0.2.170418 DB PSU
Available on
top of 12.1.0.2.160719 Proactive BP
|
20348910
|
20348910
|
ALTER TYPE
REPLACE IN PRVTAQJI.SQL TO BE REPLACE WITH CREATE OR REPLACE TYPE
|
Available on
top of 12.1.0.2
Available on
top of 12.1.0.2.160719 Proactive BP
|
20958816
|
20958816
|
INVALID
OBJECTS AFTER DOWNGRADE FROM 12.2.0.1 TO 12.1.0.2
|
Install
12.1.0.2.160719 Proactive BP or later
|
12.2.0.1
(non-CDB)
|
28822515
|
28822515
|
DB RU
|
Install
Latest DB RU
|
|
|
|
|
|
11.2.0.4
|
28204707
|
28204707
|
Oct
2018 DB PSU
|
Install
latest DB PSU
|
20898997
|
20898997
|
XMLTYPESUP:
QCTOXSNLB SHOULD NOT CHECK AGAINST SNAPSHOT SIZE
|
On top of
11.2.0.4
|
20348910
|
20348910
|
ALTER TYPE
REPLACE IN PRVTAQJI.SQL TO BE REPLACE WITH CREATE OR REPLACE TYPE
|
Available for
11.2.0.4
|
GI Downgrades
from 19c
To 12.2.0.1
|
None
|
N/A
|
N/A
|
No additional
patches required to downgrade GI (Downgraded to the level using the same
GIPSUs they were upgraded from). More patch info is mentioned in the GI
upgrade category
|
To 12.1.0.2
|
None
|
N/A
|
N/A
|
To 12.1.0.1
|
None
|
N/A
|
N/A
|
To 11.2.0.4
|
None
|
N/A
|
N/A
|
|
No comments:
Post a Comment