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.

But when you want to use this option, there are these four data field which have to be entered:

  • EM Host
  • EM Port
  • EM Admin User
  • EM Admin Password

The first is obvious. The second is the upload port of your OEM Cloud Control (repository port). You can find this port when checking the status of the OEM agent on your database server (of course, a running OEM agent on your database server is a prerequisite for this procedure):

oracle@dbserver:~/ [emagent13c_a] emctl status agent
Oracle Enterprise Manager Cloud Control 13c Release 3
Copyright (c) 1996, 2018 Oracle Corporation. All rights reserved.
Agent Version : 13.3.0.0.0
OMS Version : 13.3.0.0.0
Protocol Version : 12.1.0.1.0
Agent Home : /u00/app/oracle/product/agent13cr3/agent_inst
Agent Log Directory : /u00/app/oracle/product/agent13cr3/agent_inst/sysman/log
Agent Binaries : /u00/app/oracle/product/agent13cr3/agent_13.3.0.0.0
Core JAR Location : /u00/app/oracle/product/agent13cr3/agent_13.3.0.0.0/jlib
Agent Process ID : 10254
Parent Process ID : 9533
Agent URL : https://dbserver.domain.local:3872/emd/main/
Local Agent URL in NAT : https://dbserver.domain.local:3872/emd/main/
Repository URL : https://oemserver.markusdba.local:4903/empbs/upload
Started at : 2019-04-18 23:02:08
Started by user : oracle
Operating System : Linux version 4.14.35-1844.4.5.el7uek.x86_64 (amd64)
Number of Targets : 26
Last Reload : (none)
Last successful upload : 2019-04-18 23:07:10
Last attempted upload : 2019-04-18 23:07:10
Total Megabytes of XML files uploaded so far : 0.04
Number of XML files pending upload : 0
Size of XML files pending upload(MB) : 0
Available disk space on upload filesystem : 46.40%
Collection Status : Collections enabled
Heartbeat Status : Ok
Last attempted heartbeat to OMS : 2019-04-18 23:08:15
Last successful heartbeat to OMS : 2019-04-18 23:08:15
Next scheduled heartbeat to OMS : 2019-04-18 23:09:15

Agent is Running and Ready

So in my case, the port is 4903. For EM Admin user and password I choose SYSMAN:

And after DBCA has completed its work and the database is ready, you’ll find the database as a target in your OEM cloud control. No target discovery, no target promotion.

And – on the other hand – when you delete a database with DBCA, you can remove the OEM target, too:

Posted in Common | Leave a comment

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