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...
-
Is this an on-prem database? Cloud? Windows? Linux?Joe W– Joe W2020年02月12日 17:46:07 +00:00Commented 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– Petras Paludnevičius2020年02月12日 17:52:59 +00:00Commented 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– Joe W2020年02月12日 18:17:58 +00:00Commented Feb 12, 2020 at 18:17
3 Answers 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 :)
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.
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