All articles

Extended clusters and asm_preferred_read_failure_groups

By Franck Pachot . When you have 2 sites that are not too far you can build an extended cluster. You have one node on each site. And you can also use ASM normal redundancy to store data on each(…)

PKI – SSL certificates management with Java keytool and OpenSSL

In this blog, we will cover all steps to enable SSL encryption for a particular server. The procedure described here applies mostly for Java based servers and applications, with usage of a keystore. In the case the organization(…)

DB_FLASHBACK_RETENTION_TARGET may hang your database

By Franck Pachot . DB_FLASHBACK_RETENTION_TARGET is set to keep enough flashback logs to be able to flashback database within the specified retention window. But it's supposed to be a target only, meaning that on space pressure some files can be(…)

Alfresco – Protect your installation with Apache httpd

In this blog, I will talk about the setup of an Apache httpd server with/without SSL configuration on top of your Alfresco installation. This way of configuring Apache httpd in front of your Web Application can be reused very easily(…)

Which patchset for 12.1.0.2 ?

By Franck Pachot . When you want to download the latest patchset of the latest release, 12.1.0.2, you can find two patchsets referenced: 17694377 and 21419221. The short answer is: download p21419221 and add latest(…)

SYS password on Oracle Cloud Service managed database

By Franck Pachot . When you create a DBaaS on the Oracle Cloud services you have to provide an administration password in the database configuration form. You do not need a password to connect to the VM. You use SSH(…)

Data Guard as a Service

By Franck Pachot . A 'Data Guard' checkbox is available for a long time on the Oracle Public Cloud Database as a Service, but it's only for a few days that it does something: create a service with an database(…)

SQL Server 2005 decommissioning failed!

The support for SQL Server 2005 is no more available, so we are migrating all the latest databases running under SQL Server 2005 to SQL server 2012 or higher! Last(…)

A near zero downtime, near zero impact major release upgrade using Oracle GoldenGate

In this post I'd like to share what we did for a customer who had the following requirements: Use Oracle GoldenGate Upgrade an Oracle 10.2.0.4 database running on Solaris 10 SPARC to Oracle 12.1.0.2 running on Exadata Keep(…)

SQL Server 2016: new tools management strategy

A lot of customer’s feedbacks are about difficulties to find easily SQL Server tools. Now, it is easier… 😉 A unified web page for SQL Server Tools The first good news is that Microsoft unified and gathered these tools(…)