ASM

Voodoo with init parameters and Oracle Restart

Uwe Kirchhoff, one of the best techies I know in the entire Oracle CSS (formerly ACS) Support, mailed me before the Christmas holidays with a simple question. He discovered that altering init.ora parameters in a session does not necessarily write the parameter down into the spfile. Sounds a bit like Voodoo with init parameters,  and Oracle Restart has a role in this story as well. If you don’t have or do not plan to use Oracle Restart, then this is not interesting for you. But of course, you are free to still read it 🙂

Voodoo with init parameters and Oracle Restart

Photo by Marko Manojlovic on

Continue reading...

Oracle Database 12.2.0.1 and GI are certified on OL8 and RHEL8

No worries, this isn’t a blog post from the vault. And I haven’t accidentally published something from the past just today. It is real. Oracle Database 12.2.0.1 and GI are certified on OL8 and RHEL8.

Oracle Database 12.2.0.1 and GI are certified on OL8 and RHEL8

Photo by Derek Oyen on Unsplash

What has been certified?

Thanks to my colleagues and a large customer in the UK, I received an email asking whether I have seen this information already on MOS. I haven’t. I knew that there were discussions but I had no actual date for the 12.2.0.1 certification on OL8 on my radar.

So in brief, these Linux 8 releases …

Continue reading...

Which database version can be used with Grid Infrastructure 19c?

This will be a very short blog post today. But a colleague asked me this question just a few minutes ago: Which database version can be used with Grid Infrastructure 19c? And I realized that I neither put it on the blog yet nor did I bookmark it. But I answered this question several times already.

Which database version can be used with Grid Infrastructure 19c?

There are 4 sources I did check:

  • MOS Notes on MyOracle Support
  • Oracle Documentation
  • Certification Information on MyOracle Support
  • Database Upgrade Blog

At first, I answered with MOS

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 apply OJVM patches to Grid Infrastructure?

From time to time, when I discuss OJVM patching with customers, I hear the following question: Do you need to apply OJVM patches to Grid Infrastructure? I’m carrying around this topic since months actually.

Do you need to apply OJVM patches to Grid Infrastructure?

Photo by Jakub Kriz on Unsplash

A quick MOS check

Well, you’d assume this is something MOS does give you an answer within fractions of a second. But nope. I found a lot but unfortunately not what I was looking for. What I found instead where community discussions where applying OJVM patches to a 12.1.0.2 GI installation corrupted the inventory. Hence, there seems to be some …

Continue reading...

AutoUpgrade and Data Guard, RAC, Restart and non-CDB to PDB

I need to bring this blog post forward about AutoUpgrade and Data Guard, RAC, Restart and non-CDB to PDB. Initially I planned to write this a bit later. But some of you had questions or were wondering why AutoUpgrade hasn’t done certain tasks. Hence, I’d like to clarify what AutoUpgrade can do, what it can’t and what you’ll have to do at the moment.

I refer to the AutoUpgrade tool as of July 2019. In later versions, one or the other restriction may be lifted. I will blog about it then as well.

AutoUpgrade and Data Guard, RAC, Restart and non-CDB to PDB

AutoUpgrade – Step-by-step

  1. The new AutoUpgrade
Continue reading...

More than one PDB in the same directory?

Can you create more than one pluggable database (PDB) within the same directory?
And how does the file naming work? Considering the fact each PDB’s SYSTEM tablespace will be named system01.dbf by default the question is not trivial.

This question got asked by a customer during one of the workshops in Switzerland last week. And the solution is straight forward. Thanks to Roy for trying it out yesterday at 170 km/h on our way back from Stuttgart 🙂

Thanks 🙂

-Mike

Additional information:

Within ASM with OMF the file structure looks like this:

select con_id, substr(file_name,1,90),tablespace_name from cdb_data_files order by 
Continue reading...

Creating ASM for test purposes in the file system

First of all, I’m back after pausing for a while – sorry for not updating the blog in the past weeks … and you won’t see many updates in the following weeks as it’ll be holiday season (and we Germans have sooooo many public holidays) 🙂

Anyway, back to tech topics. Today I want to test Oracle Restart upgrades. Oracle Restart internally is called SIHA (Single Instance High Availability) which explains the topic a bit more. Basically it means having your database reside in ASM and let Oracle Clusterware take care on it, even though you don’t have a cluster. …

Continue reading...