Monitoring the Hosting Platform - Expert Consolidation in Oracle Database 12c - page 309

collect. For example, if a tablespace is 75% full you might want to issue a warning. If the tablespace gets up to 85% you
may want to report a critical condition back.
Administration Groups are not limited to a flat hierarchy. You can create arbitrarily complex group mappings
based on multiple target properties. If you wanted different monitoring templates for production databases in EMEA
from AMERICAS then you could create a hierarchy consisting of the lifecycle status and location. The basic principle
however is identical for simple and complex setups, which is why you will only find a hierarchy with a maximum
depth of one in this section.

Assign Extended Properties to a Database
The addition of properties to the database targets is a prerequisite for the implementation of Administration
Groups. Although that task can be performed using the Enterprise Manager Console, it is easier to do it on the
command line, especially for a large number of targets. Connect to one of your management servers as the oracle
user, and then check which properties can be associated with the database target after logging in as sysman or
another super administrator:

[oracle@oem12oms1 ~]$ emcli login -username=sysman
Enter password

Login successful
[oracle@oem12oms1 ~]$ emcli get_target_properties -target_type="oracle_database"
Comment
Contact
Cost Center
Customer Service Identifier
Department
LifeCycle Status
Line of Business
Location
Operating System
Platform
Target Version
Target properties fetched successfully

The property chosen for this example will be “LifeCycle Status”. The syntax to set the Lifecycle Status for a
database system “emrep_sys” is shown here:

[oracle@oem12oms1 ~]$ emcli set_target_property_value \
-property_records=" emrep_sys :oracle_dbsys:LifeCycle Status:Production" \
-propagate_to_members

The following values are accepted for the LifeCycle Status property in descending order of priority:

• Mission Critical

• Production

• Staging

• Test

• Development

• None