Re: Oracle database pro active monitoring and alerting.

  • From: Sreejith S Nair <sreejithsna@xxxxxxxxx>
  • To: D'Hooge Freek <Freek.DHooge@xxxxxxxxx>
  • Date: Sun, 3 Jun 2012 18:19:36 +0530

Thank you for the hints

In the database we wish to monitor we have the diagnostics pack license 
purchased. We use OEM db console on these databases and use AWR, ASH features 
and data.  

In short , suppose I have a database  for which I already used to take AWR , 
OEM db console and such things which come with DP license. Now I installed grid 
control ( which is free ) and added this database to Grid control for 
monitoring , do I need to have any other license ?


Regards,
Sreejith
-- Sent from my iPhone

On 03-Jun-2012, at 6:08 PM, D'Hooge Freek <Freek.DHooge@xxxxxxxxx> wrote:

Grid control in itself is free, but to be any real use you need to license at 
least the diagnostic pack for each database you wish to manage / monitor (and 
probably the tuning pack as well).

Check the licensing guide for more information about the management packs and 
which functionality of grid control is covered by which license. 
http://docs.oracle.com/cd/E11882_01/license.112/e10594/options.htm#CIHGFIAF

The cloud management pack is to manage oracle products in (private) cloud 
environments.
It offers things like self service, chargeback and metering.


Kind regards,

Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge@xxxxxxxxx
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer: www.uptime.be/disclaimer

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Sreejith S Nair
Sent: zondag 3 juni 2012 12:54
To: ilmar.kerm@xxxxxxxxx
Cc: Oracle - L
Subject: Re: Oracle database pro active monitoring and alerting.

Hi ilmar,

Thanks for your comments. 
We have RDBMS and RAC licenses. Are you saying that grid / cloud control is 
included RDBMS licenses ? 
In technology price list April 2012, this is an extra cost option 'cloud 
management pack for oracle database ' under Database Enterprise Management. 

Regards,
Sreejith
-- Sent from my iPhone

On 03-Jun-2012, at 10:26 AM, Ilmar Kerm <ilmar.kerm@xxxxxxxxx> wrote:

On Sun, Jun 3, 2012 at 5:47 AM, Sreejith S Nair <sreejithsna@xxxxxxxxx> wrote:
> We have our production databases ( most 11.2.0.2 RAC on Solaris 10) pro 
> -actively monitored by BMC performance manager. We are not really satisfied 
> with this tool.
> We also have set up few cron jobs to monitor few things like ASM disk usage , 
> tablespace usage , mount point usage and all.
> 
> I would like to know which tool most of the people use in industry. We do no 
> have grid control and I suppose this is the widely used tool. Does someone 
> use any performance monitoring tool ?
> Or is it managed by SQL queries run by cron ?
> We have OEM dbconsole configured but we are looking for a tool that can 
> monitor alert log , wait events , regular monitoring stuffs and send an email 
> when something crosses a threshold.
> 
> Any free tool ?
> Any tool that can execute SQL query at a pre defined interval and send a mail 
> when query returns output.

Grid/cloud control does all these things, it is included in the RDBMS
price and it is a very good tool.

-- 
Ilmar Kerm
--
//www.freelists.org/webpage/oracle-l


--
//www.freelists.org/webpage/oracle-l


--
//www.freelists.org/webpage/oracle-l


Other related posts: