All articles

Cloning a PDB to the Oracle Cloud Service

By Franck Pachot . When you create a DBaaS on the Oracle Cloud Service you have only one way to access to your database: ssh with the public rsa key you provide. Then you can open some ports to access(…)

SQL Server 2016: CREATE TABLE for Stretch Database is available

This month, the Release Candidate 1 (RC1) for SQL Server is available. With this new version, you can now use the “CREATE TABLE” command for Stretch Databases. If you read the msdn page(…)

Windows Server 2016: Introducing stretch cluster functionality

Let’s continue with the new high available functionality shipped with the next Windows version. In my previous blog, I talked about the new site awareness feature that provides more flexibility to configure failover resources priorities and(…)

How to check Multitenant Option feature usage

By Franck Pachot . Matching the Feature Usage Statistics to licensed options is not always easy. And once a feature usage is recorded, it is usually stored definitively. Let's see how the multitenant option is recorded there.

Install PL/JAVA in PostgreSQL 9.5.1

Some time ago I blogged about how to install PL/JAVA in Postgres Plus Advanced Server 9.5. This resulted in an interesting comment from the maintainer of PL/Java. After(…)

Configurer les “Bonnes Pratiques” de Windows Server avec PowerShell

PowerShell est un outil en ligne de commande dorénavant intégré à tous les environnements Windows. Cet outil est extrêmement puissant, et avec le vent en poupe, puisqu’il permet de simplifier l’exécution et l’automatisation des tâches de configuration et d’administration.

LVM : How to extend a Volume Group

In this article we’ll going to explore on how to extend a partition which resides in a Logical Volume. LVM (Logical Volume Manager) is a great tool for managing your storage devices on a Linux host. Lets(…)

Linux quick tip – What is the local time in Kolkata?

Quite easy if you know how to do it from the shell (I didn’t know it 🙂 ): dwe@dwe:~$ TZ='Asia/Kolkata' date Tue Mar 22 19:12:25 IST 2016 You can use “tzselect” to list the available combinations and get the local(…)

RAC to RON then RON to RAC and singleton service

By Franck Pachot . You will probably never do it, but let's imagine you have a RAC database, policy managed, with singleton service. Then you convert it to RAC One Node and you change your mind and convert it back(…)

SQL Server 2016: new database-scoped configuration parameters part 2

In this blog post, let’s continue with other database-scoped options shipped with the SQL Server 2016 RC0. We will first begin with the first one and my preferred option: setting the MAXDOP value for(…)