oem - how to use it on 11g?

Common use, reports, tips and tricks on using oem.
jay suarezAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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'.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.