As soon as you enable the Database Lifecycle Management Pack; Oracle Enterprise Manager will automatically collect hundreds of configuration items of your database estate. However if you need to customize this collection, Configuration Extensions provide a way to identify files and other configuration data that Cloud Control does not already collect.
In this blog, I’ll show you how I created a Configuration Extension (CE) in order to collect DB Services data.
CE’s are found under the Enterprise -> Configuration menus.
While in the CE dashboard, you can create, edit, delete and deploy CE’s using the available menu.
Let’s click the “Create” button.
Using the CE create wizard type a name for the CE, a target type and a Sample Target. As soon as you select “Database Instance” for the Target Type a new option will enable. This option is to select between “Files & Commands” or “SQL”.
In this example I’m going to choose “SQL” and then type the required SQL required to retrieve the data I need from the DB. Let’s type “select name as service_name from dba_services”. Also type “service_name” in the alias section and choose the “Database Query Parser”.
The entries should look similar to the screenshot above.
The data extracted from the DB in the CE is in XML format. We need to add parser rules in order to match and identify nodes in the parsed tree. Click on the number of “Rules” in the table. In this case click on the number “0”.
On the Parser Rule page click “Add” and type this condition and expression:
- Condition: /root/row
- Expression: SERVICE_NAME/text()
This will allow the parser to use the text inside the SERVICE_NAME node as the name of the row. Click the return button.
Now we can click on the “Preview” button from the menu.
It will show you the preview output. Similar like this:
Click “OK” and then click “Save”.
Select your newly created CE and click on “Manage Deployments” button. Select the targets where you want to deploy the CEs and click “Apply”.
It will look similar to the screen below:
Navigate to the configuration of your target and verify the CE is correctly pulling the desired configuration data.
Now we have our CE correctly gathering the desired configuration data of our DB.
You can find the documentation for Configuration Extensions below.
Hope this helps to provide some clarity on how to create Configuration Extensions in Oracle Enterprise Manager.
Thanks,
Alfredo