9 Upgrade and Migration Scenarios

Our doc team has put a lot of effort together with the help of my team mates and created these 9 Upgrade and Migration Scenarios as part of the official Oracle documentation. The idea is to cut out the most common use cases and give a quick and comprehensive overview on all necessary steps. 9 Upgrade and Migration Scenarios These comprehensive 9 scenarios cover non-CDB and PDB/CDB as well as changing to new hardware: Migrating and Converting Non-CDBs to a PDB with a Different Endian Operating System HTML PDF Show Details Migrating Non-CDBs to New Hardware with a Different Endian…

Oracle Database 18.3.0 Upgrade on premises

As Oracle Database 18c is now available on Linux on premises, I blogged about the installation already. And the next logical step is the Oracle Database 18.3.0 Upgrade on premises. In this case I will show an upgrade on the command line from Oracle 11.2.0.4 to Oracle 18.3.0. A DBUA upgrade will follow in a separate blog post later. Oracle Database 18.3.0 Upgrade on premises Before you can start with the upgrade, you may download the software first, and then install it: Oracle Database 18.3.0 on premises is available on Linux Oracle Database 18.3.0 Installation on premises If you read…

ZDLRA ready for Oracle Database 18c

ZDLRA is one of the best acronyms ever. It took me 5+ years to not mix up the sequence of characters 🙂 And even Larry made a joke about the name a while ago at his OOW keynote (I think it was 2016). ZDLRA stands for Zero Data Loss Recovery Appliance. And that basically tells you what it is. Hence, it isn’t a bad acronym as it tells you straight forward what it does. Good news: ZDLRA ready for Oracle Database 18c. ZDLRA ready for Oracle Database 18c Why am I writing about this? Some of the customers I’m working…

Upgrade Oracle 12.2.0.1 to Oracle Database 18c on-premises

I’m currently refreshing our Hands-On Lab and will exchange Oracle 12.2.0.1 with Oracle 18.2.0. This blog post series is about how to Upgrade to Oracle 12.2.0.1 to Oracle Database 18c on-premises. There are other blog posts available you may use by yourself if you plan to refresh the lab by yourself until we uploaded a newer version. And it’s actually a good exercise. Deinstalling Oracle Database 12.2.0.1 Installing Oracle Database 18.1.0 Patching Oracle 18.1.0 to 18.2.0 Upgrade Oracle 12.2.0.1 to Oracle Database 18c on-premises For Multitenant upgrades from Oracle 12.1.0.2 to Oracle 12.2.0.1 you may read this: Upgrade Everything at…

Upgrade Hands-On Lab – Oracle Database 12.2.0.1 – May 2018

Roy just uploaded a newer version of our Upgrade Hands-On Lab – Oracle Database 12.2.0.1 – May 2018. The previous version had – I believe – and early drop of Oracle 12.2.0.1 installed. And recently somebody complained that certain Multitenant operations such as Hot Cloning with Oracle Database 12.2.0.1 don’t work but result in errors. Therefore, we updated it. Upgrade Hands-On Lab – Oracle Database 12.2.0.1 – May 2018 The size requirements unfortunately are still the same. Your machine should have 8GB of RAM and you will need a bit more than 60GB free space on disk. You “could” run…

Upgrade Office Hours: June 20, 2018 – 14:00 CET – The New Release Model

Well, time really flies. And I just realized this morning: It’s time to promote our next session for the Upgrade Office Hours: June 20, 2018 – 14:00 CET – The New Release Model. Yes, Wednesday next week. Time to let us know your questions upfront. BE AWARE: WE HAD TO CHANGE THE BEGIN TIME FROM 11:00 CET to 14:00 CET Upgrade Office Hours: June 20, 2018 – 14:00 CET – The New Release Model Roy, Bill and I have taken a decision to alter the begin dates for the upcoming Office hours. This time it is more easier for customers…

Remove Underscore Parameters not only before you upgrade

Underscore parameters are a wonderful thing in Oracle. They are treated like a secret. But you can view them of course. Everybody can. Make a guess how many underscore parameters exist in Oracle 12.2.0.1.0. You’ll find the answer at the end of this blog post. But why should you remove underscore parameters not only before you upgrade? I’d like to explain below why underscores, especially too many of them, may cause a lot of trouble. Therefore, housekeeping is very important. Remove Underscore Parameters not only before you upgrade This is from a recent upgrade from Oracle 12.1.0.2 to Oracle 12.2.0.1…

Why does your most important database run on Oracle 10.2.0.4?

