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, then you may have up to 3 PDBs in a given container database at any time.”). This applies to Oracle Database 19c only, the licensing restrictions for Oracle 18c weren’t changed (only 1 PDB allowed).

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.

Continue reading
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 them to “$ORACLE_BASE/dbs” and “$ORACLE_BASE/homes”. But if the software is “read-only”, can we place the $ORACLE_HOME-directory in a separate filesystem which will be mounted “read-only” during normal operation? This would help to avoid accidental modifications of an accidental removal of the software. Let’s test it. 

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, the service did not fail back to the original instance as soon as the instance is up again. The administrator had to relocate the service. This has changed with Oracle Database 19c.

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