EMCLI

EMCLI Commonly Used commands:

To Login to 12c emcli utility
emcli login -username=sysman -password=XXXXXX

To syncronize with OMS
$ emcli sync
Synchronized successfully

To list the targets
$emcli get_targets
To list only host targets:
$emcli get_targets -noheader -script -targets=host
To list only oracle database targets:
emcli get_targets -noheader -script -targets=oracle_database

To delete agent and its targets
emcli delete_target -name="rac1.oracle-wiki.com:3872" -type="oracle_emd" -delete_monitored_targets -async

To delete specific target
emcli delete_target -name="DV11G" -type="oracle_database"

To create a blackout 
emcli create_blackout -name="Jan2012_Maintenance" -add_targets="DV11G:oracle_database" -reason="Security Patch" -description="PSU Patch" -schedule="duration::30"

To delete a blackout
emcli delete_blackout -name="Jan2012_Maintenance"

To produce a list of your host targets, formatted for eventual input to the set_target_property_value verb
./emcli get_targets -noheader -script -targets=host | awk '{print $4":"$3":LifeCycle Status:"}' > /tmp/targets

To produce a list of your database targets, formatted for eventual input to the set_target_property_value verb
./emcli get_targets -noheader -script -targets=oracle_database | awk '{print $4":"$3":LifeCycle Status:"}' > /tmp/targets

Output:
DB1:oracle_database:LifeCycle Status:
DB2:oracle_database:LifeCycle Status:
DB3:oracle_database:LifeCycle Status:
..

To mass update targets based on an input file
$ ./emcli set_target_property_value -property_records="REC_FILE" -input_file="REC_FILE:/tmp/lifecycle_12c.txt" -separator=property_records="\n"
Properties updated successfully

To Create a groupemcli create_group -name="GROUP_NAME"

To Add members to a groupemcli modify_group -name="GROUP_NAME" -add_targets="<Target_Name>:<TargetType>;..."

To Delete members from a groupemcli modify_group -name="GROUP_NAME" -delete_targets="<Target_Name>:<TargetType>;..."

To get list of groups createdemcli get_groups

To create a useremcli create_user -name=GBATTA -privilege="SUPER_USER" -expire="true" -password="manager"

To drop a useremcli delete_user -name=GBATTA

To get info from OEM Repository about current state of your targetsemcli get_targets -targets="oracle%" -alerts -script

To execute a SQL Statement against multiple databasesemcli execute_sql -sql="SELECT col1,col2 from TABLE_NAME" -targets="GROUP_NAME" -crdential_set_name="DBCredsNormal"

To execute a OS command against multiple hostsemcli execute_hostcmd -cmd="ls -ltr" -credentail_set_name="HostCredsPriv" -targets="HOSTNAME:host"