Infrastructure at your Service

All posts by Olivier Toussaint

Olivier Toussaint
Consultant

Olivier Toussaint has more than fifteen years of experience in Oracle and Microsoft SQL Server technologies. He is specialized in Oracle databases (installation, migration, best practices, performance analyses, audit, etc.) and has some Microsoft SQL Server expertise. Olivier Toussaint is Oracle Certified Associate 11g (OCA 11g). He is also ITIL Foundation V3 certified. Prior to joining dbi services, Olivier Toussaint was Oracle trainer (OURC), Consultant, and Team Leader at Easyteam in Lyon (F). His branch-related experience covers Insurances, Health, Media, Financial Services / Banking, E-Commerce, Luxury Goods, etc.
Olivier Toussaint

DBSAT un outil pour la sécurité de vos bases de données Oracle

By | Cloud, Database Administration & Monitoring, Database management | One Comment

Qu’est-ce que DBSAT ? C’est un outil gratuit d’Oracle que vous pouvez télécharger sur My Oracle Support avec comme référence : Doc Id 2138254.1. Il a pour but d’évaluer la sécurité de vos bases de données Oracle en analysant la configuration et les stratégies de sécurité mise en place afin de découvrir les risques liés à la sécurité. Comment cela fonctionne t-il ? Dans un premier temps il sera nécessaire de collecter les informations de…

 
Read More
Olivier Toussaint

How to manage your containers in Oracle Storage Cloud Service ?

By | Database Administration & Monitoring | 5 Comments

Oracle Cloud Storage Service provides secure, scalable and consistent data from any environment. To get a higher flexibility for your backups, I suggest to use a CloudBerry application in Oracle Public Cloud. This application can be used on Cloud Backup and Recovery in PaaS and IaaS infrastructures. We are going to use it for our DbaaS in PaaS infrastructure. However, a user-friendly third party tool can also be used as CloudBerry Explorer for OpenStack as…

 
Read More
Olivier Toussaint

New features into the Cloud

By | Database Administration & Monitoring | No Comments

The last Week end Oracle has proceeded to a new upgrade into the Oracle Cloud. For the Data Region EMEA Oracle Database Public Cloud Services had maintenance on : Oracle Java Cloud Service Oracle Database Cloud Service Unfortunately it is impossible to know what specific changes  have been made in the Cloud and currently there is no exhaustive list available from Oracle Cloud Team. Here we will  see the principal changes on the Oracle Database…

 
Read More
Olivier Toussaint

How to migrate your tablespace from 11g to a PDB in the Cloud

By | Database Administration & Monitoring | No Comments

Goal We will take a tablespace named FOR TRAVEL for migrate it into a PDB situated in your Europe Cloud in extreme performance database. This migration will be executed with Data Pump and transportable tablespace method. We will migrate the tablespace “FOR_TRAVEL” with a table  from Windows Oracle 11g database to Linux  Oracle 12c PDB Database. On-Premise Database You must have : A directory and permissions : Operactions Let’s take our BACKUP_DIR directory for the…

 
Read More
Olivier Toussaint

How to use sqldeveloper’cart for loading data into DBaaS

By | Database Administration & Monitoring | No Comments

Here we will show you how to unload data from a database on premise Oracle Database 12c PDB and how to load it into the table on the DBaaS Oracle Database 12c PDB. We will use a SQL Developer to unload data from tables of the CDB_MY_PDP_PREMISE PDB of the on-premises PDB MY_PDB, and to load data into table of the existing PDB1 PDB of the DBaaS ORCL CDB. How to Export Cart using insert…

 
Read More
Olivier Toussaint

How to connect DbaaS in your Cloud Control 12c

By | Database Administration & Monitoring | No Comments

Oracle provides a monitoring console in the cloud but this console gives not all the information that we need. For example, it is not possible to send an email when a problem appear. However it is possible to use a Cloud Control on premise for monitoring this database. For that, it is necessary to have an EM12c release 5 and at least one agent installed. How to configure a local agent The first step is…

 
Read More
Olivier Toussaint

AWR Formatter: plug-in Google Chrome pour rapports AWR

By | Database management | No Comments

Chacun d’entre nous à une façon bien différente d’appréhender le rapport AWR (Oracle Automatic Workload Repository). Nous utilisons nos propres processus de lecture et notre propre appoche. Dans ce blog je vous propose de découvrir AWR Formatter, un outil qui permet de concentrer les informations en quelques clics. Il s’agit d’un plug-in (AWR-Format.crx) pour Google Chrome fort sympatique, qui permet de reprendre un rapport AWR et de le rendre plus lisible à la première lecture….

 
Read More
Olivier Toussaint

Oracle Database 12c : démarrage automatique des Pluggable Databases

By | Database management | No Comments

Dans ce blog post, nous allons nous intéresser à la gestion des PDBs (Pluggable Database) dans Oracle 12c. Plus exactement, nous allons nous pencher sur l’arrêt et le démarrage automatiques des PDBs en utilisant le Server Control (srvctl) du Grid Infrastructure de la 12c. Le contexte Au préalable, il faut avoir installé Grid Infrastructure et créé une CDB (Container Database) avec une PDB. Nous allons utiliser le processus d’Oracle Restart pour gérer l’arrêt et le…

 
Read More