You’ll want to select target_type = oracle_database, and get the host_name…
Select distinct host_name from mgmt$target where target_type =
'oracle_database';
From: Nagaraj S [mailto:nagaraj.chk@xxxxxxxxx] ;
Sent: Monday, February 08, 2016 4:10 AM
To: oracle-l
Subject: OEM Database Target Host
Good Morning All,
We have middleware ,database and application hosts targets monitored in OEM12c
and I have a situation to pull the list of database host, I tried by issuing
emcli get_targets -noheader -script -targets=host, it shows all the
targets(Middleware, Database and Application). Is there any way I we can get
only database host using emcli or by querying internal tables? Thanks in Advance
-Naga