Category Archives: Common
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 … Continue reading
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.
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
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?
When creating a CDB and at least 1 PDB, DBCA creates the well known users SYS and SYSTEM and the user PDBADMIN. Where is this user created and which privileges are granted to PDBADMIN?