Re: OEM Monitoring Templates

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Mon, 5 Jun 2017 10:31:08 +0100
Message-ID: <CABe10sYBkKAACqt5qaFQGLMMo0YKKeHSv3_LRQNyfoC9_mkxBw_at_mail.gmail.com>

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

SQL> Connected.

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 > wrote:

>             I’m missing something here. I don’t seem to get any output.
>
>
>
> *->/optware/oracle/11.2.0.4/db/emdiag/bin
> <http://11.2.0.4/db/emdiag/bin>>  ./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 <(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] *On Behalf Of *Courtney Llamas
> *Sent:* Thursday, June 01, 2017 4:07 PM
>
> *To:* dmarc-noreply_at_freelists.org; 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
>
> [image: 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 | Mobile: +8324720596
> Oracle Strategic Customer Program
>
> Oracle
>
> [image: 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_at_freelists.org
> <dmarc-noreply_at_freelists.org>]
> *Sent:* Thursday, June 01, 2017 2:53 PM
> *To:* Courtney Llamas; 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 <(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 <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; 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
>
> [image: 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 | Mobile: +8324720596
> Oracle Strategic Customer Program
>
> Oracle
>
> [image: 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_at_freelists.org
> <dmarc-noreply_at_freelists.org>]
> *Sent:* Thursday, June 01, 2017 9:37 AM
> *To:* 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










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







(image/gif attachment: image002.gif)




(image/gif attachment: image001.gif)

Received on Mon Jun 05 2017 - 11:31:08 CEST

This message: [ Message body ]
Next message: Reen, Elizabeth : "RE: How enforce uniqueness across partitions in the partition table?"
Previous message: dedba_at_tpg.com.au: "Re: Issue with plsql declaration"
In reply to: Reen, Elizabeth : "RE: OEM Monitoring Templates"
Next in thread: Reen, Elizabeth : "RE: OEM Monitoring Templates"
Reply: Reen, Elizabeth : "RE: OEM Monitoring Templates"
Reply: Herring, David: "RE: OEM Monitoring Templates"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message