I've been diving into more OEM Automation and collecting information here. While the Oracle example scripts are a great way to find out how to interact with OEM via the emcli and python/jython interface, there doesn't seem to be much info about how this all…
I was recently asked to update the EBS Plugin from 12.1.0.2.0 to 12.1.0.3.0 in my Cloud Control 12 setup. During the prereq steps I got an error: "EM-04050: The selected plug-ins cannot be deployed on the Management Server because there are some Management Agents on…
When working on a SQL Tuning issue I often kick off a SQL Tuning Advisor job on the SQL while I gather info about statistics and other things I like to check when tuning. After I get an idea of where performance might be suffering…
I recently got this error while trying to run a SQL Tuning Task against a SQL statement that was available in AWR but not currently in the library cache. I got around it by locating the SQL in OEM and using SQL Worksheet to execute…
Did you know that OEM has a built in interface for executing simple ad-hoc queries and recording the results? Here is how I set up a recurring query to find the number of user logins every 15 minutes and record the data. 1) Navigate to…
I had some trouble adding a new database to an OEM Grid installation this weekend. I didn't find too many references to the above error so I wanted to post about it here. Of course Metalink was all doom and gloom. Note 745795.1 says to…