Oracle Enterprise Manager Cloud Control: Write Powerful Scripts with EMCLI

Last week, I attended the Oracle Open World and did a presentation about writing scripts with EMCLI. If you’re not familiar with EMCLI, it’s the command line interface for Oracle Enterprise Manager Cloud Control. Here’s my presentation:

Although EMCLI is a very specific topic which appeals only to advanced users, a lot of people attended my session. I would like to thank Ray Smith (IOUG Director of Education) for his support. He did his best to inform people about my session.

If you attended my session or just checked the presentation slides, and have any questions about EMCLI scripting, please do not hesitate to ask me.

Please share

AWS Big Data Specialist. Oracle Certified Professional (OCP) for EBS R12, Oracle 10g and 11g. Co-author of "Expert Oracle Enterprise Manager 12c" book published by Apress. Awarded as Oracle ACE (in 2011) and Oracle ACE Director (in 2016) for the continuous contributions to the Oracle users community. Founding member, and vice president of Turkish Oracle User Group (TROUG). Presented at various international conferences including Oracle Open World.


  1. Pingback: Log Buffer #489: A Carnival of the Vanities for DBAs | Official Pythian┬« Blog – Cloud Data Architect

  2. Marco Gilbert


    I attended your presentation @ OOW 2016 and it was one of the best for me.

    But today I am facing a little problem and I thought you might know a way to solve it quickly.

    I have some targets that have to be in blackout for long periods (7 days).  The blackout is defined with job executions disabled for those targets.

    But I also have jobs in OEM that are registered for all my targets, so when those jobs are executed, they are reported with a “Problems” status in the “Job Activity” page of OEM.

    And when I access that specific execution of the job, I can see that the problem is related to the fact that I have a “Skipped” status for the targets that are in blackout, which is normal.

    However, since some of those job are executed hourly, my “Job activity” page reports a lot of job execution in problems because of those “Skipped” status.

    So I would like to use EMCLI to delete the job executions with “Skipped” status.

    I can get those job execution easily with the “emcli get_jobs -status_ids=18” commands, which report the “Job ID” and the “Execution ID”.

    But when I read the documentation of the “emcli delete_job” command, I cannot find anything that would allow me to delete only a specific execution of a job (Execution ID).

    In OEM I can use the “Delete only this run of job” to delete a specific execution of a job, but I cannot find anything in EMCLI that would allow me to do the same.

    Do you if it is possible to use EMCLI to do that ?

    Any idea would be very appreciated.



  3. sandy

    This post is really helpful.
    I am trying to retry the failed job using python. I was trying use get_jobs(status_id=’4′ name=’BCKP%’) but I am unable to get the result.
    I am getting below error
    SyntaxError: (“mismatched input ‘name’ expecting RPAREN”)

    I even tried with other option of emcli.get_jobs(status_id=’4′ name=’BCKP’).

    Can you please advise how to get the specific failed jobs using get_jobs as we have lots of limitations in using the arguments

    • Gokhan Atil

      Hi, I think you missed the comma between the parameters. For example:

      get_jobs( status_id="4", name="BCKP%" )

Leave Comment

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.