Category Archives: Oracle 12c

Oracle Multitenant – SYS*-privileges on PDB level

In an Oracle Container Database, SYSDBA, SYSDG, SYSBACKUP etc. privileges can be granted on PDB level. This enables PDB administrators with their local users e.g. to open and to close a PDB. How does this work and where is this … Continue reading

Posted in Multitenant, Oracle 12c | Comments Off on Oracle Multitenant – SYS*-privileges on PDB level

OUGN Spring Seminar 2018: Presentation “Domain Services Cluster”

Thanks to everyone, who attended my presentation on “The 3 investigators” (OraChk, TFA and DBSAT) at the OUGN Spring Seminar 2018 on “MS Color Fantasy“. Here you can find the presentation.

Posted in Common, Oracle 12c, RAC | Tagged , , , | Comments Off on OUGN Spring Seminar 2018: Presentation “Domain Services Cluster”

Setting OPTIMIZER_ADAPTIVE_FEATURES in Oracle Database 12c Release 2

In Oracle Database 12c Release 2 the parameter OPTIMIZER_ADAPTIVE_FEATURES was declared “Obsolete”. It was replaced by the parameters optimizer_adaptive_statistics, optimizer_adaptive_plans and AUTO_STAT_EXTENSIONS to allow better control of the adaptive features of the optimizer but what happens, if you try the … Continue reading

Posted in Oracle 12c | Tagged , | Comments Off on Setting OPTIMIZER_ADAPTIVE_FEATURES in Oracle Database 12c Release 2

Patching Oracle 12.2 Grid Infrastructure before setting up a cluster

One of the first steps after setting up an Oracle cluster is patching the Grid Infrastructure to the most current patchlevel. Usually this has to be done on all cluster nodes separately and requires some time and effort. But what … Continue reading

Posted in Common, Oracle 12c, RAC | Tagged , | Comments Off on Patching Oracle 12.2 Grid Infrastructure before setting up a cluster

New kid on the block – let’s install “Database Release Update 12.2.0.1.170718”

At the DOAG database conference in May, Andrew Mendelsohn announced that Oracle will change the release schedule to annual releases and that patch naming will be changed to “Release Updates” (RU). The latter started – as announced – in July … Continue reading

Posted in Common, Oracle 12c | Tagged , , | Comments Off on New kid on the block – let’s install “Database Release Update 12.2.0.1.170718”