-------------------------------------------------------------------

欢迎关注作者

墨天伦:潇湘秦的个人主页 - 墨天轮
CSDN:潇湘秦-CSDN博客

公众号:潇湘秦

-------------------------------------------------------------------

oracle数据库升级路线图11.2.0.4是可以直接升级到19c的最低版本,更低的版本需要先升级到11.2.0.4,再升级至19c;而跳票好久的23c只能由19c和21c直接升级​;按惯例下个月23c应该会release​。

PS 12.1.0.1不可以直接升级到19c,这个版本应该极少有人用

 oracle 19c升级最佳实践 可以搜索我墨天伦​:潇湘秦 的资源

参考官方文档

Table 1-1 Examples of Upgrade Paths for Oracle Database 23c​

Current ReleaseUpgrade Options

21c, 19c (all releases)

Direct upgrade is supported. Perform the upgrade using the current Oracle Database Upgrade Guide, which is this guide.

18c

12.2

12.1.0.2.

12.1.0.1

11.2.0.1, 11.2.0.2, 11.2.0.3, 11.2.0.4

11.1.0.6, 11.1.0.7

10.2 or earlier releases

Direct upgrade to Oracle Database 23c is not supported.

Solution: Upgrade to an intermediate Oracle Database release that can be directly upgraded to the current release. Upgrade Oracle Database releases that are not supported for direct upgrade in this release to an intermediate Oracle Database release that is supported for direct upgrade.

When upgrading to an intermediate Oracle Database release, follow the instructions in the intermediate release documentation, including running the preupgrade scripts for that intermediate release. After you complete an upgrade to the intermediate release Oracle Database, you can upgrade the intermediate release database to the current Oracle Database release.

This restriction does not apply if you use Oracle Data Pump export/import to migrate data to the new release.

For example:

  • Releases 12.2.0.1, 12.2.0.2. 12.2.0.3, 12.2.0.4, 18c: Upgrade to Oracle Database 21c, and then upgrade to Oracle Database 23c.

  • Releases 12.1.0.1, 12.1.0.2, 11.2.0.3, 11.2.0.4: Upgrade to Oracle Database 12c Release 2 (12.2), upgrade to Oracle Database 21c, and then upgrade to Oracle Database 23c.

Note: Always update to the most recent intermediate release to which you can upgrade directly. Your case can be different from that of the examples provided here.

Table 1-1 Examples of Upgrade Paths for Oracle Database 19c

Current ReleaseUpgrade Options

​18 (all releases), 12.2.0.1, 12.1.0.2, 11.2.0.4

Direct upgrade is supported. Perform the upgrade using the current Oracle Database Upgrade Guide, which is this guide.

12.1.0.1

11.2.0.1, 11.2.0.2, 11.2.0.3

11.1.0.6, 11.1.0.7

10.2 or earlier releases

Direct upgrade to Oracle Database 19c is not supported.

Solution: Upgrade to an intermediate Oracle Database release that can be directly upgraded to the current release. Upgrade Oracle Database releases that are not supported for direct upgrade in this release to an intermediate Oracle Database release that is supported for direct upgrade.

When upgrading to an intermediate Oracle Database release, follow the instructions in the intermediate release documentation, including running the preupgrade scripts for that intermediate release. After you complete an upgrade to the intermediate release Oracle Database, you can upgrade the intermediate release database to the current Oracle Database release.

This restriction does not apply if you use Oracle Data Pump export/import to migrate data to the new release.

For example:

  • If you are upgrading from release 11.2.0.2 or 11.1.0.7, then you must first upgrade to the terminal patch set release for Oracle Database 11g release 2 (11.2.0.4), which is supported for direct upgrade to Oracle Database 19c.

  • If you are upgrading from release 10.2.0.2, 10.2.0.3, 10.2.0.4,10.2.0.5 or 10.1.0.5, then you must first upgrade to release 11.2. or 12.1

  • If you are upgrading from release 9.2.0.8, then you must first upgrade to a sequence of intermediate Oracle Database releases:

    Upgrade from release 9.2.0.8 to release 11.2.0.4. Then upgrade from release 11.2 to 19c

    Note: Always update to the most recent intermediate release to which you can upgrade directly. Your case can be different from that of the examples provided here.

Logo

魔乐社区(Modelers.cn) 是一个中立、公益的人工智能社区,提供人工智能工具、模型、数据的托管、展示与应用协同服务,为人工智能开发及爱好者搭建开放的学习交流平台。社区通过理事会方式运作,由全产业链共同建设、共同运营、共同享有,推动国产AI生态繁荣发展。

更多推荐