Database Reference
In-Depth Information
Global Diagnostics
In this example, we will run a level-9 diagnostic, which will run a report against the whole of the Enterprise Manager
environment, checking the health and other issues:
./repvfy -tns em12rep verify -level 9 -detail
The first thing this level of diagnostic does is check the version of EMDIAG you are using and whether a newer
version is available as an update.
The diagnostics then proceed to perform a full verification of the EM environment, as shown in Figure
11-45
,
before logging in to SQL*Plus to perform the secondary diagnostics on the EM testing, the installation information
about the EM system, and internal jobs and alerts from the EM environment.
Figure 11-45.
Global-level diagnostics displaying metric collection issues from the EMDIAG
The diagnostic proceeds through all promoted and unpromoted targets, makes recommendations on changes,
and then ends the report by verifying any nonstandard EM users, as demonstrated in Figure
11-46
.
Figure 11-46.
Recommendations to verify users for nonstandard EM system accounts
We can query the data from the
MGMT_JOB
table again in the
SYSMAN
schema to look at backup jobs that are not
one-time jobs (
status<>2
).
select job_name, job_id
from SYSMAN.MGMT_JOB
where job_name like '%BACKUP%'
and job_status <> 2;
Figure
11-47
shows the results of the query.
