Skip to Main Content

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, Bill.

Asked: March 04, 2019 - 1:37 pm UTC

Last updated: March 06, 2019 - 2:20 pm UTC

Version: 10gR2

Viewed 1000+ times

You Asked

Hey folks,

We have been stuck on 10g for a while (couldn't migrate off forms and reports apps) and now find we are positioned to drop our forms & reports. We're looking to migrate the db from 10g to 18. Has anyone done this kind of a jump before? Any gotchas we can look for ahead of time as we plan this? We don't have a lot of special features.

Thanks much!

and Chris said...

I'm not aware of anyone taking this route. I'm sure someone has or will eventually though. Hopefully some commenters can shed some light on this.

Perhaps the biggest challenge you have is we've never supported compatibility between 10g and 18c. This means that an 18c client may not work against a 10g database. And vice-versa.

It also means you can't upgrade direct from 10g -> 18c. This falls under the class of a "multi-step" upgrade. As the docs say:

For any multi-step upgrade, if you must carry out two upgrades to upgrade to the current release, then you must run the preupgrade script twice: First, for the intermediate upgrade release, and second, for the target upgrade target release.

For example, if the database from which you are upgrading is running Oracle Database 10g, then follow these steps:

Upgrade release 10.2.0.5 to release 12.1.0.2 using the instructions in Oracle Database Upgrade Guide 12c Release 1 (12.1), including running the pre-upgrade script for 12.1.0.2.

Upgrade Oracle Database 12c release 1 (12.1.0.2) directly to Oracle Database 18c. Use the instructions in this book, Oracle Database Upgrade Guide, including running the preupgrade script for 18.1.

https://docs.oracle.com/en/database/oracle/oracle-database/18/upgrd/oracle-database-releases-that-support-direct-upgrade.html#GUID-7AA90913-D8AB-4EBA-944F-31FA01D6BE5D

So you probably want to check out the Upgrade Guide for both 12c and 18c:

https://docs.oracle.com/en/database/oracle/oracle-database/18/upgrd/index.html
https://docs.oracle.com/database/121/UPGRD/toc.htm

If you want to do this in one pass, you're looking at (datapump) export/import.

If you're looking for more gotchas and advice on upgrading, check out Mike Dietrich's blog:

https://mikedietrichde.com/

Also be aware that 12c added multitenant. Which is the biggest architectural change to Oracle Database in aaaages. So it's worth spending some time learning about this and deciding whether you want to switch to it during this upgrade:

https://www.oracle.com/database/technologies/multitenant.html

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Thanks for the information!

Bill S., March 06, 2019 - 2:10 pm UTC

Our plan was not to "upgrade" but to migrate - actually just import schemas into a new 18 database from our 10g exports. So the links will be most helpful. :-)

Appreciate your consideration of this question!

Chris Saxon
March 06, 2019 - 2:20 pm UTC

Thanks. Yep import is (probably) the easiest way to go in this case.
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database