RE: OEM Database Target Host

From: Courtney Llamas <>
Date: Mon, 8 Feb 2016 06:49:43 -0800 (PST)
Message-ID: <bf11b6b3-ddbb-4dea-9eff-7eee00de4bec_at_default>

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 [] 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



-- Received on Mon Feb 08 2016 - 15:49:43 CET

Original text of this message