Advances in Data Clone and Refresh in EM13c

Enterprise Manager 12c introduced a lot of functionality around cloning Oracle databases and refreshing the data once it was cloned. You can see some of the earlier material I have posted on this area in the following posts:

Enterprise Manager STIG Compliance Standards for Oracle Database 11gR2

This is the second of the two posts I wanted to copy from Dave Wolf’s web site. As I mentioned in the first of these two posts, Dave is a colleague of mine who used to own the DBLM area as far as the Enterprise Manager product management team is concerned. However, he has moved to another area in Oracle and I have inherited his responsibilities for change management, compliance management and configuration management, so (more...)

EM12c Compliance ‘Required Data Available’ flag – Understanding and Troubleshooting

This is the first of two posts in the area of compliance management that has been previously published by a colleague of mine, Dave Wolf. Dave has moved to another part of Oracle now, and I’ve inherited some of his reponsibilities as product manager, including change management, compliance management and configuration management, so I wanted to copy his material to my blog so it’s not lost. Thanks Dave, for putting this material together originally!

Overview

(more...)

Auto Search in the Enterprise Manager through bookmarks

Since 12c when debugging or looking at flow instances in the Enterprise Manager, we have to use the search button to make the flow instances appear. By default the following text is being displayed: 'Conduct a search to display the list of message flows across SOA composites in the SOA Infrastructure'.

When you open the search bar on the right pane and click search, the instances of the last 24 hours are being displayed:

However, (more...)

Annonce : DB12c certifiée avec EM12c



Il est désormais possible d’utiliser une base 12.1.0.2.1 pour le référentiel d’ Oracle Enterprise Manager 12.1.0.4 (OMR) : http://ora.cl/tY3 
 


Complément : A-Team Chronicles

Le site A-Team Chronicles aggrège le contenu produit par les membres de la A-Team : meilleures pratiques, astuces, conseils, etc

Annonce : Oracle Database In-Memory Advisor

Oracle Database In-Memory Advisor est maintenant disponible.
Pour utiliser cet assistant, le "Database Tuning Pack" est nécessaire.

Plus d'information :
  • Page OTN
  • Note MOS 1965342.1

Annonce : Devenez expert Cloud Oracle !

Vous souhaitez évoluer dans votre carrière?
Rejoingnez l'un de nos partenaires pour devenir un expert des solutions Cloud Oracle !

Complément : Analyse de performances via AWR Warehouse


Annonce : Workshop DBaaS

Un workshop sur le sujet DBaaS, à destination des partenaires Oracle, aura lieu le 4 et 5 mars à Colombes (France)
Plus de détails : http://eventreg.oracle.com/profile/web/index.cfm?PKWebId=0x1713052088

Annonce : Mise à jour des plugins Enterprise Manager 12c

La dernière version des plugins pour Enterprise Manager 12c vient d'être annoncée.
  • Enterprise Manager for Cloud – version 12.1.0.9.0
  • Enterprise Manager for Oracle Cloud Framework – version 12.1.0.2.0
  • Enterprise Manager for Storage Management – version 12.1.0.5.0
  • Enterprise Manager for Oracle Database – version 12.1.0.7.0
  • Enterprise Manager for Oracle Fusion Middleware – version 12.1.0.7.0
  • Enterprise Manager (more...)

Compliance and File Monitoring in EM12c

I was recently asked to help a customer set up File Monitoring in Enterprise Manager and I thought since I haven’t blogged in a while, this could be a good way to start back up again..
Enterprise manager 12c provides a very nice Compliance and File Monitoring Framwork. There are many Built in Frameworks include for PCI DSS and STIG but this How-to will only focus on a custom file monitoring framework.
Prior to Setting (more...)

Evènement : Atelier Enterprise Manager 12c / DBaaS


Rejoignez-nous le 2 ou 3 Décembre 2014 pour expérimenter pendant une journée les aspects liés à la planification, le déploiement, le suivi et la gestion d’une solution de Cloud Privé d’Entreprise.
Pendant cette journée, vous aurez l’occasion de découvrir les points suivants :
  • Considération architecturale et concepts d’une solution de cloud privé
  • Consolidation base de données & Planification des ressources
  • Approche Base de données en mode service
    (Database as a service)
  • Clone de bases de données
  • (more...)

Complément : Webséminaire DBaaS


Annonce : Web Séminaire DBaaS


Accélérer considérablement vos délais de mise à disposition des services DB avec une infrastructure de Cloud Privé pour vos bases de données
(Database as a service).

Mardi 18 novembre 2014 ; de 11h à 12h

Les solutions Oracle (more...)

ORA-00942 Querying Tablespaces from Enterprise Manager

In order to meet the minimum security requirements, the SYSTEM user use must be restricted, only the actual DBA must have access to it. Other users requiring access to Enterprise Manager to monitor and "view" must be granted especific minimum privileges.
The SELECT_CATALOG_ROLE and the CONNECT roles are good enough to see most of the E.M. contents, but when trying to access the Tablespaces page from Enterprise Manager the ORA-00942 error shows up.
When tracing I discovered the query used to fill up the Tablespaces Page:

SELECT /*+first_rows */ d.tablespace_name, NVL(a.bytes / 1024 / 1024, 0), DECODE(d. (more...)

Tablespace 195% Full … must be the metric system

I was recently refreshing a test database with production data (using datapump if anyone cares) and had forgotten to check the tablespace sizes between prod and test. During the load, I obviously ran out of space. A quick check in prod showed I needed 4GB of space. The test tablespace was set to grow to 2GB max. To add space, I performed a simple command to add the space.

ALTER DATABASE DATAFILE '/u01/oracle/data01/blah.dbf' RESIZE 8GB;


I resumed the datapump and went on my merry way. A few minutes later I received an email from Grid Control that the tablespace (more...)