RE: OEM Monitoring Templates

  • From: "Reen, Elizabeth " <dmarc-noreply@xxxxxxxxxxxxx> (Redacted sender "elizabeth.reen" for DMARC)
  • To: "'niall.litchfield@xxxxxxxxx'" <niall.litchfield@xxxxxxxxx>
  • Date: Mon, 5 Jun 2017 16:05:00 +0000

            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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On ;
Behalf Of Niall Litchfield
Sent: Monday, June 05, 2017 5:31 AM
Cc: courtney.llamas@xxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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                 --
-- -- --------------------------------------------------------------------- --
@*******/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@xxxxxxxxxxxxx<mailto:dmarc-noreply@xxxxxxxxxxxxx>> 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@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx> 
[mailto:oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>] On 
Behalf Of Courtney Llamas
Sent: Thursday, June 01, 2017 4:07 PM

To: dmarc-noreply@xxxxxxxxxxxxx<mailto:dmarc-noreply@xxxxxxxxxxxxx>; 
oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>
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
[Green 
Oracle]<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.oracle.com_commitment&d=DwMFAg&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=w1spklyB9vt-UXUlnwi-B8GLkiiWmsTZoVzfGkfLoig&s=4ZbcARHdC9lMh5deUTnVjByHaAdfJ2BAUYBb9GcnMGg&e=>

Oracle is committed to developing practices and products that help protect the 
environment


From: Reen, Elizabeth [mailto:dmarc-noreply@xxxxxxxxxxxxx]
Sent: Thursday, June 01, 2017 2:53 PM
To: Courtney Llamas; oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx> 
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Courtney Llamas
Sent: Thursday, June 01, 2017 10:41 AM
To: dmarc-noreply@xxxxxxxxxxxxx<mailto:dmarc-noreply@xxxxxxxxxxxxx>; 
oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>
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
[Green 
Oracle]<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.oracle.com_commitment&d=DwMFAg&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=AuODdtuLEJ4CTnk94-9Z9rcKjnTjjayC7gv2Be-xfTE&s=2LxNhleHavGwwy093IxkPYvO_MpwCuj6Sxp4k6GSZmc&e=>

Oracle is committed to developing practices and products that help protect the 
environment


From: Reen, Elizabeth [mailto:dmarc-noreply@xxxxxxxxxxxxx]
Sent: Thursday, June 01, 2017 9:37 AM
To: oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>
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=>

GIF image

GIF image

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 06-2017