All articles

Attunity Replicate: Backup & Restore a task

By a customer, we faced the question: how to backup and restore a replication task in Attunity Replicate? We don’t see any button or menu into the administration web console and in the Guide line, we haven’t really a(…)

Instance Caging and multitenant: do the right setting

When you want to do instance caging, you have to set manually CPU_COUNT and to set a resource manager plan. If you By Franck Pachot . only the CPU_COUNT no instance caging will occur. Except during the maintenance window where(…)

Oracle on Windows Server Core

By Franck Pachot . If SQL Server, the database for GUI fans, goes to Linux then Oracle, the database for command line fans, can go to Windows. Ok, that's not new. But I'm not talking about the Windows with media(…)

EM13c and postgres plugin

As an Oracle DBA I use Enterprise Manager to monitor Oracle databases at my client’s sites. I also administer more and more Postgres databases. I decided to download the Blue Medora plugin in order to monitor the postgresql databases with(…)

Which parameter changes do require a restart of my PostgreSQL instance?

Starting wiht PostgreSQL 9.4 you can change parameters in postgresql.conf with the "alter system" command in psql. In principle every parameter can be changed that way but not every parameter is applied immediately. Some of(…)

SCOM: schedule group maintenance task with PowerShell

In my last blog post, here, I spoke about how to place SCOM group in maintenance mode. This script is really interesting with an integration in Windows Task Scheduler. At the end, the main purpose is to plan a(…)

SCOM: change group state to maintenance mode with PowerShell

Some weeks ago, I wrote a blog post about the creation of SCOM groups in order to subscribe to alerts. Subscribe to alert is mandatory, of course, to be able to receive alerts concerning our group. But during operations(…)

SQL Server 2016 is available on msdn

Breaking news lady and gentlemen. In case you missed it, SQL Server 2016 is live from MSDN subscription. As a reminder, this version offers a lot of very interesting new features and enhancements. Here a(…)

EM 13c corrective actions

With Enterprise Manager 13c, we have the possibility to define corrective actions. Let me show you how to use it. From the Enterprise à Monitoring select Corrective Actions : Choose Add Space to Tablespace in the Create Library Corrective(…)

Where is the ASM SPFILE?

By Franck Pachot . In the previous blog post, to the question "where is the ASM SPFILE" I answered by running 'asmcmd spget'. But this is available only if the ASM instance is started. If you(…)