In this Document
APPLIES TO:
Oracle Database - Enterprise Edition - Version 11.2.0.3 to 12.1.0.2 [Release 11.2 to 12.1]Oracle Database - Enterprise Edition - Version 12.2.0.1 to 12.2.0.1 [Release 12.2]Information in this document applies to any platform.
PURPOSE
This document lists things to check, known issues to avoid, and areas to consider to have smooth upgrade to 12.2.0.1 Grid Infrastructure and Oracle Database and to Preserve Downgrade capability.
SCOPE
This document is intended for Oracle Clusterware Administrators, Oracle Database Administrators and Oracle Support engineers.
DETAILS
Grid Infrastructure and Database Upgrade steps for Exadata Database Machine running 11.2.0.3 and later on Oracle Linux
Refer to 12.2 Grid Infrastructure and Database Upgrade steps for Exadata Database Machine running 11.2.0.3 and later on Oracle Linux (
Note 2111010.1)
List of One-off patches for Upgrades, Downgrades and Co-existence with previous release
Linux x86-64
GI Upgrade to 12.2.0.1
| From Release | Bug#(s) | Patch | Description | Additional comments |
| 12.1.0.2 | 21255373 | 22646084 | 12.1.0.2.160419 (Apr 2016) Grid Infrastructure Patch Set Update (GI PSU) | Fix included in OCWPSU 12.1.0.2.160419
Recommended to install latest* 12.1.0.2 GI PSU. |
| 12.1.0.1 | 17617807 | 23580463 | MERGE REQUEST ON TOP OF OCW PSU 12.1.0.1.1 FOR BUGS 17617807 21255373 | On top of 12.1.0.1.1 |
| 21255373 |
| 11.2.0.4 | 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.4 GI PSU
Recommended to install latest* 11.2.0.4 GI PSU |
| 21255373 | included in 11.2.0.4.160419OCWPSU
Recommended to install latest* 11.2.0.4 GI PSU |
| 11.2.0.3 | 17617807 | 23580534 | MERGE REQUEST ON TOP OF GRID INFRASTRUCTURE PSU 11.2.0.3.9 FOR BUGS 17617807 21255373 | On top of 11.2.0.3.9 Clusterware patch |
| 21255373 |
DB Upgrades to 12.2.0.1
| From Release | Bug#(s) | Patch | Description | Additional comments |
| 12.1.0.2 | 21255373 | 22646084 | 12.1.0.2.160419 (Apr 2016) Grid Infrastructure Patch Set Update (GI PSU) | included in OCWPSU 12.1.0.2.160419
Recommended to install latest* 12.1.0.2 GI PSU |
| 12.1.0.1 | 17617807 | 23580463 | MERGE REQUEST ON TOP OF OCW PSU 12.1.0.1.1 FOR BUGS 17617807 21255373 | Available on top of 12.1.0.1.1 |
| 21255373 |
| 11.2.0.4 | 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.4 GI PSU
Recommended to install latest* 11.2.0.4 GI PSU |
| 21255373 | included in 11.2.0.4.160419OCWPSU
Recommended to install latest* 11.2.0.4 GI PSU |
| 11.2.0.3 | 17617807 | 23580534 | MERGE REQUEST ON TOP OF GRID INFRASTRUCTURE PSU 11.2.0.3.9 FOR BUGS 17617807 21255373 | Available on top of 11.2.0.3.9 Clusterware patch |
| 21255373 |
Managing older database versions with 12.2.0.1 ASM
| With Release | Bug#(s) | Patch | Description | Additional comments |
| 12.1.0.2 DB | 21626377 | 21626377 | 12.2_150812: DBCA FAILS TO CREATE 12102 DB OVER 12.2 GI/ASM | |
| 21780146 | 21780146 | LNX64-12.2-WLM: MGMTDB FAILED TO BE CREATED DURING POST GI INSTALLATION | |
| | | | | |
| 12.1.0.1 DB | 21626377 | 21626377 | 12.2_150812: DBCA FAILS TO CREATE 12102 DB OVER 12.2 GI/ASM | Available on top of 12.1.0.1.0 |
| 23519414 | 23186035 | W2K12_122_CMP: CREATE 11204DB WITH 122 ENV AFTER 1120419DBBP HIT ORA-00955 | Available on top of 12.1.0.1.0
Note:Bug 23519414 is duplicate of Bug 23186035 (unpublished) |
| 21780146 | 21780146 | LNX64-12.2-WLM: MGMTDB FAILED TO BE CREATED DURING POST GI INSTALLATION | Available on top of 12.1.0.1.0 |
| | | | | |
| 11.2.0.4 DB | 23519414 | 23186035 | W2K12_122_CMP: CREATE 11204DB WITH 122 ENV AFTER 1120419DBBP HIT ORA-00955 | Available on top of 11.2.0.4.0
Note:Bug 23519414 is duplicate of Bug 23186035 (unpublished) |
| 11.2.0.3 DB | 23519414 | 23186035 | W2K12_122_CMP: CREATE 11204DB WITH 122 ENV AFTER 1120419DBBP HIT ORA-00955 | Available on top of 11.2.0.3.0 Oracle clusterware
Note:Bug 23519414 is duplicate of Bug 23186035 (unpublished) |
DB Downgrades from 12.2.0.1
| To Release | Bug#(s) | Patch | Description | Additional comments |
| 12.1.0.2 (with CDB) | 20594149 | 23273686 | Proactive Bundle Patch (12.1.0.2.160719) | Install latest* Proactive Bundle patch |
| 20898997 | 20898997 | XMLTYPESUP: QCTOXSNLB SHOULD NOT CHECK AGAINST SNAPSHOT SIZE | Available on n top of 12.1.0.2 |
| 20348910 | 20348910 | ALTER TYPE REPLACE IN PRVTAQJI.SQL TO BE REPLACE WITH CREATE OR REPLACE TYPE | Available on n top of 12.1.0.2
Available on n 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 | On top of 12.1.0.2.7 Proactive bundle patch |
| | | | | |
| 12.1.0.2(non-CDB) | 20594149 | 23273686 | Proactive Bundle Patch (12.1.0.2.160719) | Install latest Proactive Bundle patch |
| 21856522 | 21856522 | UPGRADE OF 12.1 TO 12.2 CAUSE XOQ COMPONENT TO BE INVALID | Available on top of 12.1.0.2 |
| 20898997 | 20898997 | XMLTYPESUP: QCTOXSNLB SHOULD NOT CHECK AGAINST SNAPSHOT SIZE | Available on top of 12.1.0.2 |
| 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 | On top of 12.1.0.2.7 Proactive bundle patch |
| | | | | |
| 12.1.0.1 (non-CDB) | 21951844 | 21951844 | DB PSU | Install Latest DB PSU |
| 20898997 | 20898997 | XMLTYPESUP: QCTOXSNLB SHOULD NOT CHECK AGAINST SNAPSHOT SIZE | Available on top of 12.1.0.2
Available on top of 12.1.0.2.7 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.1 |
| | | | | |
| 11.2.0.4 | 21948347 | 23054359 | | 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 | Not available for 11.2.0.4 |
| | | | | |
| 11.2.0.3 | 20299017 | 20760997 | | Latest DB PSU available is Patch 20760997 |
| 20898997 | 20898997 | XMLTYPESUP: QCTOXSNLB SHOULD NOT CHECK AGAINST SNAPSHOT SIZE | Available on top of 11.2.0.3
Available on top of 11.2.0.3.14 |
| 20348910 | 20348910 | ALTER TYPE REPLACE IN PRVTAQJI.SQL TO BE REPLACE WITH CREATE OR REPLACE TYPE | On top of 11.2.0.3 |
GI Downgrades from 12.2.0.1
| To 12.1.0.2 | 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.1 | None | N/A | N/A |
| To 11.2.0.4 | None | N/A | N/A |
| To 11.2.0.3 | | | |
Solaris Sparc 64 bit
GI Upgrades to 12.2.0.1
| From Release | Bug#(s) | Patch | Description | Additional comments |
| 12.1.0.2 | 21255373 | 22646084 | 12.1.0.2.160419 (Apr 2016) Grid Infrastructure Patch Set Update (GI PSU) | included in OCWPSU 12.1.0.2.160419
Recommended to install latest* 12.1.0.2 GI PSU |
| 12.1.0.1 | 17617807 | 23580463 | MERGE REQUEST ON TOP OF OCW PSU 12.1.0.1.1 FOR BUGS 17617807 21255373 | On top of 12.1.0.1.1 OCW PSU
Recommended to install latest* 12.1.0.1 GI PSU |
| 21255373 |
| 15881443 | 15881443 | DBCA FAILED TO START DB RESOURCE WITH ASM DISKGROUP | Available on top of 12.1.0.1.6 PSU
Available on top of 12.1.0.1.7 PSU |
| 11.2.0.4 | 17617807 | 19380115 | 11.2.0.4.4 GI PSU | included in GI PSU4 or later
Recommended to install latest* 11.2.0.4 GI PSU |
| 21255373 | 22646198 | 11.2.0.4.160419 (Apr 2016) Grid Infrastructure Patch Set Update (GI PSU) | included in 11.2.0.4.160419OCWPSU Recommended to install latest* 11.2.0.4 GI PSU |
| 11.2.0.3 | 17617807 | 23580534 | MERGE REQUEST ON TOP OF GRID INFRASTRUCTURE PSU 11.2.0.3.9 FOR BUGS 17617807 21255373 | Download on top of 11.2.0.3.9 GIPSU |
| 21255373 |
DB Upgrades to 12.2.0.1
| From Release | Bug#(s) | Patch | Description | Additional comments |
| 12.1.0.2 | | | | |
| 21255373 | 22646084 | 12.1.0.2.160419 (Apr 2016) Grid Infrastructure Patch Set Update (GI PSU) | included in OCWPSU 12.1.0.2.160419
Recommended to install latest* 12.1.0.2 GI PSU |
| 12.1.0.1 | 17617807 | 23580463 | MERGE REQUEST ON TOP OF OCW PSU 12.1.0.1.1 FOR BUGS 17617807 21255373 | On top of 12.1.0.1.1 OCW PSU
Recommended to install latest* 12.1.0.1 GI PSU |
| 21255373 |
| 15881443 | 15881443 | DBCA FAILED TO START DB RESOURCE WITH ASM DISKGROUP | Available on top of 12.1.0.1.1 PSU
Available on top of 12.1.0.1.7 PSU |
| 11.2.0.4 | 17617807 | 19380115 | 11.2.0.4.4 GI PSU | included in GI PSU4 or later
Recommended to install latest* 11.2.0.4 GI PSU |
| 21255373 | 22646198 | 11.2.0.4.160419 (Apr 2016) Grid Infrastructure Patch Set Update (GI PSU) | included in 11.2.0.4.160419OCWPSU Recommended to install latest* 11.2.0.4 GI PSU |
| 11.2.0.3 | 17617807 | 23580534 | MERGE REQUEST ON TOP OF GRID INFRASTRUCTURE PSU 11.2.0.3.9 FOR BUGS 17617807 21255373 | Download on top of 11.2.0.3.9 GIPSU |
| 21255373 |
Managing older database versions with 12.2.0.1 ASM
| With Release | Bug#(s) | Patch | Description | Additional comments |
| 12.1.0.2 DB | 21626377 | 21626377 | 12.2_150812: DBCA FAILS TO CREATE 12102 DB OVER 12.2 GI/ASM | Patch Available for Sol.Sparc64 |
| 21780146 | 21780146 | LNX64-12.2-WLM: MGMTDB FAILED TO BE CREATED DURING POST GI INSTALLATION | Patch Available for Sol.Sparc64 |
| | | | | |
| 12.1.0.1 DB | 21626377 | 21626377 | 12.2_150812: DBCA FAILS TO CREATE 12102 DB OVER 12.2 GI/ASM | Available on top of 12.1.0.1.0 |
| 21780146 | 21780146 | LNX64-12.2-WLM: MGMTDB FAILED TO BE CREATED DURING POST GI INSTALLATION | Available on top of 12.1.0.1.0 |
| 15881443 | 15881443 | DBCA FAILED TO START DB RESOURCE WITH ASM DISKGROUP | Available on top of 12.1.0.1.6 PSU
Available on top of 12.1.0.1.7 PSU |
| 23186035 | 23186035 | W2K12_122_CMP: CREATE 11204DB WITH 122 ENV AFTER 1120419DBBP HIT ORA-00955 | Available on top of 12.1.0.1.0 |
| | | | | |
| 11.2.0.4 DB | 23186035 | 23186035 | W2K12_122_CMP: CREATE 11204DB WITH 122 ENV AFTER 1120419DBBP HIT ORA-00955 | Available on top of 11.2.0.4.0 |
| 11.2.0.3 DB | 13460353 | 13460353 | REGISTRATION OF 11.2.0.3 DATABASE FAILS AGAINST 12.1 CRS STACK | Available on top of 11.2.0.3.0 |
| | 23186035 | 23186035 | W2K12_122_CMP: CREATE 11204DB WITH 122 ENV AFTER 1120419DBBP HIT ORA-00955 | Available on top of 11.2.0.3.0 Oracle Clusterware |
DB Downgrades from 12.2.0.1
| To Release | Bug#(s) | Patch | Description | Additional comments |
| 12.1.0.2 (with CDB) | 20594149 | 23273686 | Proactive Bundle Patch (12.1.0.2.160719) | Install latest* Proactive Bundle patch |
| 20898997 | 20898997 | XMLTYPESUP: QCTOXSNLB SHOULD NOT CHECK AGAINST SNAPSHOT SIZE | Available on n top of 12.1.0.2 |
| 20348910 | 20348910 | ALTER TYPE REPLACE IN PRVTAQJI.SQL TO BE REPLACE WITH CREATE OR REPLACE TYPE | Available on n top of 12.1.0.2
Available on n 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 | On top of 12.1.0.2.7 Proactive bundle patch |
| | | | |
| | | | | |
| 12.1.0.2(non-CDB) | 20594149 | 23273686 | Proactive Bundle Patch (12.1.0.2.160719) | Install latest Proactive Bundle patch |
| 20898997 | 20898997 | XMLTYPESUP: QCTOXSNLB SHOULD NOT CHECK AGAINST SNAPSHOT SIZE | Available on top of 12.1.0.2 |
| 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 | On top of 12.1.0.2.7 Proactive bundle patch |
| 21856522 | 21856522 | UPGRADE OF 12.1 TO 12.2 CAUSE XOQ COMPONENT TO BE INVALID | Available on top of 12.1.0.2 |
| | | | | |
| 12.1.0.1 (non-CDB) | 21951844 | DB PSU | Install Latest DB PSU | 21951844 |
| 20898997 | 20898997 | XMLTYPESUP: QCTOXSNLB SHOULD NOT CHECK AGAINST SNAPSHOT SIZE | Available on top of 12.1.0.2
Available on top of 12.1.0.2.7 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.1 |
| | | | | |
| 11.2.0.4 | 21948347 | 23054359 | DB PSU 11.2.0.4.160719 | 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 | Not available for 11.2.0.4 |
| | | | | |
| 11.2.0.3 | 20299017 | 20760997 | DB PSU 11.2.0.3.15 | Latest DB PSU available is Patch 20760997 |
| 20898997 | 20898997 | XMLTYPESUP: QCTOXSNLB SHOULD NOT CHECK AGAINST SNAPSHOT SIZE | Available on top of 11.2.0.3 |
| 20348910 | 20348910 | ALTER TYPE REPLACE IN PRVTAQJI.SQL TO BE REPLACE WITH CREATE OR REPLACE TYPE | On top of 11.2.0.3 |
| | | | |
GI Downgrades from 12.2.0.1
| To 12.1.0.2 | 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.1 | None | N/A | N/A |
| To 11.2.0.4 | None | N/A | N/A |
| To 11.2.0.3 | | | |
Solaris Intel 64 bit
GI Upgrades to 12.2.0.1
| From Release | Bug#(s) | Patch | Description | Additional comments |
| 12.1.0.2 | 21255373 | 22646084 | 12.1.0.2.160419 (Apr 2016) Grid Infrastructure Patch Set Update (GI PSU) | included in OCWPSU 12.1.0.2.160419
Recommended to install latest* 12.1.0.2 GI PSU |
| 12.1.0.1 | 17617807 | 23580463 | MERGE REQUEST ON TOP OF OCW PSU 12.1.0.1.1 FOR BUGS 17617807 21255373 | On top of 12.1.0.1.1 OCW PSU
Recommended to install latest* 12.1.0.1 GI PSU |
| 21255373 |
| 15881443 | 15881443 | DBCA FAILED TO START DB RESOURCE WITH ASM DISKGROUP | Available on top of 12.1.0.1.6 PSU
Available on top of 12.1.0.1.7 PSU |
| 11.2.0.4 | 17617807 | 19380115 | 11.2.0.4.4 GI PSU | included in GI PSU4 or later
Recommended to install latest* 11.2.0.4 GI PSU |
| 21255373 | 22646198 | 11.2.0.4.160419 (Apr 2016) Grid Infrastructure Patch Set Update (GI PSU) | included in 11.2.0.4.160419OCWPSU Recommended to install latest* 11.2.0.4 GI PSU |
| 11.2.0.3 | 17617807 | 23580534 | MERGE REQUEST ON TOP OF GRID INFRASTRUCTURE PSU 11.2.0.3.9 FOR BUGS 17617807 21255373 | Download on top of 11.2.0.3.9 GIPSU |
| 21255373 |
DB Upgrades to 12.2.0.1
| From Release | Bug#(s) | Patch | Description | Additional comments |
| 12.1.0.2 | | | | |
| 21255373 | 22646084 | 12.1.0.2.160419 (Apr 2016) Grid Infrastructure Patch Set Update (GI PSU) | included in OCWPSU 12.1.0.2.160419
Recommended to install latest* 12.1.0.2 GI PSU |
| 12.1.0.1 | 17617807 | 23580463 | MERGE REQUEST ON TOP OF OCW PSU 12.1.0.1.1 FOR BUGS 17617807 21255373 | On top of 12.1.0.1.1 OCW PSU
Recommended to install latest* 12.1.0.1 GI PSU |
| 21255373 |
| 15881443 | 15881443 | DBCA FAILED TO START DB RESOURCE WITH ASM DISKGROUP | Available on top of 12.1.0.1.6 PSU
Available on top of 12.1.0.1.7 PSU |
| 11.2.0.4 | 17617807 | 19380115 | 11.2.0.4.4 GI PSU | included in GI PSU4 or later
Recommended to install latest* 11.2.0.4 GI PSU |
| 21255373 | 22646198 | 11.2.0.4.160419 (Apr 2016) Grid Infrastructure Patch Set Update (GI PSU) | included in 11.2.0.4.160419OCWPSU Recommended to install latest* 11.2.0.4 GI PSU |
| 11.2.0.3 | 17617807 | 23580534 | MERGE REQUEST ON TOP OF GRID INFRASTRUCTURE PSU 11.2.0.3.9 FOR BUGS 17617807 21255373 | Download on top of 11.2.0.3.9 GIPSU |
| 21255373 |
Managing older database versions with 12.2.0.1 ASM
| With Release | Bug#(s) | Patch | Description | Additional comments |
| 12.1.0.2 DB | 21626377 | 21626377 | 12.2_150812: DBCA FAILS TO CREATE 12102 DB OVER 12.2 GI/ASM | Patch Available for Sol.Sparc64 |
| 21780146 | 21780146 | LNX64-12.2-WLM: MGMTDB FAILED TO BE CREATED DURING POST GI INSTALLATION | Patch Available for Sol.Sparc64 |
| | | | | |
| 12.1.0.1 DB | 21626377 | 21626377 | 12.2_150812: DBCA FAILS TO CREATE 12102 DB OVER 12.2 GI/ASM | Available on top of 12.1.0.1.0 |
| 21780146 | 21780146 | LNX64-12.2-WLM: MGMTDB FAILED TO BE CREATED DURING POST GI INSTALLATION | Available on top of 12.1.0.1.0 |
| 15881443 | 15881443 | DBCA FAILED TO START DB RESOURCE WITH ASM DISKGROUP | Available on top of 12.1.0.1.6 PSU
Available on top of 12.1.0.1.7 PSU |
| 23186035 | 23186035 | W2K12_122_CMP: CREATE 11204DB WITH 122 ENV AFTER 1120419DBBP HIT ORA-00955 | Available on top of 12.1.0.1.0 |
| | | | | |
| 11.2.0.4 DB | 23186035 | 23186035 | W2K12_122_CMP: CREATE 11204DB WITH 122 ENV AFTER 1120419DBBP HIT ORA-00955 | Available on top of 11.2.0.4.0 |
| 11.2.0.3 DB | 13460353 | 13460353 | REGISTRATION OF 11.2.0.3 DATABASE FAILS AGAINST 12.1 CRS STACK | Available on top of 11.2.0.3.0 |
| | 23186035 | 23186035 | W2K12_122_CMP: CREATE 11204DB WITH 122 ENV AFTER 1120419DBBP HIT ORA-00955 | Available on top of 11.2.0.3.0 Oracle Clusterware |
DB Downgrades from 12.2.0.1
| To Release | Bug#(s) | Patch | Description | Additional comments |
| 12.1.0.2 (with CDB) | 20594149 | 23273686 | Proactive Bundle Patch (12.1.0.2.160719) | Install latest* Proactive Bundle patch |
| 20898997 | 20898997 | XMLTYPESUP: QCTOXSNLB SHOULD NOT CHECK AGAINST SNAPSHOT SIZE | Available on n top of 12.1.0.2 |
| 20348910 | 20348910 | ALTER TYPE REPLACE IN PRVTAQJI.SQL TO BE REPLACE WITH CREATE OR REPLACE TYPE | Available on n top of 12.1.0.2
Available on n 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 | On top of 12.1.0.2.7 Proactive bundle patch |
| | | | |
| | | | | |
| 12.1.0.2(non-CDB) | 20594149 | 23273686 | Proactive Bundle Patch (12.1.0.2.160719) | Install latest Proactive Bundle patch |
| 20898997 | 20898997 | XMLTYPESUP: QCTOXSNLB SHOULD NOT CHECK AGAINST SNAPSHOT SIZE | Available on top of 12.1.0.2 |
| 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 | On top of 12.1.0.2.7 Proactive bundle patch |
| 21856522 | 21856522 | UPGRADE OF 12.1 TO 12.2 CAUSE XOQ COMPONENT TO BE INVALID | Available on top of 12.1.0.2 |
| | | | | |
| 12.1.0.1 (non-CDB) | 21951844 | DB PSU | Install Latest DB PSU | 21951844 |
| 20898997 | 20898997 | XMLTYPESUP: QCTOXSNLB SHOULD NOT CHECK AGAINST SNAPSHOT SIZE | Available on top of 12.1.0.2
Available on top of 12.1.0.2.7 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.1 |
| | | | | |
| 11.2.0.4 | 21948347 | 23054359 | DB PSU 11.2.0.4.160719 | 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 | Not available for 11.2.0.4 |
| | | | | |
| 11.2.0.3 | 20299017 | 20760997 | DB PSU 11.2.0.3.15 | Latest DB PSU available is Patch 20760997 |
| 20898997 | 20898997 | XMLTYPESUP: QCTOXSNLB SHOULD NOT CHECK AGAINST SNAPSHOT SIZE | Available on top of 11.2.0.3 |
| 20348910 | 20348910 | ALTER TYPE REPLACE IN PRVTAQJI.SQL TO BE REPLACE WITH CREATE OR REPLACE TYPE | On top of 11.2.0.3 |
| | | | |
GI Downgrades from 12.2.0.1
| To 12.1.0.2 | 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.1 | None | N/A | N/A |
| To 11.2.0.4 | None | N/A | N/A |
| To 11.2.0.3 | | | |
Windows X64
GI Upgrade to 12.2.0.1
| From Release | Bug#(s) | Patch | Description | Additional comments |
| 12.1.0.2 | 21255373 | 22809813 or later | WINDOWS DB BUNDLE PATCH 12.1.0.2.160419 | Recommended to install WINDBBP 12.1.0.2.160531 patch NO. 22809813 or Later |
| 12.1.0.1 | 23081828 | Fixes included in Bundle patch 12.1.0.1.160719 |
| 1) First apply WINDBBP 12.1.0.1.160719
2) Next apply Patch 21255373 on TOP of WINDBBP 12.1.0.1.160719 |
| 19234907 |
| 17617807 |
| 21255373 | 21255373 | CSSD : DUPLICATE RESPONSE IN GROUP DATA UPDATE |
| 11.2.0.4 | 17617807 | Patch 22839608 or later | Windows Bundle patch | Install latest Windows BP patch to get all the fixes |
| 21691487 |
| 19234907 |
| 21255373 |
| 11.2.0.3 | 17617807 | 25509398 | MERGE REQUEST ON TOP OF 11.2.0.3.0 FOR BUGS 17168126,17500165,19234907,21255373 | Contact Oracle support to get the patch.
|
| 19234907 |
| 21255373 |
DB Upgrades to 12.2.0.1
| From Release | Bug#(s) | Patch | Description | Additional comments |
| 12.1.0.2 | 21255373 | NA | NA | Patch NOT required |
| 12.1.0.1 | 17617807 | 21744907 | Windows BP 12.1.0.1.21 | Install Patch 21744907 or latest Bundle patch |
| 21255373 |
| 11.2.0.4 | NA | NA | NA | Patch NOT required |
| 11.2.0.3 | 17617807 | 25509398 | MERGE REQUEST ON TOP OF 11.2.0.3.0 FOR BUGS 17168126,17500165,19234907,21255373 | Contact Oracle support to get the patch.
|
Managing older database versions with 12.2.0.1 ASM
| With Release | Bug#(s) | Patch | Description | Additional comments |
| 12.1.0.2 DB | 21626377 | 24345625 | WINDOWS DB BUNDLE PATCH 12.1.0.2.160831 | Install 12.1.0.2.160831 Windows BP or later |
| 20007009 |
| 12.1.0.1 DB | NA | 23530410 | WINDOWS DB BUNDLE PATCH 12.1.0.1.160719 | Install Patch 23530410 or latest Windows BP |
| 11.2.0.4 DB | NA | NA | NA | Patch NOT required |
| 11.2.0.3 DB | NA | NA | NA | Patch NOT required |
DB Downgrades from 12.2.0.1
| To Release | Bug#(s) | Patch | Description | Additional comments |
| 12.1.0.2 (with CDB) | 20898997 | 23530387 | WINDOWS DB BUNDLE PATCH 12.1.0.2.160719 | Install Patch 23530387 or latest Windows Bundle patch |
| 20958816 |
| 12.1.0.2(non-CDB) | 20898997 | 23530387 | WINDOWS DB BUNDLE PATCH 12.1.0.2.160719 | Install Patch 23530387 or latest Windows Bundle patch |
| 12.1.0.1 (non-CDB) | 20898997 | 23530387 | WINDOWS DB BUNDLE PATCH 12.1.0.2.160719 | Install Patch 23530387 or latest Windows Bundle patch |
| 20348910 | 20348910 | ALTER TYPE REPLACE IN PRVTAQJI.SQL TO BE REPLACE WITH CREATE OR REPLACE TYPE | Available on top of 12.1.0.1 |
| 11.2.0.4 | 20898997 | 23530387 | WINDOWS DB BUNDLE PATCH 12.1.0.2.160719 | Install Patch 23530387 or latest Windows Bundle patch |
| 11.2.0.3 | 20898997 | 23530387 | WINDOWS DB BUNDLE PATCH 12.1.0.2.160719 | Install Patch 23530387 or latest Windows Bundle patch |
AIX
GI Upgrade to 12.2.0.1
| From Release | Bug#(s) | Patch | Description | Additional comments |
| 12.1.0.2 | 21255373 | 22646084 | 12.1.0.2.160419 (Apr 2016) Grid Infrastructure Patch Set Update (GI PSU) | Recommended to install latest* 12.1.0.2 GI PSU. |
| 12.1.0.1 | 17617807
21255373
15881443 | 25427122 | MERGE REQUEST ON TOP OF 12.1.0.1.0 FOR BUGS 17617807, 21255373, 15881443 | On top of 12.1.0.1.0 |
| 17960940 | 17960940 | AIX: ASSERTION IN KSFREE (DO_NOT_SHIP BUILD ONLY) | On top of 12.1.0.1.0 |
| 11.2.0.4 | 17617807 | GI PSU 24436338 | 11.2.0.4.161018 (OCT2016) Grid Infrastructure Patch Set Update (GI PSU) |
Recommended to install latest* 11.2.0.4 GI PSU |
| 21255373 | Recommended to install latest* 11.2.0.4 GI PSU |
| 11.2.0.3 | 17617807 | 24934122 | MERGE REQUEST ON TOP OF GRID INFRASTRUCTURE PSU 11.2.0.3.9 FOR BUGS 13604285 | On top of 11.2.0.3.9 Clusterware patch |
| 21255373 |
DB Upgrades to 12.2.0.1
| From Release | Bug#(s) | Patch | Description | Additional comments |
| 12.1.0.2 | 21255373 | 21523234 | 12.1.0.2.5 (Oct 2015) Grid Infrastructure Patch Set Update (GI PSU) | Recommended to install latest* 12.1.0.2 GI PSU |
| 12.1.0.1 | 17617807
21255373
15881443 | 25427122 | MERGE REQUEST ON TOP OF 12.1.0.1.0 FOR BUGS 17617807, 21255373, 15881443 | Available on top of 12.1.0.1.1 |
| 11.2.0.4 | 17617807 | GI PSU 24436338 | 11.2.0.4.161018 (OCT2016) Grid Infrastructure Patch Set Update (GI PSU) | Recommended to install latest* 11.2.0.4 GI PSU |
| 21255373 | Recommended to install latest* 11.2.0.4 GI PSU |
| 11.2.0.3 | 17617807 | 24934122 | MERGE REQUEST ON TOP OF GRID INFRASTRUCTURE PSU 11.2.0.3.9 FOR BUGS 13604285 | Available on top of 11.2.0.3.9 Clusterware patch |
| 21255373 |
Managing older database versions with 12.2.0.1 ASM
| With Release | Bug#(s) | Patch | Description | Additional comments |
| 12.1.0.2 DB | 21626377 | 21626377 | 12.2_150812: DBCA FAILS TO CREATE 12102 DB OVER 12.2 GI/ASM | Available on top of 12.1.0.2 |
| 12.1.0.1 DB | 21626377 | 21626377 | 12.2_150812: DBCA FAILS TO CREATE 12102 DB OVER 12.2 GI/ASM | Available on top of 12.1.0.1.0 |
| 11.2.0.4 DB | None | NA | NA | NA |
DB Downgrades from 12.2.0.1
| To Release | | Bug#(s) | Patch | Description | Additional comments |
| 12.1.0.2 (with CDB) | | 20594149 | 23273686 | Proactive Bundle Patch (12.1.0.2.160719) | Install latest* Proactive Bundle patch |
| | 20898997 | 20898997 | XMLTYPESUP: QCTOXSNLB SHOULD NOT CHECK AGAINST SNAPSHOT SIZE | Available on n top of 12.1.0.2 |
| | 20348910 | 20348910 | ALTER TYPE REPLACE IN PRVTAQJI.SQL TO BE REPLACE WITH CREATE OR REPLACE TYPE | Available on n top of 12.1.0.2
Available on n 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 | On top of 12.1.0.2.7 Proactive bundle patch |
| | | | | | |
| 11.2.0.4 | | 21948347 | 23054359 | | 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 | Not available for 11.2.0.4 |
HPUX IA64
GI Upgrade to 12.2.0.1
| From Release | Bug#(s) | Patch | Description | Additional comments |
| 12.1.0.2 | 20948770
21255373 | 20948770 | TACKING BUG TO COMPLETE PORT SPECIFIC BLR CHANGES FOR BUG-19622096 | 21255373 is included in GIPSU12.1.0.2.160719 or later |
| 12.1.0.1 | 17617807
21255373
15881443 | 25427122 | MERGE REQUEST ON TOP OF 12.1.0.1.0 FOR BUGS 17617807, 21255373, 15881443 | On top of 12.1.0.1.0 |
| 11.2.0.4 | 21255373 | GI PSU 23274134 | 11.2.0.4.160719 (JUL2016) Grid Infrastructure Patch Set Update (GI PSU) | |
| Recommended to install latest* 11.2.0.4 GI PSU |
| 11.2.0.3 | 17617807 | 24934122 | MERGE REQUEST ON TOP OF GRID INFRASTRUCTURE PSU 11.2.0.3.9 FOR BUGS 13604285 | On top of 11.2.0.3.9 Clusterware patch |
| 21255373 |
DB Upgrades to 12.2.0.1
| From Release | Bug#(s) | Patch | Description | Additional comments |
| 12.1.0.2 | 21255373
20948770 | 21523234
20948770 | 12.1.0.2.5 (Oct 2015) Grid Infrastructure Patch Set Update (GI PSU)
TACKING BUG TO COMPLETE PORT SPECIFIC BLR CHANGES FOR BUG-19622096 | Recommended to install latest* 12.1.0.2 GI PSU
Patch is available for HPUX.IA64 |
| 12.1.0.1 | 17617807
21255373
15881443 | 25427122 | MERGE REQUEST ON TOP OF 12.1.0.1.0 FOR BUGS 17617807, 21255373, 15881443 | Available on top of 12.1.0.1.1 |
| 11.2.0.4 | 21255373 | GI PSU 24436338 | 11.2.0.4.161018 (OCT2016) Grid Infrastructure Patch Set Update (GI PSU) | |
| 21255373 is included in GIPSU12.1.0.2.160719 or later |
| 11.2.0.3 | 17617807 | 24934122 | MERGE REQUEST ON TOP OF GRID INFRASTRUCTURE PSU 11.2.0.3.9 FOR BUGS 13604285 | Available on top of 11.2.0.3.9 Clusterware patch |
| 21255373 |
Managing older database versions with 12.2.0.1 ASM
| With Release | Bug#(s) | Patch | Description | Additional comments |
| 12.1.0.2 DB | 21626377 | 21626377 | 12.2_150812: DBCA FAILS TO CREATE 12102 DB OVER 12.2 GI/ASM | Available on top of 12.1.0.2 |
DB Downgrades from 12.2.0.1
| To Release | | Bug#(s) | Patch | Description | Additional comments |
| 12.1.0.2 (with CDB) | | 20594149 | 23273686 | Proactive Bundle Patch (12.1.0.2.160719) | Install latest* Proactive Bundle patch |
| | 20898997 | 20898997 | XMLTYPESUP: QCTOXSNLB SHOULD NOT CHECK AGAINST SNAPSHOT SIZE | Available on n top of 12.1.0.2 |
| | 20348910 | 20348910 | ALTER TYPE REPLACE IN PRVTAQJI.SQL TO BE REPLACE WITH CREATE OR REPLACE TYPE | Available on n top of 12.1.0.2
Available on n 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 | On top of 12.1.0.2.7 Proactive bundle patch |
| | | | | | |
| 11.2.0.4 | | 21948347 | 23054359 | | 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 | Not available for 11.2.0.4 |
No comments:
Post a Comment