DOAG Conference 2018 in Nuernberg – Upgrade and AutoUpgrade talk

Well, how do I realize it is November already? When I receive my conference pass for DOAG conference. And actually when the first snow falls right on time when I plan to hit the road. Lovely! If you are coming to DOAG Conference 2018 in Nuernberg – Upgrade and AutoUpgrade talk is the one you should see. You can’t find “AutoUpgrade” in the official description? Yeah, true. I added this after the Oracle Open World presentation to get you a sense about where upgrade is going to. And beyond … 🙂 DOAG Conference 2018 in Nuernberg – Upgrade and AutoUpgrade…

OOW 2018: Upgrade to Oracle 18c – Live and Uncensored

Less than two weeks until the potentially busiest Oracle Open World conference I’ve ever attended. The schedule is filled up already and closed down. And I’m pretty sure I will need time off afterwards to relax and recover. But I’m looking forward to our annual big event in San Francisco. To make it as exciting as possible for you we are very happy to have high profile speakers with us in all our talks. And we promise: No marketing. Just tech facts. If you’d like to sneak into OOW 2018: Upgrade to 18c – Live and uncensored, then mark your…

OOW2018: The new AutoUpgrade for the Oracle Database

As I wrote the other day, OOW 2018 is not too far away anymore. And if you’d like to see something really new, something which can really really ease your database upgrades in the near future, then you may visit our first talk right on Monday morning at OOW2018: The new AutoUpgrade for the Oracle Database. What is this talk all about? First of all, let me emphasize that we don’t do marketing. We would like to introduce you to a brand new tool we’ll currently have in beta operation at selected customers. And which we’ll release in the new…

Office Hours: Upgrade and Migrations – September 20, 2018

It’s time for the next Office Hours: Upgrade and Migrations – September 20, 2018. This time Roy and Bill will run it as I’m traveling. And they’ve set it on purpose to a convenient time for the Americas. Roy has prepared a few slides upfront – and then it’s your time for questions. Office Hours: Upgrade and Migrations – September 20, 2018 You simply sign-up via this link: https://asktom.oracle.com/pls/apex/f?p=100:551:::NO:551:P551_CLASS_ID:1382: Click the big petrol colored Sign Up to Subscribe button to the right. Topic for this week The next edition of upgrade & migration office hours will start with a short…

Unified Auditing policies can slow down the upgrade

I posted several blog posts about Unified Auditing in the past. And recently a large customer in the UK alerted me about their upgrades with PDBs from 12.1 to 12.2 taking much longer when Unified Auditing policies were enabled. It looks like as if Unified Auditing policies can slow down the upgrade. We did some further investigations. See the results below. Unified Auditing You find a good number of blog posts explaining how to migrate to Unified Auditing, the performance tweaks in Oracle 12.1.0.2 and some other things: Unified Auditing – Is it ON or OFF in Oracle 12.2.0.1? Unified…

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…