Database

Cloud Migrations: The New Kid on the Blog – DOHDATABASE.com

You may have realized that you will find mostly on-prem database upgrade and migration topics covered on my blog. Which doesn’t mean that you can’t use most of these techniques to migrate to the cloud either. But it’s really hard to write about everything in full detail. Hence, today I’d like to introduce you to Cloud Migrations: The New Kid on the Blog – DOHDATABASE.com. And no, I was never a fan of this American boyband from the 80s and 90s πŸ˜‰

Cloud Migrations: The New Kid on the Blog - DOHDATABASE.com

Find Daniel’s blog at: https://dohdatabase.com

DOHDATABASE … huh?

Cloud Migrations: The New Kid on the Blog - DOHDATABASE.com

Daniel Overby Hansen

As you may have read a …

Continue reading...

Does your GI RU/RUR patch level has to match your database’s?

A long while ago I blogged about whether you should keep your patch versions between Grid Infrastructure and Databases Homes in synch, or not. And today, Daniel dropped me a note mentioning that this old blog post may need an update for 18c/19c. He’s right. And as I’ve had trouble finding my old blog post, I title this one a bit more obvious: Does your GI RU/RUR patch level has to match your database’s?

Does your GI RU/RUR patch level has to match your database's?

Photo by Vincent van Zalinge on Unsplash

Before Oracle Database 18c

Since Oracle 18c we move from a 5-number release schema to a 3-number one. …

Continue reading...

Do you need to license Java for AutoUpgrade?

Actually this question came up internally. I did have no doubt that you don’t have to license Java in order to use AutoUpgrade. But a colleague had such doubts. So let’s clarify: Do you need to license Java for AutoUpgrade?

Do you need to license Java for AutoUpgrade?

Photo by nousnou iwasaki on Unsplash

Or phrased in a different way: “Since Java 8 requires a Java subscription now. Does autoupgrade come with a license?

Do you?

Of course, No!

But where do the doubts come from? Actually this link here does not list the “Oracle Database” as a product. But there is this MOS Note

Continue reading...

Do we offer patched Gold Images already?

Internally we can use a Gold Image service at Oracle. I can download a zip with 19.6.0 included. But externally for you as customers, the download of 19.6.0 required that you download 19.3.0 at first, then apply 19.6.0 on top of it. But a day ago, a tweet by my Belgium friend Philippe Fierens caught my attention. Do we offer patched Gold Images already?

Do we offer patched Gold Images already?

Photo by Sergey Pesterev on Unsplash

What is a Gold Image?

Since Oracle 18c, the installation routine has changed to the better. You download zip file containing the Gold Image, you create a directory and

Continue reading...

AutoUpgrade Tips: Running two (or more) sessions in parallel

Our intention with the AutoUpgrade as the single tool to upgrade your databases was initially: You have one big config file for your databases. And you will use this file to upgrade your databases unattended. Ideally you run an “analyze” at first, then you schedule a “deploy” for overnight or the next weekend or whenever it is convenient for you. But sometimes people have different needs. In this particular case several people asked whether you can run multiple AutoUpgrade tools in parallel on the same server. Hence, I’d like to explain the first of more AutoUpgrade …

Continue reading...

Exadata Upgrade to OL7 and to Oracle 19c

This is just a short blog post to ensure I will find the necessary information when somebody asks me again.. In case you plan to do an Exadata upgrade to OL7 and to Oracle 19c, the below links are the most important ones you should start with.

Exadata Upgrade to OL7 and to Oracle 19c

Exadata Upgrade to OL7 and to Oracle 19c

–Mike…

Continue reading...

AutoUpgrade: Where do you find all the logfiles?

AutoUpgrade: Where do you find all the logfiles?In the previous blog posts you could read about how to create the configuration file, adjust it and tweak the init parameters for the AutoUpgrade tool. And then I described the different modes of it. In this blog post I’d like to give you some insights into AutoUpgrade: Where do you find all the logfiles?

AutoUpgrade: Where do you find all the logfiles?

AutoUpgrade – Step-by-step

  1. The new AutoUpgrade Utility – Download, documentation and supported versions
  2. Create and adjust the config file for AutoUpgrade
  3. Config file for AutoUpgrade – Advanced options
  4. Config file for AutoUpgrade – Tweaking init parameters
  5. AutoUpgrade: ANALYZE, FIXUPS, UPGRADE and DEPLOY modes
  6. AutoUpgrade:
Continue reading...

AutoUpgrade: ANALYZE, FIXUPS, UPGRADE and DEPLOY modes

AutoUpgrade: ANALYZE, FIXUPS, UPGRADE and DEPLOY modes

