在将Oracle GI和DB升级到19c或降级到以前的版本之前需要应用的补丁 (Doc ID 2668071.1)

 
 

文档内容

  用途
  适用范围
  详细信息
  Linux x86-64
  升级 GI 到  19c
  升级 DB 到 19c
  在19c的GI上面运行低版本的数据库时
  从19c降级时
  降级 19c GI
  Solaris Sparc 64 bit
  升级GI到 19c
  升级DB到19c
  在19c的GI上面运行低版本的数据库时
  从19c DB降级时
  降级 19c GI
  AIX PPC64
  升级 GI 到 19c
  升级 DB 到19c
  在19c的GI上面运行低版本的数据库时
  从19c DB降级时
  降级 19c GI
  HPUX IA64
  升级 GI 到 19c
  升级 DB 到 19c
  在19c的GI上面运行低版本的数据库时

适用于:

Oracle Database - Enterprise Edition - 版本 19.1.0.0.0 和更高版本
本文档所含信息适用于所有平台

用途

本文档列出了需要检查的事项，需要避免的已知问题和需要考虑的方面，以便可以顺利升级到19c Grid Infrastructure和Oracle Database，并保留降级功能。

适用范围

本文档适用于Oracle Clusterware管理员，Oracle数据库管理员和Oracle支持工程师。

详细信息

与先前版本进行升级，降级和共存的一次性补丁程序列表

Linux x86-64

升级 GI 到  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 到 19c

注意: 如果DB是运行在GI只上的那么需要下面的补丁

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

在19c的GI上面运行低版本的数据库时

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

从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

降级 19c GI

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到 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 11.2.0.4 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到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)  

在19c的GI上面运行低版本的数据库时

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

从19c DB降级时

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

降级 19c GI

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

AIX PPC64

升级 GI 到 19c

From Release

Bug#(s)

Patch

Description

Additional comments

18c

 None None

None

 None

12.2.0.1.0

 27006180     Fix included in GIPSU 12.2.0.1.180417

12.1.0.2

 

21255373

Recommended to install latest 12.1.0.2 GI PSU

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

升级 DB 到19c

From Release

Bug#(s)

Patch

Description

Additional comments

18c

 None None

None

 None

12.2.0.1.0

 27006180     Fix included in GIPSU 12.2.0.1.180417

12.1.0.2

 

21255373

Fix included in GIPSU12.1.0.2.171017 and latest

11.2.0.4

17617807

21255373

GI PSU 22646198

11.2.0.4.160419 (Apr 2016) Grid Infrastructure Patch Set Update (GI PSU)

  

在19c的GI上面运行低版本的数据库时

With Release

Bug#(s)

Patch

Description

Additional comments

18c DB

 None None

None

 None

12.2.0.1 DB

 None None

None

 None

从19c DB降级时

To Release

Bug#(s)

Patch

Description

Additional comments

18c

None

 None None None
         

降级 19c GI

To 12.2.0.1

None

None

None

None

 ==============

HPUX IA64

升级 GI 到 19c

From Release

Bug#(s)

Patch

Description

Additional comments

18c

 None None

None

 None

12.2.0.1.0

       Patch is available for HPUX.IA64

12.1.0.2

 

21255373

Fix included in GIPSU12.1.0.2.190115 and latest

20948770

    

Patch is available for HPUX.IA64

11.2.0.4

21255373

Recommended to install latest* 11.2.0.4 GI PSU

升级 DB 到 19c

From Release

Bug#(s)

Patch

Description

Additional comments

18c

 None None

None

 None

12.2.0.1.0

 27006180     Patch is available for HPUX.IA64

12.1.0.2

 

21255373

Fix included in GIPSU12.1.0.2.190115 and latest

20948770

    

Patch is available for HPUX.IA64

11.2.0.4

21255373

  

在19c的GI上面运行低版本的数据库时

With Release

Bug#(s)

Patch

Description

Additional comments

18c DB

 None None

None

 None
 
【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/sky2088/p/13330274.html