Skip to Main Content
  • Questions

  • Windows Oracle11g to Linux Oracle 12c

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Sami.

Asked: January 22, 2019 - 8:37 pm UTC

Last updated: February 11, 2019 - 2:53 am UTC

Version: 12.2.0.2

Viewed 1000+ times

You Asked

Hi, hope you're doing great? I wonder if you can help me by giving me some advices or pointing me to some useful docs. In fact, we are planning to migrate a financial application with most of its business logic is written in Pl/SQL, from Windows Oracle 11.2.0.4 to Linux Oracle 12.2. We are thinking in doing it in 2 steps, first to Linux Oracle 11.2 and from http://11.2.to 12.2. ... i'm wondering what kind of problems we will get ? And if there is some best practices and guidelines to follow specially to test and maintain the stability of our PL/SQL layer...
Many thanks.

and Connor said...

I'd be inclined to use RMAN transportable tablespaces for this. A friend Harald has a nice write up of this on his blog

https://prutser.wordpress.com/2015/01/04/cross-platform-transportable-tablespaces-made-easy/

In this way, you

a) have a copy of the original database still (makes backout easier)
b) you don't need to do an upgrade step, you "unplug" the tablespaces from 11g and attach them to the 12c instance

Rating

  (1 rating)

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

Comments

great advice

A reader, February 10, 2019 - 11:56 am UTC


Connor McDonald
February 11, 2019 - 2:53 am UTC

glad we could help
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

Backup/Recovery

Check out the complete guide to all of the Backup & Recovery techniques in the Oracle Database.