Database Reference
In-Depth Information
x86_64-linux-thread-mult
PERL 5.10.0
SQL*Plus 11.2.0.3.0
Agent Zip 3.0
Agent Unzip 6.00
------------------------------ ---------------
Using the EMDIAG with EM12c
Numerous diagnostic reports can be run, depending on the arguments that are submitted. The EMDIAG kit is a full
diagnostic suite that will assist the administrator and My Oracle Support in diagnosing issues when they arise in the
EM12c environment.
Job-Level Diagnostics
The following query from Enterprise Manager will gather data that is required to then run the diagnostics for job-level
reports. This example uses a backup job for Apex.
From SQL*Plus as a user with select privileges to the
SYSMAN
schema, perform the following:
select mj.job_id, mj.job_name, mjh.execution_id, mjh.step_id
from sysman.mgmt_job mj, sysman.mgmt_job_history mjh
where mj.job_id = 'BFC78F41009876F3E04014AC08003231'
and mj.job_id=mjh.job_id
and mjh.start_time > sysdate-1;
Figure
11-35
shows the output.
Figure 11-35.
Output from the preceding query
Using the job name, we can perform some diagnostics report gathering on the job itself. Because of the large
amount of diagnostic data that is offered, redirecting the output to a file is recommended.
$ cd $EMDIAG_HOME/bin
./repvfy dump job -name BACKUP_APEX.1 -pwd w0rldw1d3 -tns em12rep > ./rep_apex_job.lst
The output file then shows you a full report on the job, starting with the information about the diagnostic tool, the
database, test, and repository. Figure
11-36
shows this information. Figure
11-37
shows some of the job parameters.
Figure
11-38
shows parameter arguments. Figure
11-39
shows the job source and target.
