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

Observations when upgrading to Oracle Database 18c

I recently upgraded the repository database of my Enterprise Manager Cloud Control 13.3 playground from release 12.2 to release 18.3. When checking the alert.log of my repository database – which is a Non-CDB – I found some interesting entries in the alert.log file.

Continue reading

Posted in Multitenant, Oracle 18c | Comments Off on Observations when upgrading to Oracle Database 18c