Topic

Autoupgrade

A collection of 4 issues

Oracle: Which updates to install

In my IT carreer, I often come to new customers I didn't know before. So I don't know their infrastructure. As I'm a DBA, I'm not interested in application servers (besides telling the customer that Operating Systems and standard applications should always

Oracle: Prepare database for upgrade using autoupgrade.jar

In my job, I often have to upgrade or patch Oracle databases. Furtunately, most of all the databases in production are now on 19c, and the rest is mainly on 12.2.0.1. The best tool for upgrading is autoupgrade.jar, which in future will be the only upgrade

Oracle: Upgrade from 12.1.0.1 using autoupgrade.jar takes ages

Last year, when I upgraded many Oracle databases to 19c, I had a few databases which were still on Oracle 12.1.0.1. In case that you forgot what 12.1.0.1 meant for Oracle and all customers: * Until 12.1.0.1, we had Enterprise Edition, Standard

Oracle: Timezone upgrade - the easy way

From time to time, countries change their time zone, or the daylight saving time changes (in Germany, we wait for that since years). As some date columns include this information - like TIMESTAMP WITH TIME ZONE, they have to be updated. These updates are called Timezone upgrades. The standard way