Promoting Unmanaged Targets Automatically

Recently a customer asked if it was possible to promote unmanaged targets automatically without any interaction. They were already using auto-discovery.

The answer is yes, and of course as soon as you see words like “without any interaction” you know there’s going to be scripting involved. In the Enterprise Manager world, scripting is handled by the EM Command Line Interface, better known as EMCLI. I’ve posted some example scripts of using EMCLI a while back (more...)

Auto Search in the Enterprise Manager through bookmarks

Since 12c when debugging or looking at flow instances in the Enterprise Manager, we have to use the search button to make the flow instances appear. By default the following text is being displayed: 'Conduct a search to display the list of message flows across SOA composites in the SOA Infrastructure'.

When you open the search bar on the right pane and click search, the instances of the last 24 hours are being displayed:

However, (more...)

Enterprise Manager at OOW 2015

Well, another Oracle Open World has bit the dust, and as is always the case, there was a lot of great material presented, both by Oracle employees and customers. To help you identify the material and get your hands on the presentations where possible, I’ve taken a stab at grouping all the material together into sections. These are the areas the presenters identified the material as covering, so if the title doesn’t seem to match (more...)

Oracle Open World 2015, Survival of the Fittest!

So I’m about to depart for one day in San Antonio, Tx. to present at the International Performance and Capacity Conference, but I wanted to try to get another blog post out, this time regarding my survival at the 2015 Oracle Open World.

I’m not sure if it just that the schedule was a month later than usual or that it was just more demanding this year, but I left on Friday, feeling utterly exhausted (more...)

Should I monitor the MGMTDB database?

During the installation of Oracle Grid Infrastructure you had the option to install the Grid Infrastructure Management Repository (GIMR) database MGMTDB. With, that option went away, and the MGMTDB database became mandatory. Given that it’s a database, the question of whether it should be monitored by Enterprise Manager was raised by a number of customers, and unfortunately a variety of different answers were forthcoming from different sources (more...)

Must See Session at This Year’s OOW

I’ve seen a lot of interesting posts about what’s going to be presented next week at OOW15, and I’ve blogged about those specific to Enterprise Manager previously – see the links Private Cloud and DBLM, Database Manageability and Middleware Management for more detail. But some people have come to me and said “There are so many sessions to go to for Oracle Open World, can you identify the must see session for what’s happening (more...)

Oracle Open World and Oak Table World Schedule!

So I’ll be heading out for Oracle Open World 2015 in just over another week.  This is the first year in a while that I won’t be speaking, (my own fault, as dummy here hasn’t figured out how to submit sessions internally yet, duh!)   but I’m still going to support the demo grounds, meet with customers and speak at Oak Table World!


Per Steve Karam, if you need to know who’s speaking and (more...)

OOW2015 Middleware Management

This posting covers the Middleware Management sessions at OOW2015. Note that these are middleware management via Enterprise Manager, as opposed to sessions specifically covering middleware features and functions. Also, I have not duplicated here sessions I have already documented under Oracle Management Cloud or Private Cloud / DBLM, so please visit those posts for sessions that fall under both categories. The following sessions fall under this category:

  • The Management of Identity and Access: Breaches, (more...)

OOW2015 Database Manageability

This posting covers the Database Manageability sessions at OOW2015. Note that these are database manageability via Enterprise Manager, as opposed to sessions specifically covering database features and functions. The following sessions fall under this category:

  • Risk-Free Administration for Expert Database Administrators [CON9725] October 26, 4:00 pm – 4:45 pm | Moscone South—104 – The SPA Quick Check, SQL Performance Analyzer, Database Replay, and Concurrent Replay features in Oracle Real Application Testing provide a cost-effective and (more...)

OOW2015 Private Cloud and DBLM

Yesterday I posted an entry on what was coming with OOW2015, specifically discussing the Oracle Management Cloud sessions. This post is similar but looking at one of the more “traditional” EM areas that my team is responsible for – Private Cloud and DBLM. The sessions that are of most interest here are:

  • Hybrid Cloud Management Using Oracle Exalogic [CON9744] October 26, 11:00 am – 11:45 am | Intercontinental—Intercontinental B (5th Floor) – The latest version (more...)

OOW2015 is almost here!

Hard as it is to believe, yet again it is time for the biggest Oracle conference on the planet (or any other planet for that matter!) Yes, OOW2015 is just around the corner! Unfortunately I won’t be there this year, as I have my eldest daughter’s wedding shortly after it, but nevertheless having seen what’s coming up from the Enterprise Manager side of the house, there are a few sessions I can certainly recommend.


BI Publisher Tips and Techniques

A colleague of mine asked recently if we had any <evil term alert>best practices</evil term alert> for BI Publisher, the latest and greatest reporting tool we use within Enterprise Manager (the old tool, Information Publisher, is of course also still supported but this post is relevant to BI Publisher). As you would well know if you’ve been following my posts or heard me presenting at conferences, <evil term alert>best practices</evil term alert> is a term (more...)

Recommendations to Address Cloud Performance Issues via EM12c

So I’m going to start this post with an admission-  I don’t have access to a cloud environment to test this out, but I know what I would do first if I experienced slow response time on database creation or cloning via EM12c to the cloud and I would like to at LEAST post what I would do to give others the chance to test it out and see if it offers them some (more...)

Middleware Diagnostics Advisor (MDA) Setup

One of the areas I’ve been exploring recently is the setup and use of the Middleware Diagnostics Advisor, more commonly known as MDA. MDA is an advisor in EM12c that analyzes the entire stack and provides diagnostic findings by identifying root causes for any problems it discovers. It correlates and analyzes the input and offers advice on how to resolve the problem. For example, it can help you identify that slow SQL statements or a (more...)

Discovery and Monitor Oracle Database Appliance (#ODA) using #EM12C

A few months ago, I heard that Oracle was releasing a plug-in for the Oracle Database Appliance (ODA (Oh Dah). At first I couldn’t find anything on this plug-in, then I was able to find it in the Self-Update for Plug-ins (Extensibility -> Self Update -> Plug-ins).

After finding the plug-in, it needed to be deployed to the Oracle Management Server (OMS). Once deployed, it can be used to monitor the ODA; however, this plug-in (more...)

Creating a Trace File from EM12

Creating a trace file from EM12c is quite easy and doesn’t require a DBA offering up the world to allow a developer or support person to perform this action.

Enterprise Manager also removes some of the syntax options that could get a developer or app support person that is less specialized in creating trace files, all the options and the knowledge of the syntax, etc. from getting into trouble, which creates an option for everyone to be successful.


Use DB Vault to protect password strength policy

Suppose your organization wants to enforce a security policy on database password strength. The DBA’s have implemented a password strength verification function in PLSQL such as the oracle supplied ora12c_strong_verify_function in the DEFAULT profile of the database. There seems no way to get around it at first:

Database account u4 is created:




U4 logs in and tries to keep it simple, i.e. the password:




That password verification function got in (more...)

Annonce : DB12c certifiée avec EM12c

Il est désormais possible d’utiliser une base pour le référentiel d’ Oracle Enterprise Manager (OMR) : 

Complément : A-Team Chronicles

Le site A-Team Chronicles aggrège le contenu produit par les membres de la A-Team : meilleures pratiques, astuces, conseils, etc

Annonce : Oracle Database In-Memory Advisor

Oracle Database In-Memory Advisor est maintenant disponible.
Pour utiliser cet assistant, le "Database Tuning Pack" est nécessaire.

Plus d'information :
  • Page OTN
  • Note MOS 1965342.1