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

File ownership after patching or relinking Oracle RDBMS software

Some time ago I received the warning message “chmod: changing permissions of ‘/u00/app/oracle/product/11.2.0.4/bin/extjobO’: Operation not permitted” when patching the Oracle RDBMS at a customer site. This was the reason for me, to check what happens to file permissions and ownership when patching or relinking Oracle RDBMS software.

Continue reading
Posted in Common | Comments Off on File ownership after patching or relinking Oracle RDBMS software

Oracle 18c Express Edition: How to create a second database

Not everything that is technically possible is allowed. And so of course for the Oracle Database 18c Express Edition the restriction is clear: “One instance per environment”. “Environment” means a VM, a physical server etc.. But maybe you can run two XE databases on one server after all? Let’s give it a try.

Continue reading

Posted in Common, Oracle 18c | Comments Off on Oracle 18c Express Edition: How to create a second database