content top

EM13c: Is It Possible to Delete a Job Run with EMCLI?

Enterprise Manager Cloud Control provides a centralized job scheduling system and it’s possible to control it through both web interface and EMCLI. On the other hand, it seems web interface provides more control over the past jobs, for example it’s not possible to delete a job run with EMCLI, while it’s possible to do it on web interface:


EMCLI verb “get_jobs” reports all runs of the jobs, and “delete job” can delete job and its all runs but it’s not possible to delete a specific run of a job. For example, if you want to delete hundreds of “failed” (or “skipped”) runs of a job, EMCLI won’t help you and doing it through the web interface will be very time consuming.

Read More

OTN Appreciation Day: Oracle Wait Interface

Thanks to Tim Hall, lots of people from Oracle community, shared their favourite Oracle feature as blog posts. I’ve decided to dedicate my OTN Appreciation Day blog post to Oracle Wait Interface. I know that the topic was not limited to Oracle database, and I could share something about Oracle Enterprise Manager (my main focus area), but Oracle database is the entry point for me and it’s the reason why I started to use other Oracle products (including Oracle Enterprise Manager).

Most of the time, people ask me why I prefer to work with Oracle database. It has great features like having reliable infrastructure, flashback, partitioning, in-memory column store etc. It comes with a great backup and recovery tool (RMAN) and it supports PL/SQL (great way to deal with data). All of these features (and the ones I didn’t count here) helps Oracle database to be the best relational database management system, but when I think about Oracle, the performance monitoring features are my favourite, and Oracle Wait Interface is the foundation stone of those features.

Each time a process waits for something, Oracle collects statistics about the wait. Oracle Wait Interface provides statistics for these waits, and these statistics can be accessed trough a collection of dynamic performance views or an extended SQL trace file. This information is invaluable to monitor sessions and guides you to find the root cause of many performance problems.

For more information about Oracle Wait Interface, you may read: “Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning” book.

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.

EM13c: Unique Database Service Names on DBaaS

When creating Database through Oracle Enterprise Manager Self Service Portal, we need to enter a “unique” value as database service name. After I set up DBaaS on EM13c, I made several tests until I fix the provision problems (based on my own faults). On each test, I cleaned up failed request, entered a unique service name and submitted a new request. I thought there’s no validation about the service name but then I got an error message complaning “non-unique service name”.


As we can see, I tried to enter “murtaza” and it says “murtaza” is not available. I knew that I have already cleaned up failed requests, and there is no service named “murtaza”. Anyway I wanted to be sure and decided to check the existing database services. I noticed that there’s no page showing the existing service names! So I had to enter each database service and check the service name. I had only 3 database services, so it didn’t take so much time.

connection string

The connection string (which we’ll share with the request owner), contains the service name. I couldn’t find any service named “murtaza”. It must be used for a failed request. As I said, I have already cleared and deleted all failed requests, but somehow the service name was stored in the repository. Good thing is, EMCLI verb “dbaas_artifacts” can show and remove these service names which belongs to failed requests:

Read More

Speaking at OOW 2016: Write powerful scripts with EMCLI

This will be my first time to attend Oracle Open World, and I’ll speak about Enterprise Manager Command-Line Interface (EMCLI) Scripting” on User Group Sunday. I already presented it on several conferences, heard people’s feedback and modified the content to improve my presentation. Now I will focus more on practical information, share sample scripts that can be used in real world scenarios. Hope to see you there!

Session ID: UGF3543
Session Title: Oracle Enterprise Manager Cloud Control: Write Powerful Scripts with EMCLI
Room: Moscone West – 3022
Date and Time: 09/18/16, 11:45:00 AM – 12:30:00 PM

Write powerful scripts with EMCLI

Don’t forget to add my session to your schedule to reserve your seat! 🙂

Page 4 of 42« First...23456...Last »
content top