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
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?
Switching a Multitenant Database to Extended Data Types
With Oracle 12c, Oracle introduced “extended data types”, which raise the limit for CHAR and VARCHAR2 datatypes from 4000 bytes to 32767 bytes. However, this is not the default setting and it takes some steps to change this setting. Especially in a Multitenant environment.