Oracle database 12c upgrade to 19c

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...

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 :)

StackExchange Database Administrators Q#259545, answer score: 3