Today is a sunny day. A wonderful beautiful spring day. Flowers are blooming. Trees are getting green. Birds are singing. All fine. And then I find this email in my inbox. A customer wants to migrate between two Big Endiann platforms with a important ERP system. Nothing special – until I read this: The ERP system is currently on Oracle 10.2.0.4 – and it should stay on Oracle 10.2.0.4. The first question I have: Why does your most important database run on Oracle 10.2.0.4? In 2018. Why does your most important database run on Oracle 10.2.0.4? This is of course…

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…

Swiss Mobiliar Boosts Performance by Upgrading its Oracle Databases

You may have read already some stories about our successful collaboration with Switzerland’s most trusted insurer, Swiss Mobiliar Insurance on this blog. But today I can add an official reference story in 3 languages about how Swiss Mobiliar Boosts Performance by Upgrading its Oracle Databases. Reference Story: Mobiliar’s Upgrade Project And I’m very excited to link the official reference story about Mobiliar’s Upgrade and Multitenant project available in 3 languages: Swiss Mobiliar Boosts Performance by Upgrading its Oracle Databases (English) „Die Mobiliar“ steigert Performance durch Upgrades ihrer Oracle Datenbanken (German) La Mobilière améliore la performance en actualisant ses bases de…

Cloning a PDB from Oracle 12.1 to Oracle 12.2

Is cloning a PDB from Oracle 12.1 to Oracle 12.2 possible? A colleague raised this question recently. And a customer did ask me the same question a few days before at a user group conference. There are several ways to move a PDB from Oracle 12.1. to 12.2. But the documentation does not say explicitly if you can do a cloning operation between Oracle 12.1 and 12.2. Cloning a PDB from Oracle 12.1 to Oracle 12.2 You can clone a non-CDB and make it a PDB but you need to run noncdb_to_pdb.sql afterwards. When I wrote this blog post, Oracle…

DOAG 2017 Conference – Upgrade Talks and More

It’s November. November is DOAG time. Time really flies. And the German Oracle User Group Conference till kick off in a bit more than a week from now on. For me it’s like visiting a huge event where I know so many people: it’s almost like a friends& family meetup. Only strange thing: we all get older … 😉 I’m really looking forward to DOAG 2017 Conference from Nov 21-24, 2017. And if you are not a German native speaker, don’t worry at all. Many talks get simultaneously translated into English. The translators are amazingly good. It’s worth to visit….

Oracle Open World 2017: Must see sessions for UPGRADE / MIGRATION / CONSOLIDATION

Just a few days to go … I’ll be on my way to San Francisco soon for my tenth or eleventh Oracle Open World Conference 2017 soon. And I look forward to it. Roy has compiled a Focus-On document for Oracle Open World 2017: Must see sessions for UPGRADE / MIGRATION / CONSOLIDATION Upgrades Migrations Consolidation with Multitenant Patching The new release model Our talks and labs of course Oracle Open World 2017: Must see sessions for UPGRADE / MIGRATION / CONSOLIDATION Please find the Focus-On Upgrades and Migrations page here: https://events.rainfocus.com/widget/oracle/oow17/1505826559931001NQPG Register for our talks and labs at OOW…

What happens to components with OPTION OFF status during upgrade?

In the newer releases of Oracle database you may see components with status OPTION OFF in the database’s registry. But what happens to components with OPTION OFF status during upgrade? Will those stay on the old release? What happens to components with OPTION OFF status during upgrade? You may have a quick look into your DBA_REGISTRY (or CDB_REGISTRY). I used the check_components.sql script. COMP_ID COMP_NAME SCHEMA STATUS VERSION ——– ———————————- ———— ———- ———— CATALOG Oracle Database Catalog Views SYS VALID 12.1.0.2.0 CATJAVA Oracle Database Java Packages SYS VALID 12.1.0.2.0 CATPROC Oracle Database Packages and Types SYS VALID 12.1.0.2.0 JAVAVM JServer…

When you upgrade, disable the Data Guard Broker

A customer of mine hit an issue recently when upgrading to Oracle Database 12.2.0.1. They did everything correctly but received a ton of issues from the Data Guard Broker. A rule says: When you upgrade, disable the Data Guard Broker. But I can’t blame the customer as this “rule” is well hidden in the documentation. When you upgrade, disable the Data Guard Broker First of all, the Data Guard Broker is required if you would like to administer your databases in Oracle Cloud Control. Otherwise you can’t switchover or failover within Enterprise Manager. But once you approach a database upgrade…