April 29, 2010 at 6:56 am
Hi Friends,
Currently I am working on Oracle OEM grid for SQL Server Monitoring.
As per the client requirement, he want all the alerts & Databases( SQL & ORACLe) need to monitored from one central monitoring tool, i.e. OEM Grid.
I am new to Oracle, so can you share your inputs (like OEM Grid installation prerequisits for SQL server, SQL alert configuration in OEM, SQL Server monitoring setup in OEM)for configuring the OEM Grid for SQL Server monitoring.
Thanks in Advance.
Regards,
Mohan
April 29, 2010 at 10:59 am
I've just recently set up Oracle Enterprise Manager 10.2.0.5 GRID control and the SQL Server plugin needed to monitor the SQL Server instance, here's some of my experience:
If you're using Windows Server 2008, you'll need OEM 10.2.0.5, not 10.2.0.4.
To monitor the database, you'll need a SQL Server login
To monitor the OS, you'll need a local Windows account
The Oracle documentation that comes with the install media is very robust, but can be intimidating. Just follow it line by line. This link isn't bad:
http://download.oracle.com/docs/cd/B16240_01/doc/nav/products.htm
On Oracle metalink, there's multiple doc on installing the SQL Server plugin.
I'm guessing you'll get more replies to this question if you posted in the "Working with Oracle" section. Maybe an admin will move it.
HTH
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
April 30, 2010 at 7:03 am
Thanks for the Reply..
Below i'm listed the down the thing wchich i have done till now & Please currect me if i'm wrong.
1. Downloaded the SQL server Plug-in from http://www.oracle.com/technology/software/products/oem/htdocs/system-monitoring-connectors.html
2. Down loaded the Oracle Management Agent for window from http://www.oracle.com/technology/software/products/oem/htdocs/agentsoft.html
3. Downloaded the sqljdbc.jar
Till this point i'm ok..As i'm new to the Oracle and its terminalogy i dont know how to proceed forward.
I would really appreciate if you could share some document or steps to configure the SQL Server Plug-IN.
My personal mail-id: mohanpariveda@gmail.com
Thanks.
March 16, 2011 at 1:05 pm
Hi All,
I have a similar requirement. Did you end up setting SQL Server monitoring using OEM. I am skeptical to install monitoring agents on SQL Server box.
March 17, 2011 at 9:12 am
We're still using OEM for SQL Server monitoring, using version 10.2.0.5. It works but I find different nuances every week.
Follow my links from above, the Oracle documentation is good.
I'm finding that reporting is difficult though, don't know if that's going to be a major requirement for you.
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply