oem - how to use it on 11g?

Common use, reports, tips and tricks on using oem.
jay suarezAsked:
Who is Participating?
slightwv (䄆 Netminder) Commented:
I'm afraid there really isn't a good way to answer a question this broad.

Can you narrow down what you are looking to do?

I would start with the online docs.

Just pick the ones you find important to you.

DBA Essentials
Manage all aspects of your Oracle databases with the Enterprise Manager GUI.
2 Day DBA
2 Day + Security Guide
2 Day + Performance Tuning Guide
2 Day + Real Application Clusters Guide
2 Day + Data Warehousing Guide
2 Day + Data Replication and Integration Guide
jay suarezAuthor Commented:
You are correct, it is to broad.

I do monitoring of Oracle, and company recently installed OEM.    I guess, it spits out a lot of alerts, critical, warnings etc.  I am only concentrating on critical.  If I got the alert, how do i drill down, and find out the exact caused of the alert.

For example, if it is a locking issue?   it only shows critical on the alert, and the host, plus instance.   It also shows messages and type of error.   However, it does not show what tables are in question, and where it locks?

Your assistance we'll be very much appreciated.
slightwv (䄆 Netminder) Commented:
If they installed OEM, surely someone there knows how to use it.  Can you not check with them?

It sounds like they installed the Grid Control that monitors multiple instances through an Agent installed locally on each server.

It has been years since I messed with the GUIs.  One of the links in the alerts should drill down to what actually caused the issue.

Going from memory, one also takes you to basically the definition and thresholds for the alert itself.  Look at the other links around the alert.  Eventually you will get the the cause.

If you can provide a screen shot of where you are starting, maybe we can tell you where to go from there.
jay suarezAuthor Commented:
To answer your question, yes someone installed it.  However, I worked from another company monitoring their system, and this is just for my personal understanding.  I can ask who installed, if the person is still there or not.  If it is there, you will need to fill out lots of forms to get an answer, and even then, it will takes weeks just to  get a response back and forth, and finding out that the person who you talking to is not the correct source.   Then, he/she will need access even to access the DB.  So I hope you understand the dilemma.
slightwv (䄆 Netminder) Commented:
The best way to learn the ins and outs of OEM is by clicking around (NOT IN PRODUCTION!!!).  You can read a LOT of documentation but I feel hands-on is better.

I would suggest you install Oracle XE which comes with dbConsole.  dbConsole has almost everything OEM does and will allow you to click around and experiment without the risk of clicking something 'wrong'.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.