Tags

, , ,

OEM 12c framework consists of EM agents on each of your hosts, one or more management servers (OMS), and a repository database containing tons and tons of data about your enterprise.  Most people rely on the OEM console or perhaps EM reports to get to that data – even though many EM administrators are also DBAs. The sysman schema is just too rich.  

The repository verification utility repvfy provides analysis and suggests corrective actions for a variety of common repository problems.

Repvfy installs as part of the EMDIAG utility, as described in Oracle Support Document 1426973.1 (EMDIAG REPVFY Kit for Cloud Control 12c – Download, Install/De-Install and Upgrade https://support.oracle.com/epmos/faces/DocumentDisplay?id=1426973.1.

The installation takes place in the Oracle Home for the repository database and it’s quite simple to do.

  1. Create a directory in your OH named emdiag
  2. Download the zip file into that directory and unzip it
  3. Chmod the repvfy executable so it’s executable (chmod 700 $ORACLE_HOME/emdiag/bin/repvfy)
  4. Create a configuration file by copying the template $ORACLE_HOME/emdiag/cfg/repvfy.cfg.template
  5. Edit your copy of repvfy.cfg to set the values for ora_tns as repository_host:port:sid (ora_tns=myhost:1521:orcla, f.e.)
  6. Set your O/S path to include $ORACLE_HOME/emdiag/bin
  7. Run repfvy in install mode  with repvfy install to add the collector objects to the repository

Your first analysis can be as simple a executing repvfy without any parameters

oracle@xwtcvpitdbe03b> repvfy
Please enter the SYSMAN password:
-- ---------------------------------------------------------------------
-- REPVFY: 2014.0123 Repository: 12.1.0.3.0 31-Jan-2014 13:40:02 -------
------------------------------------------------------------------------
-- Module: all Test: 0, Level: 2 ----
------------------------------------------------------------------------ verifyAGENTS
verifyASLM
verifyAVAILABILITY
1002. Disabled response metrics (16570376): 2
verifyBLACKOUTS
verifyCAT
verifyCORE
verifyECM
1002. Unregistered ECM metadata tables: 2
verifyEMDIAG
verifyEVENTS
1010. Old Messages In Event Queue: 1
verifyEXADATA
verifyJOBS
verifyJVMD
verifyLOADERS
verifyMETRICS
verifyNOTIFICATIONS
verifyOMS
verifyPLUGINS
1003. Plugin metadata versions out of sync: 1
verifyREPOSITORY
verifyTARGETS
2004. Targets without an ORACLE_HOME association: 8
2006. Targets with missing ORACLE_HOME target: 16
verifyUSERS

Now you can go to work fixing things.  Add two variables, verify and –detail.

repvfy verify -detail
Please enter the SYSMAN password: -- --------------------------------------------------------------------- --
-- REPVFY: 2014.0123 Repository: 12.1.0.3.0 31-Jan-2014 13:44:00 --
---------------------------------------------------------------------------
-- Module: Test: 0, Level: 2 --
-- --------------------------------------------------------------------- -- verifyAGENTS
verifyASLM
verifyAVAILABILITY
1002. Disabled response metrics (16570376): 2
verifyBLACKOUTS
verifyCAT
verifyCORE
verifyECM
1002. Unregistered ECM metadata tables: 2
verifyEMDIAG
verifyEVENTS
1010. Old Messages In Event Queue: 1
verifyEXADATA
verifyJOBS
verifyJVMD
verifyLOADERS
verifyMETRICS
verifyNOTIFICATIONS
verifyOMS
verifyPLUGINS
1003. Plugin metadata versions out of sync: 1
verifyREPOSITORY
verifyTARGETS
2004. Targets without an ORACLE_HOME association: 8
2006. Targets with missing ORACLE_HOME target: 16
verifyUSERS SQL*Plus: Release 11.2.0.3.0 Production on Fri Jan 31 13:44:04 2014 Copyright (c) 1982, 2011, Oracle. All rights reserved. SQL> Connected. Session altered.
Session altered. verifyAVAILABILITY
======================================================================
1002. Disabled response metrics (16570376)
=--------- ---------- ---------- ---------- ---------- ---------- ---------=
= Action:
= - Enable the 'Response' metrics for all flagged targets in the
= 'Metric Collections' page in the console
=--------- ---------- ---------- ---------- ---------- ---------- ---------= ENTITY_GUID ENTITY_NAME ENTITY_TYPE HOST_NAME COLL_NAME
E463D118E0F51D04E04312E7510A4F6D orcla rac_database somehost Response:Status:
DDE0624AE4706AE5E04312E7510AB3AC orclb rac_database someotherhost Response:Status: 2 rows selected. verifyECM
======================================================================
1002. Unregistered ECM metadata tables
-------------------------------------- TABLE_NAME COLUMN_NAME
-------------------------------- --------------------------------
MGMT_LDAP_LDAPSERVERDBINFOCC ECM_SNAPSHOT_ID
MGMT_LDAP_OIDREPLTOPOLOGY ECM_SNAPSHOT_ID 2 rows selected. verifyEVENTS
======================================================================
1010. Old Messages In Event Queue
-------------------------------------- CONSUMER_NAME CNT MIN_TIME MAX_TIME
------------------------------ ---------- -------------------- --------------------
ADM174_1 32 24-JAN-2014 14:46:47 24-JAN-2014 14:46:47 1 row selected. verifyPLUGINS
======================================================================
1003. Plugin metadata versions out of sync (14682821)
=--------- ---------- ---------- ---------- ---------- ---------- ---------=
= Action:
= - Run the fix routine:
= $ repvfy verify plugins -test 1003 -fix
=--------- ---------- ---------- ---------- ---------- ---------- ---------= ENTITY_GUID ENTITY_NAME ENTITY_TYPE MANAGE_STATUS PROMOTE_STATUS TGT_META AGENT_GUID ENTITY_NAME AGT_META
-------------------------------- ------------------------------------------------------------ ------473843ED3AABE9806107AE33A66E75DE orclc cluster 2 3 7.2 26EC3DF9E3582DA2EDC5B0BE549E87B3 anotherhost:3872 7.1 1 row selected. verifyTARGETS
======================================================================
2004. Targets without an ORACLE_HOME association
------------------------------------------------ ENTITY_GUID ENTITY_NAME ENTITY_TYPE HOST_NAME ORACLE_HOME
-------------------------------- ------------------------------------------------------------ ------473843ED3AABE9806107AE33A66E75DE clstrp cluster somehostp /gridbase/product/11.2.0.3
AB6BE2C4DED0BCC6ECE296847B9FA30C /ODSM_anotherhost_IDMDomain/IDMDomain/AdminServer/FMW Welc j2ee_application anotherhost /orabase/Middleware/oracle_common
2 rows selected. 2006. Targets with missing ORACLE_HOME target
=--------- ---------- ---------- ---------- ---------- ---------- ---------=
= Action:
= - Add the missing ORACLE_HOME target.
= - In the console:
= * Setup -> Add Targets -> Add Targets Manually
= * Select the 'Add Non-Host Targets by Specifying Target Monitoring
= Properties' radio button
= * Select 'Oracle Home' from the type drop down list
= * Use the search to specify the Agent to add the home target on
= * Click 'Add Manually'
= * Fill in the properties on the next page
= * Expand the 'Global Properties' tab, to set the target properties
= (in case Administration Groups are used)
= * Click OK on the upper right of the screen
=--------- ---------- ---------- ---------- ---------- ---------- ---------= HOST_NAME ORACLE_HOME ENTITY_GUID ENTITY_NAME ENTITY_TYPE
------------------------------------------------------------ ---------------------------------------
stillanotherhost /orabase/product/12103/Middleware/wlserver_10.3 7534696487B4535AAF1D05BE18E0FA94 /EMGC_GCDomain/GCDomain/EMGC_OMS2 weblogic_j2eeserver
manymanyhosts /orabase/product/12103/Middleware/Oracle_WT 74372ED9FBAC0AEFD243556046A09C47 /EMGC_GCDomain/instance3/ohs3 oracle_apache 2 rows selected. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning and Real Application Clusters options

As you can see, several trips to repository were made using the SQL+ in this Oracle Home.  Notice that the problems are summarized and then details are provided to support the corrective actions they suggest.

Something tells me there’s more to come on this topic …