Enterprise Manager Support Files 101- The EMOMS files

Someone pinged me earlier today and said, “Do I even really need to know about logs in Enterprise Manager?  I mean, it’s a GUI, (graphical user interface) so the logs should be unnecessary to the administrator.”

luke

You just explained why we receive so many emails from database experts stuck on issues with EM, thinking its “just a GUI”.

Log Files

Yes, there are a lot of logs involved (more...)

EM13c Proxy Setup, MOS and CSI Setup

The change in EM13c, is that it support multiple proxies, but you may still not know how to set up a proxy and then use it with your MOS credentials and then assign out your CSI’s to targets.

scratcheshead

Proxies

To do this, click on Settings, Proxy Settings, My Oracle Support.  Click on Manual Proxy Setting and then type in your proxy host entry, (sans the HTTPS, that’s already provided (more...)

EM13c- BI Publisher Reports

How much do you know about the big push to BI Publisher reports from Information Publisher reporting in Enterprise Manager 13c?  Be honest now, Pete Sharman is watching…. :)

george

I promise, there won’t be a quiz at the end of this post, but its important for everyone to start recognizing the power behind the new reporting strategy.  Pete was the PM over the big push in EM13c and has a (more...)

IOUG Collaborate 2016! #C16LV

It’s that time of year again and the massive undertaking of the Collaborate conference is upon us.  This yearly conference, a collaboration between Quest, Oracle Applications User Group, (OAUG) and Independent Oracle User Group, (IOUG) is one of the largest conferences in the world for those that specialize in all areas of the Oracle database.

The conferene is held in different cities, but recently its been sticking (more...)

How to Find Information in the OMR, (Enterprise Manager Repository)

I get a lot of questions starting with, “Where do I find…” and end with “in the Oracle Management Repository, (OMR)?”

confused_lost

The answer to this is one that most DBAs are going to use, as it’s no different than locating objects in most databases, just a few tricks to remember when working with the OMR.

  1.  SYSMAN is the main schema owner you’ll be querying in an OMR, (more...)

Gold Agent Image

The Gold Agent Image is going to simplify agent management in EM13c, something a lot of folks are going to appreciate.

django

First step to using this new feature is to create a image to be used as your gold agent standard.  This should be the agent that is the newest, most up to date and patched agent that you would like your other agents to match.

Managing Gold (more...)

AWR Warehouse Fails on Upload- No New Snapshots

This issue can be seen in either EM12c or EM13c AWR Warehouse environments.  It occurs when there is a outage on the AWR Warehouse and/or the source database that is to upload to it.

oh_gif_by_gifsandstock-d4ldoq9

The first indication of the problem, is when databases appear to not have uploaded once the environments are back up and running.

awrw5

The best way to see an upload, from beginning to end is (more...)

Retaining Previous Agent Images, the Why and the How

I appreciate killing two birds with one stone.  I’m all about efficiency and if I can do satisfy more than one task with a simple productive process, then I’m going to do it.  Today, I’m about to:

  1. Show you why you should have a backup copy of previous agent software and how to do this.
  2. Create a documented process to restore previous images of an agent to a (more...)

Enterprise Manager 13c And Database Backup Cloud Service

The Oracle Database Cloud Service allows for backup of an Oracle Database to the Oracle Cloud using Rman. Enterprise Manager 13c provides a very easy way to configure Oracle Database Backup Cloud Service. This post will walk you thru setup of the Oracle Database Backup Cloud service as well as running backups from EM.


There is a new menu Item to configure the Database Backup Cloud Service (DBCS) in the Backup & Recovery Drop down.


(more...)

New Series of EM Blog Posts

One thing I like seeing is how people use Enterprise Manager. It’s one of the most enjoyable parts of speaking at conferences (apart from the social networking, of course), because quite often the users of Enterprise Manager find ways of using the product that we in Product Management might never have thought of. Sometimes that can lead to useful product enhancements, and other times it leads to much head shaking in disbelief (but since I (more...)

BI Publisher Integration in EM12c

As some of you would already know, for my sins I am the product manager with responsibility for BI Publisher in Enterprise Manager [I must have a lot of sins because I’m also responsible for Change Management, Compliance Management, Configuration Management (these three form the Database Lifecycle Management pack), jobs, the target discovery framework, and at least part of DBaaS along with data cloning and refresh :) )]. While I was investigating another issue from a (more...)

GoldenGate Plug-in for Enterprise Manager 13.1 is released

Just a quick post to let you know the EM13.1 plug-in for GoldenGate has been released by the GoldenGate development team. I know some of you have been waiting for this, so head on over to the official announcement for all the details!

The post GoldenGate Plug-in for Enterprise Manager 13.1 is released appeared first on PeteWhoDidNotTweet.com.

DBaaS RESTful API Cook Book

Having a GUI tool like Enterprise Manager Cloud Control 12c to manage your entire data center is an imperative for most enterprises these days. But in the cloud paradigm, you must also have a uniform API that can be used use to tailor the cloud to your business processes and economic models. That API is known as the REST API, and services based on that are known as RESTful services.

With the latest release of (more...)

Advances in Data Clone and Refresh in EM13c

Enterprise Manager 12c introduced a lot of functionality around cloning Oracle databases and refreshing the data once it was cloned. You can see some of the earlier material I have posted on this area in the following posts:

Enterprise Manager STIG Compliance Standards for Oracle Database 11gR2

This is the second of the two posts I wanted to copy from Dave Wolf’s web site. As I mentioned in the first of these two posts, Dave is a colleague of mine who used to own the DBLM area as far as the Enterprise Manager product management team is concerned. However, he has moved to another area in Oracle and I have inherited his responsibilities for change management, compliance management and configuration management, so (more...)

EM12c Compliance ‘Required Data Available’ flag – Understanding and Troubleshooting

This is the first of two posts in the area of compliance management that has been previously published by a colleague of mine, Dave Wolf. Dave has moved to another part of Oracle now, and I’ve inherited some of his reponsibilities as product manager, including change management, compliance management and configuration management, so I wanted to copy his material to my blog so it’s not lost. Thanks Dave, for putting this material together originally!

Overview

(more...)

Updated BI Publisher material

Just a quick note to say the material covered on my BI Publisher page has been updated to include some links specific to EM13c. If you can’t be bothered heading over to that page, here are the two new links :) :

The post Updated BI Publisher material appeared first on PeteWhoDidNotTweet.com.

Determining What Management Packs Are Needed

In Enterprise Manager 12c, there was a little known functionality where you could check what management packs you needed to be licensed for to use a particular page in Enterprise Manager. I referred to it many times at conferences I was presenting at, and almost always people did not realize the functionality existed. Let’s see how this works.

To start with, I’m going to go to the Performance Home page for a particular database (accessed (more...)

New Features of Enterprise Manager Cloud Control 13c

For those of you that have been wondering why I’ve been so quiet of recent times, it’s because my wife and I took advantage of a trip to England for UKOUG in December to spend nearly 5 weeks touring around Europe (2 weeks of which was spent river cruising from Amsterdam to Budapest with the fabulous APT river cruises, something I can HIGHLY recommend if you want to see Europe!). But while I (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...)