SIHA

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 12.2.0.1 RESTART: Make sure you’ve patched your Oracle 12.1.0.2 homes

Oracle 12.2.0.1 RESTART: Make sure you've patched your Oracle 12.1.0.2 homesThis blog post title sounds a bit weird, doesn’t it? Oracle 12.2.0.1 RESTART: Make sure you’ve patched your Oracle 12.1.0.2 homes. Why the heck should you patch your 12.1.0.2 database homes upfront?

Oracle 12.2.0.1 RESTART: Make sure you’ve patched your Oracle 12.1.0.2 homes

Well, there’s an interesting issue happening. When you work with Oracle Grid Infrastructure, no matter if you operate a cluster or “just” use Oracle Restart, you’ll have to upgrade GI to Oracle 12.2 first before you can manage 12.2 databases with it. That’s not new. It’s a well understood rule.

Now guess you operate Oracle RESTART (SIHA …

Continue reading...

Upgrading ORACLE RESTART from 11.2 to 12.1

First of all, Oracle Restart is deprecated in Oracle Database 12c. Deprecation means the product is still supported, you can open SRs, you’ll get bug fixes – but we won’t do further development of the product or feature.

But a customer (Thanks to Jaco de Graaf for bringing this to my attention!) had a question via the blog about the best approach to upgrade his Oracle Restart configuration …

Continue reading...