Upcoming User Group Events in Copenhagen, Oslo and Dublin

I just returned from a wonderful but strenuous trip from Denver, San Francisco and Vancouver a day ago. And soon it is time again to pack my suitcase as there are upcoming user group events in Copenhagen, Oslo and Dublin.

Upcoming User Group Events in Copenhagen, Oslo and Dublin

Oracle Upgrade Meeting @SimCorp in Copenhagen

Upcoming User Group Events in Copenhagen and Oslo

Next week on Wednesday. [ Read More ]

Don’t drop the AUDSYS user before upgrading

Don't drop the AUDSYS user before upgradingThis is a very interesting case Martin Berger sent to me a week ago. A colleague and him were basically wondering if they should follow the advice in the Oracle 12.2 upgrade guide and drop the AUDSYS user, or if they better don’t drop the AUDSYS user before upgrading.

What is AUDSYS meant for?

[ Read More ]

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.… [ Read More ]

RMOUG Training Days 2018 in Denver – Recap

The Rocky Mountain User Group (RMOUG) Training Days 2018 are over. And I’d like to say THANK YOU with a short RMOUG Training Days 2018 in Denver – Recap.

RMOUG Training Days 2018 in Denver – Recap

First of all a BIG Thank You to the organizers. I’d bet this was a lot of hard work to organize such a huge event with so many excellent presentations in parallel streams, the exhibitor space, the food and everything else.… [ Read More ]

When does patching end for Oracle Database 12.2.0.1?

This question is coming up on a regular basis for obvious reasons whenever we speak to customers about Oracle Database 12.2 and 18c: When does patching end for Oracle Database 12.2.0.1?

When does patching end for Oracle Database 12.2.0.1?

Actually Roy and I are explaining this topic in our The New Release and Patching Model presentation:

When does patching end for Oracle Database 12.2.0.1?

Annual releases, such as Oracle 12.2.0.1, Oracle 18c, Oracle 19c and so on, get a minimum of 2 years patching after the succeeding release is available.… [ Read More ]

Oracle Database 18c released for Oracle Cloud and Engineered Systems

Oracle Database 18c has been released Friday, February 16, 2018 in the Oracle Cloud and for Engineered Systems.

Oracle Database 18c released for Oracle Cloud and Engineered Systems

What is new in Oracle Database 18c?

Please read this comprehensive description by Dominic Giles, Master Product Manager for Oracle Database on https://blogs.oracle.com/database/oracle-database-18c-:-now-available-on-the-oracle-cloud-and-oracle-engineered-systems. Dominic summarizes the most important features in the areas of Multitenant, In-Memory, Sharding, Performance, High Availability, Security, Spatial/Graph and of course Developer features.… [ Read More ]

Multiple Hops – Which should be the intermediate release?

Multiple Hop Oracle Database UpgradesThis 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?… [ Read More ]

Oracle Open World 2018 – Now from October 22-25, 2018

When I was reading tweets I’m subscribed to last week while being in Redwood Shores, I read this one from the official Oracle Open World twitter account and learned: Oracle Open World 2018 – Now from October 22-25, 2018.

See the tweet:

[ Read More ]

MOS Note:742060.1 got updated with Oracle 18c information

From the Support’s Hot Topics email I learned the other day that MOS Note:742060.1 (Release Schedule of Current Database Releases) got updated with Oracle 18c information on January 18, 2018.

What got added to MOS Note:742060.1?

A column for Oracle 18c got added to the table of releases. You will find not information about potential release availability for Oracle 18c in the various options of the Oracle Cloud, and of course for on-premises as well.… [ Read More ]

preupgrade.jar January 2018 (Build 11) is available now

A new version of the preupgrade.jar January 2018 (Build 11) is available now.

Please download it from MOS Note:884522.1.:

preupgrade.jar January 2018 (Build 11) is available now

MOS Note: 884522.1 – How to Download and Run Oracle’s Database Pre-Upgrade Utility

Please always download the most recent version as this one is much newer with a lot of improvements compared to the version you get with the default installation.… [ Read More ]

