Author Archives: Markus Flechtner

DOAG conference 2019: Privilege Analysis

Thanks to everyone who attended my session on Privilege Analysis with the Oracle Database. Here you can find the slides.

Posted in Common | Comments Off on DOAG conference 2019: Privilege Analysis

Oracle Database 19c Multitenant: now 3 PDBs allowed without Multitenant Option

According to the updated licensing information for Oracle Database 19c (https://docs.oracle.com/en/database/oracle/oracle-database/19/dblic/Licensing-Information.html#GUID-0F9EB85D-4610-4EDF-8…) you can now create up to 3 PDBs in a CDB without Multitenant Option, i.e. even in SE2 (“For all offerings, if you are not licensed for Oracle Multitenant, … Continue reading

Posted in Common | Comments Off on Oracle Database 19c Multitenant: now 3 PDBs allowed without Multitenant Option

Read-Only-Oracle-Home: the follow-up post

After my recent post on read-only ORACLE_HOME I received some feedback and had some discussions with some colleagues on this topic. So I decided that another post may be helpful.

Posted in Common | Comments Off on Read-Only-Oracle-Home: the follow-up post

Oracle 18c/19c: Running a “read-only-Oracle-home” on a read-only-filesystem

In Oracle 18c Oracle introduced a new feature, called “read-only-Oracle-Home”. By configuring an Oracle-Home-directory of your RDBMS-installation as “read-only”, Oracle will place all the configuration files like spfile etc. outside the directory tree of your $ORACLE_HOME and will basically move … Continue reading

Posted in Oracle 18c, Oracle 19c | Comments Off on Oracle 18c/19c: Running a “read-only-Oracle-home” on a read-only-filesystem

Automatic Failback of a Service in a Oracle-19c-RAC-Database

High-availability of database services has been a feature of Oracle Real Application Servers since many versions. Bascially, when a database instance fails, a service which has got this instance as a preferred instance, fails over to another available instance. Unfortunately, … Continue reading

Posted in Oracle 19c, RAC | Comments Off on Automatic Failback of a Service in a Oracle-19c-RAC-Database