Even though AWS RDS (relational database service) is a managed service which means that you won't have to worry about upgrades, patches and other tidbits, you still have the option of manually triggering the upgrade at time of your choice.
Upgrading an Oracle database is quite critical not only for the database itself but more importantly for the dependent applications. It's very important to try out any upgrade on RDS on a test representative system before hand to iron out any wrinkles and check the timings and any other potential issues.
There are 5 important steps before upgrading Oracle on AWS RDS you can take to make this process more risk-free, speedy, and reliable:
- Check Invalid objects such as procedures, functions, packages etc in your database.
- Make a list of the objects which are still invalid and if possible delete them to remove clutter.
- Disable and remove audit logs if they are stored in database
- Convert dbms_jobs Jobs and other stuff to dbms_scheduler
- Take Snapshot of your production database right before you upgrade to speed up the upgrade process as then during upgrade only delta snapshot will be taken