RMOUG Training Days in Denver – just 4 weeks away

Time flies. Really, it does. When I looked into the calendar I realized the next event is already very close: RMOUG Training Days in Denver – just 4 weeks away from now on.

The Rocky Mountain User Group Training Days will happen in Westminster close to Denver, CO from Tuesday, Feb 20 until Thursday, Feb 22, 2018.… [ Read More ]

Additional Info for Adaptive Features Fixes in Oracle 12.1.0.2

Additional Info for Adaptive Features Fixes in Oracle 12.1.0.2I blogged about the Adaptive Features fixes in the past several times. But following some of the comments readers had I believe there’s some additional info for Adaptive Feature Fixes in Oracle 12.1.0.2 necessary.

What happened so far?

We delivered the most important fixes not only for adaptive features but only for dynamic sampling and some other things with the Database Bundle Patch in October 2017 for Oracle Database 12.1.0.2.… [ Read More ]

January 2018 Database RU and RUR got released

It’s patching time again. The January 2018 Database RU and RUR got released. And of course other patch bundles as well. And of course not only for the database but for many other products as well. I try to summarize below the most important information and links.

January 2018 Database RU and RUR got released

First of all always have a look at the Critical Patch Alert and the Risk Matrix:

Then you’ll see that there are three fixes included for vulnerabilities which may be remotely exploitable without authentication, i.e., may be exploited over a network without requiring user credentials.… [ Read More ]

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.… [ Read More ]

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.… [ Read More ]

Swiss Mobiliar Boosts Performance by Upgrading its Oracle Databases

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:

Congratulations to the Team

Congratulations to a fantastic team at Swiss Mobiliar.… [ Read More ]

Happy New Year 2018!

Dear all,

there was silence on the blog for more than 2 weeks now. And 2018 started already. Let me wish you all a happy and exciting new year 2018. Stay safe and healthy, take care and all the best for 2018 to you, your families and friends!

Happy New Year 2018

Source: https://pixabay.com/en/design-2018-to-reach-new-year-3047520/

There will be more updates in the next few days 🙂

Happy New Year!… [ Read More ]

Slides and Recap – DOAG 2017 and UKOUG 2017

Thanks for your patience. I have received a good amount of calls, emails and messages in the past weeks when the slides for DOAG and UKOUG will be available. And they are now including the “New Release and Patching Model” talk. Find slides and recap – DOAG 2017 and UKOUG 2017 here.… [ Read More ]

DBCA 12.2 does not update /etc/oratab in GI / RAC

DBCA 12.2 does not update /etc/oratab in GI / RACInteresting things happen. And I learned (credits to Arun Gupta and others) that there is a change in Oracle Database 12.2 environments I wasn’t aware: The DBCA 12.2 does not update /etc/oratab in GI / RAC environments. Let me give you some extra information and hints on this topic as it may cause some strange situations.… [ Read More ]

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.… [ Read More ]

Behavior Change: READ privilege for user SYSTEM in Oracle 12.2

Behavior Change: READ privilege for user SYSTEM in Oracle 12.2All credits here go to Marcel Pils from Logicalis, a German Oracle partner. Thanks Marcel! In Oracle 12.2 there’s an interesting behavior change: READ privilege for user SYSTEM in Oracle 12.2.

Some Background Information

In Oracle 12.1 the READ privilege has been introduced. Please find more information in the Oracle 12.1 Security Guide: New READ Object Privilege and READ ANY TABLE System Privilege for SELECT Operations.… [ Read More ]

UKOUG Conference TECH17 in Birmingham

UKOUG Conference TECH17 in Birmingham

UKOUG Conference TECH17 in Birmingham – Picture Source: http://tech17.ukoug.org/

The year is almost over – and I’m looking forward to my final conference this year, UKOUG Conference TECH17 in Birmingham. It will be my third UKOUG and I’m happy that the organizers have selected two of my talks.

UKOUG Conference TECH17 in Birmingham

I will present on Monday and Wednesday:

[ Read More ]