Photo by Debby Hudson on Unsplash

In the previous blog posts I explained mainly how to create, alter and tweak the configuration file for the AutoUpgrade tool. By now you should have your config file set up and adjusted for your environment(s). Let me go a step further and explain the different processing modes of AutoUpgrade: ANALYZE, FIXUPS, UPGRADE and DEPLOY modes. Then you’ll have a precise idea what the tool is actually doing, and how it operates.

AutoUpgrade – Step-by-step

  1. The new AutoUpgrade Utility – Download, documentation and supported versions
  2. Create and adjust the config file for
Continue reading...

How long can you provision database version X in the Cloud? – NEW

A few weeks ago I published a blog post about provisioning dates in Oracle Cloud environments for different databases releases. As we did an important update, I rewrite today: How long can you provision database version X in the Cloud? – NEW.

What has changed since the original post?

The key point in the previous blog post was:

“And by end of this calendar year, the option to provision an Oracle 12.2.0.1 instance will go away. The same will happen in less than 1 year with Oracle 11.2.0.4 instances.”.

With “this calendar year” I pointed to end of 2018. …

Continue reading...

July 2018 Update, Revision, BPs, PSUs – delays and other issues

This is a Friday morning blog post. And actually I had no intention to write it. I don’t mean it offensive. But yesterday I received an interesting email from Frits Hoogland from Enkitec/Accenture. Frits asked me about the July RUR and some unlogic things on MOS. Once I had answered his email, the next question came in. Hence, I thought I need to write something about our July 2018 Update, Revision, BPs, PSUs – delays and other issues.
July 2018 Update, Revision, BPs, PSUs - delays and other issues

From being on stage at last year’s DOAG Conference for a “Patching Forum” I know that things aren’t as …

Continue reading...

July 2018 Update, Revision, BP and PSU

Hurray, it’s patching day! I know, YOU did look forward to July 17, 2018 as it is patching day again. Last night we released the following Patches: July 2018 Update, Revision, BP and PSU.

July 2018 Update, Revision, BP and PSU

First of all, I’m doing the usual check for the alert and the risk matrix to see whether there’s are really important security patches included. For the risk matrix you’ll have to scrooooooooooolllll down quite a bit as the list of products is strictly alphabetically ordered:

Continue reading...

Keep your patch versions between Grid Infrastructure and Databases Homes in synch

Keep your patch versions between Grid Infrastructure and Databases Homes in synchI’ve had some interesting discussions with Anil Nair, our RAC Product Manager and a customer in the past days. The customer was looking for a definite statement that they can have a higher version of Patch Set Updates (PSUs) or Proactive Bundle Patches (BPs) in the Database homes than in the Grid Infrastructure home managing the resources.

For Oracle Database 18c, 19c and onward, please read instead:

Can you have different PSU/BP versions between Database and GI homes?

Yes, you can have a higher version PSU …

Continue reading...

UKOUG: SIG (RAC, Cloud, Database, …) – 12 Oct 2016

Wow … time flies …

I think it was February or March this year when I’d got invited to the UKOUG SIG for RAC, Database, Cloud, Infrastructure in London on Oct 12, 2016. Just a week ago I looked into my calendar and realized: Book a flight. Now! We have to arrange travel at least 7 days before departure as otherwise extra approvals may be required. Time flies …

Oracle Database 12.2.0

The room number in the picture above was the one of my hotel room in Baku earlier this year in May πŸ˜‰

And of course on Wednesday I will talk about …

Continue reading...

Oracle Database Express Edition 11g Release 2 is now available!

Many customers have asked over the past year whether we would be producing a newer version of the Oracle Database Express Edition, because it makes such a terrific starter database for students, developers, and DBAs. Well, the answer is Yes!

As of today, Oracle Database Express Edition 11g Release 2 is available for download. As with the 10g release, this Express Edition is free of charge. To find more information about downloading the software and documentation, please visit the OTN page for Express Edition.

Remember, you can always upgrade your database to Standard or Enterprise Edition if you outgrow …

Continue reading...

Recap on Deinstall Routines

A few weeks ago I’Ve posted something about the deinstall utility as OUI doesn’t offer a “deinstall software” option anymore:
How to deinstall “old” SW after 11.2.0.2 has been applied?

And I’ve got some feedback (which is a good sign as it means that some of the content might be useful and will be read – and from the follow-up you see that we’ll read your comments and emails as well πŸ™‚ ).

Anyway, the feedback was either CRS deinstall does not work the right way or deinstall cleans up too many things. So Roy did follow …

Continue reading...