A helpful column in Oracle database 12c: ORACLE_MAINTAINED
A few days ago I saw a query from a colleague. He wanted to exclude all Oracle-supplied schema in a Oracle 11.2 database from a query on DBA_SEGMENTS. And it came to my mind that the query is much simpler in Oracle database 12c:
CDB architecture, multitenant architecture – what’s the correct naming?
After an internal discussion, I thought about the naming conventions for database architectures in Oracle Database 12c. Many people call the “new architecture” “multitenant architecture”. This can result in some confusion because the “Multitenant Option” is an extra-cost option of the Oracle Database and so people stop thinking about the new architecture because they think…
Change the OS groups for SYSDBA, SYSOPER, SYSBACKUP, SYSDG and SYSKM
Oracle 12c allows you the separate the DBA tasks backup (RMAN), DataGuard and key management (Transparent Data Encryption) between different OS users. This is not required, but can be helpful. Sometimes these groups are not available when you install the Oracle software or you decide later to separate the duties. Oracle 12c erlaubt die Aufteilung…