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 | Leave a comment

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 | 1 Comment

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

Licensing of Oracle Enterprise Manager Cloud Control

It is my impression that the licensing of Oracle Enterprise Manager Cloud Control is not clear to everyone. Almost every month there is a question on https://community.oracle.com/ on this topic. Let’s see what the Oracle documentation says.

Continue reading
Posted in Common | Tagged , | Comments Off on Licensing of Oracle Enterprise Manager Cloud Control

DBCA: Registering a database with OEM Cloud Control during creation

When you create a database using Database Creation Assistant (DBCA), there is this screen “Specify Management Options”. For my test database on VMs I choose “Enterprise Database Express” as a simple standalone-management option most times. But there is this other option “register databases with cloud control” – I’ve never used this option before, I always used target discovery and promotion in OEM Cloud Control.

Continue reading
Posted in Common | Comments Off on DBCA: Registering a database with OEM Cloud Control during creation