Tuesday, February 18, 2014

I've just finished to setup at home an Oracle Real Application Clusters virtual environment formed by two nodes.

I would like to monitor and eventually execute some commands from another machine where I've installed the latest (at the moment of this post of course) available Enterprise Manager Cloud Console 12c that is Oracle Enterprise Manager Cloud Control 12c Release 3 Plug-in Update 1 (12.1.0.3) which contains the original 12c Release 3 (12.1.0.3) software binaries along with a few new plug-ins and updated plug-in versions.

I would like to compare the easy way to manage a Real Application Clusters from a GUI solution against the classic command line interface (CLI).

After I successfully deployed the agents from my Enterprise Manager Clod Control machine to the two target RAC nodes whenever I tried to perform some operations they resulted in the following error:
ERROR: NMO not setuid-root (Unix-only)

The following steps helped me to solve the problem.

On my nodes (demorac01 and demorac02) I created a local directory where EMCC deployed the agent.
Let's have a look at the content of that directory in the second node:

So both agents are now running again on the RAC nodes. Let's verify that I solved my issue directly from the Enterprise Manager Cloud Control: the error "NMO not setuid-root (Unix-only)" was thrown the first time when I tried to start up a pluggable database.

Let's do the same step again. Here is the current situation: a CDB in open mode and the pluggable database PDB001 not open.

Click on the target name link named "DEMO.demorac_PDB001". It will open the following screenshot and information: "Database is not open. Regions that fetch real-time data from target database will not be displayed"

So I want to open that PDB. Point your mouse over "Oracle Database" menu, then "Control" and finally "Open/Close Pluggable Database".

Give the credentials to access the remote Oracle database.

It seems to work because the Enterprise Manager Cloud Console is currently showing a new page.

Because I want to open the pluggable database PDB001 on both the available instances I select both instances using the CTRL button, and then clicked on "Open" from the Action menu.

A new browser page will show the status of the operation in progress.

When the operation terminates successfully the "Open/Close Pluggable Database" page will show that the status of the pluggable database PDB001 is now OPEN.

Clicking on the target link of the pluggable database named "DEMO.demorac_PDB001" will show new activities are performed and so collected from the agent.