Patching OEM 13c Cloud Control Release 2

Some days ago, Oracle released a new bundle for Oracle Enterprise Manager 13.2 (Patch# 25990918). This was the reason for me to update my local test and play OEM system on my local Linux system. Continue reading

Posted in Common | Tagged , , , , , | Leave a comment

DBCA 12.2 runs datapatch automatically

It was one of the issues with Oracle 12c Release 1 that datapatch was not executed by dbca automatically. So, if you had installed patches to your Oracle home before running dbca, dbca did not take this into consideration and ran datapatch to apply the SQL changes to the databases. In August 2015 Mike Dietrich wrote a blog post on this issue.

Continue reading

Posted in Common, Oracle 12c | Tagged , , | Comments Off on DBCA 12.2 runs datapatch automatically

Interval-Reference-Partitioning: Partition-Merge and Row-Movement

As often, I use this blog to answer questions of training participants. This time, it’s the question what happens on interval-reference-partitioned tables when merging partitions or when updates cause row movement.
Continue reading

Posted in Common, Oracle 12c | Comments Off on Interval-Reference-Partitioning: Partition-Merge and Row-Movement

Which node is the OCR master node (AKA “OCR writer”) in a RAC?

There are several ways to answer this question:

  • Look for “OCR master” in the log files of crsd and check olsnodes for the node ID
  • Check which node did the most recent automatic OCR backup

Continue reading

Posted in Common, RAC | Comments Off on Which node is the OCR master node (AKA “OCR writer”) in a RAC?

ORACLE_MAINTAINED database users, part 2

Some time ago I wrote on ORACLE_MAINTAINED database users in Oracle 12c. Next question is: how are these users connected to database features and can the users be dropped – and if yes, how?

Continue reading

Posted in Common, Oracle 12c | Comments Off on ORACLE_MAINTAINED database users, part 2