RE: OEM Database Target Host

From: Courtney Llamas <courtney.llamas_at_oracle.com>
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 [mailto:nagaraj.chk_at_gmail.com] 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

--

http://www.freelists.org/webpage/oracle-l Received on Mon Feb 08 2016 - 15:49:43 CET