Infrastructure at your Service

Olivier Toussaint

How to connect DbaaS in your Cloud Control 12c

Oracle provides a monitoring console in the cloud but this console gives not all the information that we need. For example, it is not possible to send an email when a problem appear.

However it is possible to use a Cloud Control on premise for monitoring this database. For that, it is necessary to have an EM12c release 5 and at least one agent installed.

How to configure a local agent

The first step is to configure a local agent to communicate with the cloud. This has to be an existing Agent. You can use any of them.

emcli login -username=sysman
Enter password
Login successful

emcli sync
Synchronized successfully

emcli register_hybridgateway_agent -hybridgateway_agent_list='emcc.example.com:3872'
Successfully registered list of agents as hybridgateways.

How to create a named credential

As it is SSH connection, it is necessary to create a named credential in the Cloud Control.

For creating the credential go to the menu Setup -> Security -> Named Credential.

screenshot_2_named_credentials

The credential is created for a global scope so that we can reuse it for all the connection.

The credential is created for a global scope as that we can reuse for all the connection

After that, click just on the save button. Do not make a test.

screenshot_1_save_credentials

screenshot_1_named_security

Installation of the agent

The installation of the agent is almost the same as for a normal agent. There are two differences, the first one is the use of an SSH connection and the second one is the use of a Hybrid Cloud Gateway Agent.
For install the agent, go to the menu Setup -> Add target -> Add Targets Manually

Choose Add Host Targets and click on the Add Host button.

screenshot_1_named_addtarget

Enter the IP public address of your compute and the platform and click next button.

screenshot_1_named_hosts

Choose where the agent must be installed, the credential created  earlier in this blog.
In the Optional Details, check the Configure Hybrid Cloud Agent, choose the agent set in Hybrid Gateway Agent and click next button.

screenshot_1_named_insert

After that, we can see a summary of the configuration. If all is ok, click on the Deploy Agent button.

screenshot_2_named_summary

The deployment has three steps. First, Cloud Control will copy the agent on the server.
Second, Cloud Control will do prerequisite tests. A warning is returned but you can continue without further.
Third, Cloud Control will deploy the agent.

screenshot_2_named_summary1

Add targets

Now that the agent is installed, we can add the targets. For this go to the menu Target -> Databases.
Choose Search List and click on the Add button.

screenshot_2_named_addtargets

Select the host where the targets are and click on the next button.

screenshot_2_named_discovers

Cloud Control finds the listener and the database. We just need to give the password for the dbsnmp account and select the target.
Click on the next button.

screenshot_2_named_results

We can see a summary of all targets. Click on the save button.

screenshot_2_named_summary2

Now the targets were added. We can use the Cloud Control as usual.

Olivier Toussaint
Olivier Toussaint

Consultant