All articles

Single-Tenant vs. non-CDB: no reason to refuse it

By Franck Pachot . When non-CDB has been declared deprecated, I was a bit upset because multitenant with a lone PDB just looks like an overhead of 3 containers instead of one. But with experience I changed my mind. First(…)

Oracle kernel relink on Linux: Are my options stored persistently?

I recently visited an Oracle presentation about the Oracle-kernel built-in directNFS (dNFS) driver. To use dNFS in the database you have to enable it: cd $ORACLE_HOME/rdbms/lib make -f ins_rdbms.mk dnfs_on REMARK: In versions before 11gR2/12c(…)

Maintenance scenarios with EDB Failover Manager (1) – Standby node

Recently at a customer we again implemented a PostgreSQL architecture as described some time ago. When we delivered the first draft of the documentation the question popped up how to handle maintenance tasks in a failover cluster(…)

Fixed table automatic statistic gathering in 12c

By Franck Pachot . Before 12c, the fixed stats statistics were not gathered automatically. In 12c this has changed: even when you have never gathered fixed objects statistics you can see that you have statistics for X$ tables. That may(…)

Créer une base Oracle sur le Cloud en quelques clicks

By Franck Pachot . Il n'a jamais été aussi facile de créer une base Oracle. Et ceci grâce au Database as a Service (DBaaS). C'est l'occasion de tester le cloud: Oracle Cloud Service offre une version d'essai de un mois.

Lost in the Cloud? My Cloud vs. My Services

By Franck Pachot . The Oracle Cloud has two interfaces that are very similar visually and it's easy to get lost and don't find what we are looking for in the menus.

Alfresco: cleanup your dev environment

As an Alfresco developer/administrator, you probably already made a few mistakes in your DEV environment while trying to add new features, a custom model or something like that. The result of that mistake might be a corrupted Database or Content(…)

Alfresco: upgrade your version of Apache Tomcat

Different versions of Alfresco can be installed with different versions of Tomcat. Alfresco provide a default version with its installer but when installing Alfresco manually, an administrator can choose to install Alfresco using a different version of Apache Tomcat. Usually,(…)

ADTS missing profiles

He he, long time no see, ADTS… It has been a long time I didn’t go into trouble with ADTS. As the new 7.2 ADTS is pretty well constituted this time the issue came from me, I admit. Once upon(…)

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(…)