RE: OEM Monitoring Templates
Date: Mon, 5 Jun 2017 16:05:00 +0000
Message-ID: <258575162B63424EB58DAE3A5475B6ED0124CD81F1_at_EXNJMB25.nam.nsroot.net>
My team was recently split into Production and Testing support teams. The person who set up OEM is in the testing team. I reached out to him as to the setup. Individual instances do not have templates. He created them in groups and assigned them to different instances. For example, mission critical instances had lower thresholds than data warehouses. I think the issue is –type. In my case it is correct that the template is not for the oracle_instance.
Liz
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Niall Litchfield
Sent: Monday, June 05, 2017 5:31 AM
Cc: courtney.llamas_at_oracle.com; oracle-l_at_freelists.org
Subject: Re: OEM Monitoring Templates
You are supposed to supply the template name and target type I believe. Having said that I get the same result as you. Results below from an old test system on 11.2.0.3 and 12.1.0.4 repo.
$repvfy dump template -type rac_database -name DB_CLUSTER_ADVANCED
SQL*Plus: Release 11.2.0.3.0 Production on Mon Jun 5 10:24:42 2017
Copyright (c) 1982, 2011, Oracle. All rights reserved.
SQL> Connected.
Session altered.
Session altered.
[----- REPVFY Version details -----------------------------------------------]
COMPONENT INFO
------------------ ---------------------------------------- EMDIAG Version 2017.0206 Repository Version 12.1.0.4.0 Database Version 11.2.0.3.0 Test Version 2017.0510
Repository Type CENTRAL
5 rows selected.
[----------------------------------------------------------------------------]
[----- Template Analysis ----------------------------------------------------]
[----------------------------------------------------------------------------]
analyzeTemplate
----. done...
PL/SQL procedure successfully completed.
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options
$
The log file generated in EMDIAG_HOME/log shows that my template is picked up, but the internal diags procedure doesn't actually return any rows.
- -- --------------------------------------------------------------------- --
- -- REPVFY: 2017.0206 Repository: 12.1.0.4.0 05-Jun-2017 10:24:42 --
- ---------------------------------------------------------------------------
- -- Visit My Oracle Support for a newer version of repvfy --
- -- --------------------------------------------------------------------- --
_at_*******/emdiag/12cR1/_template.sql "C4C74C95377442EB3BC59660B8ACE5D2"
[----- REPVFY Version details -----------------------------------------------]
COMPONENT INFO
------------------ ---------------------------------------- EMDIAG Version 2017.0206 Repository Version 12.1.0.4.0 Database Version 11.2.0.3.0 Test Version 2017.0510
Repository Type CENTRAL
5 rows selected.
[----------------------------------------------------------------------------]
[----- Template Analysis ----------------------------------------------------]
[----------------------------------------------------------------------------]
analyzeTemplate
----. done...
PL/SQL procedure successfully completed.
SPOOL OFF On Thu, Jun 1, 2017 at 9:28 PM, Reen, Elizabeth <dmarc-noreply_at_freelists.org<mailto:dmarc-noreply_at_freelists.org>> wrote:
I’m missing something here. I don’t seem to get any output.
->/optware/oracle/11.2.0.4/db/emdiag/bin<https://urldefense.proofpoint.com/v2/url?u=http-3A__11.2.0.4_db_emdiag_bin&d=DwMFaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=ZuT1XeWrrDLtmItJm5njOhjIxNHJAqzXARBRTRVz3bg&s=EZyWLaF-L7HxHrlTkp5sEemXNlySkNf5Ow_A_oZQ9rc&e=>> ./repvfy dump template
Please enter the SYSMAN password:
SQL*Plus: Release 11.2.0.4.0 Production on Thu Jun 1 16:24:22 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
SQL> Connected.
Session altered.
Session altered.
[----- REPVFY Version details -----------------------------------------------]
COMPONENT INFO
------------------ ---------------------------------------- EMDIAG Version 2016.0426 Repository Version 12.1.0.4.0 Database Version 11.2.0.4.0 Test Version 2017.0601
Repository Type CENTRAL
5 rows selected.
[----------------------------------------------------------------------------]
[----- Template Analysis ----------------------------------------------------]
[----------------------------------------------------------------------------]
analyzeTemplate
PL/SQL procedure successfully completed.
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning option
Liz
Elizabeth Reen
CPB Database Group Manager
718.248.9930<tel:(718)%20248-9930> (Office)
Service Now Group: CPB-ORACLE-DB-SUPPORT
From: oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org> [mailto:oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org>] On Behalf Of Courtney Llamas Sent: Thursday, June 01, 2017 4:07 PM
To: dmarc-noreply_at_freelists.org<mailto:dmarc-noreply_at_freelists.org>; oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org> Subject: RE: OEM Monitoring Templates
Most the documentation is in the tool itself,
./repvfy dump >> will show you all available modules to dump ./repvfy dump template >> will show you the options…
$ repvfy dump template -name <template name> -type <target type> -owner <template owner>
Type would be oracle_database, host, etc… depending on what type of templates you have…
--
- Courtney
[Oracle]<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.oracle.com_&d=DwMFAg&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=w1spklyB9vt-UXUlnwi-B8GLkiiWmsTZoVzfGkfLoig&s=aO63sZc3NLLO3eXH40JnZjxlIc9u5O5LZT5Z-5WaY3k&e=>
Courtney Llamas | Consulting Member of Technical Staff
Phone: +2814108258<tel:+2814108258> | Mobile: +8324720596<tel:+8324720596>
Oracle Strategic Customer Program
Oracle is committed to developing practices and products that help protect the environment
From: Reen, Elizabeth [mailto:dmarc-noreply_at_freelists.org]
Sent: Thursday, June 01, 2017 2:53 PM
To: Courtney Llamas; oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>
Subject: RE: OEM Monitoring Templates
Courtney,
First thanks for pointing me to this wonderful tool. I’m having problems with the –type option. What should I put there? Can you point me to where it is documented?
Liz
Elizabeth Reen
CPB Database Group Manager
718.248.9930<tel:(718)%20248-9930> (Office)
Service Now Group: CPB-ORACLE-DB-SUPPORT
From: oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Courtney Llamas
Sent: Thursday, June 01, 2017 10:41 AM
To: dmarc-noreply_at_freelists.org<mailto:dmarc-noreply_at_freelists.org>; oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>
Subject: RE: OEM Monitoring Templates
Download EMDIAG https://updates.oracle.com/OCDoctor/repvfy12.zip<https://urldefense.proofpoint.com/v2/url?u=https-3A__updates.oracle.com_OCDoctor_repvfy12.zip&d=DwMFAg&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=AuODdtuLEJ4CTnk94-9Z9rcKjnTjjayC7gv2Be-xfTE&s=Vyur-7Zk8BWDWiWk67G-i1-M-CmQpddKrOQUCICQI1c&e=>
repvfy dump template -name <template name> -type <target type> -owner <template owner>
--
- Courtney
[Oracle]<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.oracle.com_&d=DwMFAg&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=AuODdtuLEJ4CTnk94-9Z9rcKjnTjjayC7gv2Be-xfTE&s=2dYQO5ssy2ia3vURAoC1aa12-FxI8eQf9Bnq-6zc5CY&e=>
Courtney Llamas | Consulting Member of Technical Staff
Phone: +2814108258<tel:+2814108258> | Mobile: +8324720596<tel:+8324720596>
Oracle Strategic Customer Program
Oracle is committed to developing practices and products that help protect the environment
From: Reen, Elizabeth [mailto:dmarc-noreply_at_freelists.org]
Sent: Thursday, June 01, 2017 9:37 AM
To: oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>
Subject: OEM Monitoring Templates
Is there any way to get a report of what is being monitored, how often, and the threshold settings? My auditors want a document of our health check process. If I could get the tables in OEM, I would be able to create a report from the sql level.
Liz
--
Niall Litchfield
Oracle DBA
http://www.orawin.info<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.orawin.info&d=DwMFaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=ZuT1XeWrrDLtmItJm5njOhjIxNHJAqzXARBRTRVz3bg&s=Q8Tq2pGdD19M6LgQNCtjPUAjK3RCJG0VNUpP0dUFio0&e=>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jun 05 2017 - 18:05:00 CEST
![]()
(image/gif attachment: image001.gif)
![]()
(image/gif attachment: image002.gif)