With the latest version, 24.8, AutoUpgrade can drop the database link after using refreshable clones.

Details

• Certain jobs in AutoUpgrade require a database link to the source database.
• Whenever you specify a database link using source_dblink, you can optionally instruct AutoUpgrade to drop it.
• The default value is no, meaning AutoUpgrade leaves the database link in place.

How To

• Get the latest version of AutoUpgrade:

  wget https://download.oracle.com/otn-pub/otn_software/autoupgrade.jar
  

• Instruct AutoUpgrade to drop the database link after completing the job:

  upg1.drop_dblink=yes
  

Happy Upgrading

I’m a huge fan of using refreshable clones for upgrades and non-CDB to PDB migrations.

Granted, this is not the most ground-breaking enhancement we’ve introduced. But it’s yet another thing that makes your life a little easier.

What do you think could make AutoUpgrade even easier to use? Leave a comment and let us know.