Monitoring catctl.pl progress during upgrades

The parallel upgrade catctl.pl can resume once an upgrade has stopped for unexpected reasons. Before Oracle 12.2 you can restart it with the -p option specifying the phase it stopped. And since Oracle 12.2 you can only use the -R option to resume it. This blog post will give you a bit more insights in monitoring catctl.pl progress during upgrades. Monitoring catctl.pl progress during upgrades I blogged about the resume options for catctl.pl a while ago: Restarting a failed database upgrade with catctl.pl But you may ask yourself: How does the tool know where to resume? And do you need…

Unplug a 12.2.0.1 PDB and plugin into 18c in the Cloud

There’s been silence for a while – but today I’d like to show you how to unplug a 12.2.0.1 PDB and plugin into 18c in the Cloud. I’m doing this exercise because I’ve seen questions already. And I was curious if it works as I’d expect it. Unplug a 12.2.0.1 PDB and plugin into 18c in the Cloud As usual I will use our hands-on lab environment – and a freshly deployed 18c OCI-Classic instance (formerly known as DBCS formerly known as DBaaS). It is a Single Tenant environment with one PDB. If you need for information about how to…

Upgrade to Oracle 12.2.0.1: Check your DEFAULT temporary tablespaces

One of the reasons why I have this blog is simply to stay in touch with smart people using Oracle and telling me about issues I haven’t seen before. Thanks to Tyler Van Vierzen I learned that an upgrade to Oracle 12.2.0.1 may alter the default local temporary tablespace. Upgrade to Oracle 12.2.0.1: Check your DEFAULT temporary tablespaces Tyler did contact me on Twitter: “Curious if you’ve seen this… Seeing new “local temp tablespace” set to SYSTEM for some users after 12.2 upgrade. But not all. No discernable pattern. Some null (so default to their temp tablespace), some set equal…

Upgrade and Migration Office Hours on March 21, 2018

The first Office Hours Session was just a month ago. It was a very good experience and based on the feedback we received from customers it was very helpful. You don’t believe it? Then you may watch the recording. But now it’s time for our second Upgrade and Migration Office Hours on March 21, 2018. What are “Office Hours”? This is a new interactive format we’d like to try out. Several groups in Oracle schedule Office Hours sessions. Roy and I held our first Office Hours session on February 21, 2018 for a full hour trying to answer your questions…

Automatic Maintenance Jobs are enabled after upgrade

This is a strange behavior – but it seems as automatic maintenance jobs are enabled after upgrade. A customer (thanks Naveen!!) sent me an email the other week asking if there’s a flag in DBUA to prevent this enabling as on some of their databases the automatic maintenance jobs are disabled on purpose. Automatic Maintenance Jobs are enabled after upgrade It sounded kind of strange to me – and my first test was to use the catctl.pl instead of the DBUA. First of all I did check the status of the Automatic Maintenance Jobs in my 11.2.0.4 database: SELECT client_name,…

Upgrade and Migration – Office Hours – Feb 21, 2018

Sign up for our first Upgrade and Migration Office Hours Session on February 21, 2018: https://asktom.oracle.com/pls/apex/f?p=100:551:::NO:551:P551_CLASS_ID:3201: Time: UTC 02:00 PM February 21 2018 US/Eastern 09:00 AM February 21 2018 Asia/Hong_Kong 10:00 PM February 21 2018 Australia/Sydney 01:00 AM February 22 2018 Asia/Calcutta 07:30 PM February 21 2018 Europe/London 02:00 PM February 21 2018 Europe/Berlin 03:00 PM February 21 2018 US/Pacific 06:00 AM February 21 2018  

Multiple Hops – Which should be the intermediate release?

This is a topic which doesn’t come up very often. But if it does come up from time to time, and the documentation may give you advice – but as I realized – it does not always give the best advice. When you have to do multiple hops – which should be your intermediate release? I posted something about this topic a while back: Multiple hop upgrades? Execute the matching preupgrade scripts for each hop What are Multiple Hops? We speak of multiple hops in relation to database upgrades when your source release does not allow you to upgrade directly…

Upgrade and Migration Office Hours on Feb 21, 2018

Thanks to the team of Steven Feuerstein who built up the framework for a new interactive format, the Office Hours. You can sign up now for our first Upgrade and Migration Office Hours on Feb 21, 2018. What are “Office Hours”? This is a new interactive format we’d like to try out. Several groups in Oracle schedule Office Hours sessions. Roy and I will be available during our first Office Hours session on February 21, 2018 for a full hour trying to answer your questions regarding database upgrades and migrations live and directly. How do you sign up? First of…

Database Upgrade and TDE – Things to Know

Transparent Data Encryption is an excellent and very useful Oracle database feature. In this blog post I will show and highlight Database Upgrade and TDE – Things to Know. Enabling Tablespace Encryption with TDE For a simple example I use our Hands-On Lab and the UPGR database (Oracle 11.2.0.4) and the listener declarations in the 12.2 $ORACLE_HOME. At first I add the following string to the sqlnet.ora file: # sqlnet.ora # ENCRYPTION_WALLET_LOCATION = (SOURCE = (METHOD = FILE) (METHOD_DATA = (DIRECTORY = /u01/app/oracle/admin/UPGR/wallet)) ) Note 2018, Feb 4: My previous example had $ORACLE_BASE instead of /u01/app/oracle, the real path, in…

Minimum Supported Version for Database Upgrades

This question comes up very often: What is the minimum supported version for database upgrades? Or a question I received today: “I have an Oracle 10.2.0.4 database, can I upgrade directly to Oracle 11.2.0.4?” Usually I have to dig into my old slides from the past to give a definite answer. And of course, the Database Upgrade Guide of each version has the same information somewhere as well. Therefore I’d like to summarize the releases supported for direct database upgrades since Oracle 11.2.0.4 below. Upgrade? When I speak about database upgrades, I mean you’ll use either the command line upgrade…