Day 10: AutoUpgrade
December 21, 2020
The Oracle 19c database is replete with new capabilities and enhanced features; but, customers can only take advantage of these improvements by upgrading. Historically, upgrades and migrations were painful, sometimes lengthy efforts that few database administrators (or organizations) looked forward to. Database upgrades are infrequent events for most environments and each time steps that worked for prior versions, are unlikely to apply to the current database. Source and target versions combine to dictate a potentially lengthy and confusing series of actions for checking compatibility, verifying prerequisites, disabling deprecated and de-supported features, and updating configurations.
Fortunately, among the improvements introduced alongside Oracle 18c and 19c, a tool that greatly streamlines and simplifies the process of upgrading Oracle databases: AutoUpgrade!
As AutoUpgrade is a new tool, database administrators may be reluctant to entertain it, instead deferring to more familiar methods they’ve used in the past. One objection to AutoUpgrade is that it’s too easy. There’s an expectation that upgrades must be difficult, and AutoUpgrade’s simple setup and interface makes it easy to assume that it’s not powerful or comprehensive enough for any except the most simple of environments. In fact, AutoUpgrade boasts an impressive set of checks and capabilities behind its unassuming interface.
Among these features:
- A robust set of pre-checks and reporting that identify (and in many cases,
automatically correct) issues discovered in the environment. These range from checking for adequate resources and proper database settings, to identifying deprecated and de-supported features in the existing database.
- An interactive command line interface that allows users to manage the full upgrade process, view status and progress, pause and resume upgrades, and even restore the database to its original state.
- AutoUpgrade is resumable. If it encounters a problem, AutoUpgrade reports the error and pauses the process. Once the problem is fixed, administrators restart the upgrade and the intelligent process picks up where it left off. If the issue can’t be resolved, users can roll back the upgrade within the tool. In either case, there’s no need to identify the operation that failed or build any special commands. AutoUpgrade tracks its progress and runs what is needed