Oracle Enterprise Manager Cloud Control: Write Powerful Scripts with EMCLI

September 25, 2016Gokhan Atil5 CommentsOracleem13c, emcli, oow

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

Gokhan Atil

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.

5 Comments

Pingback: Log Buffer #489: A Carnival of the Vanities for DBAs | Official Pythian® Blog – Cloud Data Architect
Marco Gilbert

October 14, 2016 Reply

Hi,

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.

Regards,
- Gokhan Atil
  
  October 15, 2016
  
  Hi Marco,
  
  I’m glad to hear that you enjoyed my session. Thanks for joining!
  
  About your question, unfortunately it’s not possible to delete a job run using EMCLI yet. Even newest EM 13c R2 doesn’t support it. It’s possible to delete runs with a simple PL/SQL script.
  
  Please check: http://www.gokhanatil.com/2016/10/em13c-is-it-possible-to-delete-a-job-run-with-emcli.html
sandy

January 25, 2017 Reply

Hi,
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
  
  January 25, 2017
  
  Hi, I think you missed the comma between the parameters. For example:
  
  get_jobs( status_id="4", name="BCKP%" )