Best Practice

Be aware when you use _ORACLE_SCRIPT in scripts

Recently I came across this when I gave a Multitenant workshop at a German customer. As part of the workshop I explained the _ORACLE_SCRIPT statements you will find in almost all scripts in ?/rdbms/admin. And one of the DBAs gave me a bright smile. He mentioned: “We use it already everywhere to avoid strange errors”. But be aware when you use _ORACLE_SCRIPT in scripts. I will explain, why this can be dangerous.

Be aware when you use _ORACLE_SCRIPT in scripts

Photo by Justin Chrn on Unsplash

What does _ORACLE_SCRIPT do?

First of all, this is an underscore parameter. Hence, you won’t find it in the Oracle …

Continue reading...

OOW London 2020 – Upgrade Talk and more

Since last year we organize regional Oracle Open World conferences. Not as big as the one in San Francisco (or in Las Vegas this and the following years), but still an exciting event. And for me, it will be the first time in a week to attend and speak at OOW London. Let me give you a very quick overview on our OOW London 2020 – Upgrade Talk and more.

OOW London 2020 - Upgrade Talk and more

Photo by James Padolsey on Unsplash

Upgrade Best Practices – Thursday, Feb 13 – 13:50-14:25h – Arena B – Zone 2

No idea who has cut down the tech …

Continue reading...

Video: Best Practices to Upgrade to Oracle Database 19c

This is a short “Black Friday” blog post. And just if you are tired already of hunting supposed-to-be-bargain-buys, you may need something to relax – and watch this Video: Best Practices to Upgrade to Oracle Database 19c.

Video: Best Practices to Upgrade to Oracle Database 19c

Roy recorded it as part of the Quest Experience Week. We’d like to share it with you here.

Just click on the picture below to open a new TAB and watch the 1 hour video:

 

If you are looking for the slide deck, you can download them from:

Thanks!

–Mike…

Continue reading...

Book Recommendation: Oracle Database Upgrade and Migration Methods

Thanks guys, I received my copy πŸ™‚

Book Recommendation: Oracle Database Upgrade and Migration Methods

APRESS: Oracle Database Upgrade and Migration Methods

And today I’d like to write a book recommendation: Oracle Database Upgrade and Migration Methods.

The book got authored by these 3 true database upgrade and migration experts:

And it’s cool book mostly for techies. It has plenty of examples in all details. A lot of good tips and tricks (for instance: Disable the Broker when you upgrade your database with standby in place). All of it from …

Continue reading...