Infrastructure at your Service

Category Archives: Database management

Pierre Sicot

Oracle Enterprise Manager 12c: Administration Groups & Template Collections

By | Database management | No Comments

This document describes the implementation of the
administration groups and template collections with Oracle Enterprise
Manager Cloud Control 12c.

 

Administration Groups (improvement of Grid 11g Target Groups) and Template Collections improve the management of targets and ease the monitoring strategy.

 

Administration Groups allow to organize targets according to several criteria. For instance the Lifecycle status of the target (prod, dev, integration), the location of the target can be used as criteria. The main goal is to apply common settings (i.e monitoring settings) to targets having the same purpose.

 

The first point about administration groups is to define a clear concept and the hierarchy between these several criteria. The administration groups must be organized in a convenient way according to the company organization. In the next chapter we will present how to handle the hierarchy existing in Cloud Control 12c in order to change it in an administration group organization fitting to the company structure.

The target property is used to implement automatically the target in the appropriate administration group.

 

 
Read More
Pierre Sicot

Oracle Database Firewall

By | Database management | One Comment

Le marché du Database Activity Monitoring (DAM) devenant de plus en plus important avec des produits tels que Imperva, Guardium ou Sentrigo, je me suis intéressé au produit Oracle Database Firewall, qu’Oracle présente comme un substitut aux différents acteurs du marché des DAMs.

 
Read More
Stéphane Haby

Forefront Endpoint Protection (FEP) 2010 and database policies

By | Database management | No Comments

I have seen at a customer that the SQL Server’s policy doesn’t follow the Microsoft’s recommendations about antivirus and databases(kb 309422), such excluding *.mdf,*.ndf and *.ldf files. In addition the policy for Oracle doesn’t exist in case of Forefront Endpoint Protection 2010 known as FEP 2010.

I have decided to create databases policies for FEP optimized by dbi services to be generic and adapted to all SQL Server and Oracle environments.

 
Read More