1) emcli login:
$ emcli login -username='sysman' Enter password : Login successful
2) To get all targets:
$ emcli get_targets
3) To get all the RAC databases only:
$ emcli get_targets -target='rac_database'
4) To list rac database TESTDB details:
$emcli list -resource="Targets" -search="TARGET_NAME='TESTDB'" or $emcli list -resource="Targets" -search="TARGET_NAME='TESTDB'" -format="name:csv"
5) Also we can run sql query to get target information. To check rac database TESTDB is primary or standby database:
$emcli list -sql="select TARGET_NAME,TARGET_TYPE,TYPE_QUALIFIER2 from sysman.mgmt\$target where TARGET_NAME='TESTDB'" TARGET_NAME TARGET_TYPE TYPE_QUALIFIER2 TESTDB rac_database Physical Standby Rows:1