Database Reference
In-Depth Information
■
i'm continually amazed by how few people know about these views, so take the time to examine the oracle
documentation and become familiar with them. in particular, look at the example usage documented at the end of
Chapter 18 in the
Oracle Enterprise Manager Cloud Control Extensibility Programmer's Reference
.
Tip
Troubleshooting
There is one more utility that you should be familiar with, which is used for troubleshooting across all three layers
of the stack. That tool is EMDIAG. EMDIAG is a collection of scripts and tools designed to help troubleshoot and
diagnose problems with EM. Each EM tier has a specific kit: AGTVFY for the agent tier, OMSVFY for the OMS tier, and
REPVFY for the repository tier, each of which will identify known issues by looking for known problem signatures.
Oracle Support has an EMDIAG Master Index note (Note 421053.1) that explains how to download, install, and use
each kit. Be sure to download the correct version for EM12c.
Each kit is a set of commands that you can use for displaying information about the setup, configuration, and use
of a relevant tier, or to dump objects. They can even be used when the tier itself is not running (or indeed when it is
broken). When you run these commands, you can pass a level from 0 to 9 into them like this:
$ ./agtvfy verify all -level 2 details
When a command takes a level as a parameter, you should start with the lowest value (0), fix issues that are
reported from that command, and then run it again at the next highest level. Levels from 0 to 4 report functional
issues, 6 to 8 are reporting issues, and 9 is for internal diagnostics. You should run the reports at level 9 only under
guidance from Oracle Support. Just as an example, here's the sort of difference you can expect between (for example)
level 2 and level 9 when running REPVFY:
■
Note
this is a purposefully badly set up environment. hopefully, you won't see anywhere near this level of problems!
$ ./repvfy verify all -level 2 details
Please enter the SYSMAN password:
-- --------------------------------------------------------------------- --
-- REPVFY: 2013.0327 Repository: 12.1.0.2.0 04-Apr-2013 16:14:52 --
---------------------------------------------------------------------------
verifyAGENTS
0001. Agents without a host target: 2
1005. Active Agents with clock-skew problems: 1
2001. Managed Agents without a managed ORACLE_HOME: 2
verifyASLM
verifyAVAILABILITY
verifyBLACKOUTS
verifyCAT
verifyCORE
0003. Invalid objects in EM schemas: 2
verifyECM
