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

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

Oracle 18c Express Edition: How to create a Non-Container-Database

Oracle 18c Express Edition (XE) comes with a container database as default database. Up to 3 pluggable databases are free so XE is a good start for getting familiar with the Multitenant architecture. However, you can still run a Non-Container-Database with Oracle 18c XE. You can simply use the Database Configuration Assistant (dbca) to create such a database.

Continue reading

Posted in Common, Multitenant, Oracle 18c | Comments Off on Oracle 18c Express Edition: How to create a Non-Container-Database