12c EMCLI help needed (I'm almost there, but not quite ...)

From: Chris Taylor <christopherdtaylor1994_at_gmail.com>
Date: Tue, 21 Jun 2016 08:57:46 -0500
Message-ID: <CAP79kiT_LKUr5aJAZmknMNkPqdHr-DgTJCdB8hvtPnodBOoz_Q_at_mail.gmail.com>

We run multiple listeners and I need to remove the TNS-1190 from each listener and I want to use EMCLI to do it.

I run this:

 emcli get_threshold -target_type="oracle_listener" -target_name= LISTENER_myhost.mydomain.org

Which gives me this: http://pastebin.com/RhHRqjqZ

Now, I want to use emcli to modify the threshold but I'm getting an error.

Here's what I run followed by the error - so I need to know what I should be providing as I'm stumped?

./emcli modify_threshold -target_type="oracle_listener" -metric="TNS_ERRORS : tnserrmsg" -critical_threshold="TNS-[ ]*0*(1169|1189|12508)" -target_name= LISTENER_myhost.mydomain.org

Returns:
Error: Either Metric Group or Metric Column not provided.

So I tried providing the column name:
emcli modify_threshold -target_type="oracle_listener" -metric="TNS_ERRORS : tnserrmsg" -column="Metric Internal Name" -critical_threshold="TNS-[ ]*0*(1169|1189|12508)" -target_name=LISTENER_myhost.mydomain.org

And I get:
Error: Metric Group "TNS_ERRORS : tnserrmsg" or Metric Column "Metric Internal Name" does not exist for target type "oracle_listener"

Any helps/tips/suggestions - I can't figure out what should be for the "-metric" and the "-column" fields on this.

Thanks!
Chris

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jun 21 2016 - 15:57:46 CEST