Niall,
I can only agree. I would recommend never configuring targets directly (except
for individual overrides) and only using templates - even if you only have 1
occurrence of the target type.
The effort overhead of using templates is low and the benefits high.
Regards
Neil.
sent from my phone
On 21 Jun 2016, at 15:54, Niall Litchfield <niall.litchfield@xxxxxxxxx> wrote:
The repository views are documented at
http://docs.oracle.com/cd/E24628_01/doc.121/e57277/toc.htm ;(for 12).
That said I wouldn't have solved your issues in the way that you did, but
rather by defining an appropriate monitoring template for targets of type
oracle_listener. That way not only do you ensure that you apply this setting,
but also that any new targets will have the same settings. Setting up a set
of template collections is a reasonable amount of work, but its definitely
the way to go.
On Tue, Jun 21, 2016 at 3:23 PM, Chris Taylor
<christopherdtaylor1994@xxxxxxxxx> wrote:
Ok, that gives me what I needed.
How did you know to pull that out that information that way? Just exploring
the repository or did you find it documented somewhere? That is VERY useful!
Chris
On Tue, Jun 21, 2016 at 9:16 AM, Le, Binh T. <Binh.Le@xxxxxxx> wrote:
Hi Chris,
Try this:
select './emcli modify_threshold -target_name="'|| tms.target_name || '"
-target_type="'|| tms.target_type||
'" -metric="'|| replace(tms.metric_name,'$','\$') ||
'" -column="'|| tms.metric_column ||'" -key_columns=";"
-critical_threshold="TNS-[ ]*0*(1169|1189|12508" -prevent_override="0" '
stmt
,tms.target_name,tms.target_type,tms.metric_name,tms.metric_column,tms.collection_name,tms.warning_operator,tms.warning_threshold
,tms.critical_operator,tms.critical_threshold,tms.warning_action_type,tms.warning_action_job_type,tms.warning_action_job_owner,tms.key_value
from sysman.mgmt$target_metric_settings tms
where tms.target_type in ('oracle_listener')
and tms.metric_name = 'TNS_ERRORS'
and tms.metric_column = 'tnserrmsg'
and instr(target_name,'SCAN') = 0
order by tms.target_name;
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] ;
On Behalf Of Chris Taylor
Sent: Tuesday, June 21, 2016 9:58 AM
To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
Subject: 12c EMCLI help needed (I'm almost there, but not quite ...)
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
Notice of Confidentiality: **This E-mail and any of its attachments may
contain
Lincoln National Corporation proprietary information, which is privileged,
confidential,
or subject to copyright belonging to the Lincoln National Corporation
family of
companies. This E-mail is intended solely for the use of the individual or
entity to
which it is addressed. If you are not the intended recipient of this
E-mail, you are
hereby notified that any dissemination, distribution, copying, or action
taken in
relation to the contents of and attachments to this E-mail is strictly
prohibited
and may be unlawful. If you have received this E-mail in error, please
notify the
sender immediately and permanently delete the original and any copy of this
and any printout. Thank You.**
--
Niall Litchfield
Oracle DBA
http://www.orawin.info