Re: OEM Database Target Host

From: Nagaraj S <nagaraj.chk_at_gmail.com>
Date: Tue, 9 Feb 2016 08:23:39 +0530
Message-ID: <CAG6s0C1-+-dam-W2AnSJyMR7104yuropTBgF6virmpugrCf-5A_at_mail.gmail.com>

Alone with it I need to get the status of target like its UP, down or Agent unreachable, I checked in mgmt$target table and there is no status field do i need to build my query with any other table? Please advise

On Mon, Feb 8, 2016 at 8:19 PM, Courtney Llamas <courtney.llamas_at_oracle.com> wrote:

> 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 Tue Feb 09 2016 - 03:53:39 CET