6

I was asked to advise some business analyst on migration from Oracle DB 12c to 19c. The thing is I have never used or done anything related to Oracle DB. From my experience with MSSQL during upgrade I know that some features became deprecated hence it required a bit of manual work for example re write custom made stored procedures, there were some issues with indexes and etc..

The good thing with MSSQL was it told you before upgrade what issues you will encounter and what is deprecated. Can you do check it similarly in Oracle Db aswell?

Also, please share your upgrade stories, did it went smooth? Did you encountered any issues afterwards? What should be kept in mind (that might break after upgrade) before upgrading? Also I would appreciate any related articles/videos/etc...

Improve this question
3
  • Is this an on-prem database? Cloud? Windows? Linux?
    – Joe W
    Commented Feb 12, 2020 at 17:46
  • Yes, this is on premise DB running on Linux, yet I am not sure about OS version.
    – Petras Paludnevičius
    Commented Feb 12, 2020 at 17:52
  • You should add that information to the question as it can impact how the process works which could add complexity to it.
    – Joe W
    Commented Feb 12, 2020 at 18:17

3 Answers 3

Reset to default
3

I'm from the Database Upgrade team at Oracle, I recommend you to download and run the AutoUpgrade tool, if you run it using analyze mode will tell you if your database is ready to upgrade, we just released version 19.7.5 yesterday, more info here https://docs.oracle.com/en/database/oracle/oracle-database/19/upgrd/using-autoupgrade-oracle-database-upgrades.html :)

Improve this answer
1

Upgrading 12c to 18c or 19c should not be a problem. I don't think that 19c is that different from 12c. The dbua tool should be able to do the upgrade. You still need to test with a test database. But running the dbua tool should work. Going from pre-12c to 19c is a much bigger issue depending on what features are used.

Improve this answer
0

There is a database upgrade quick start guide that you might find handy: https://www.oracle.com/a/otn/docs/database-upgrade-quick-start-guide.pdf

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.