All articles

Install Oracle 12c Flex Cluster Easily

By Mouhamadou Diaw To install a flex cluster (or a flex ASM)  Grid Naming Service (GNS) is required. A GNS can be configured with dynamic public networks (DHCP) for VIP. This method is suitable for a big number of nodes.In(…)

Windows Failover Cluster : Introduction to paxos tag

A couple of days ago, I was in charge to install a new SQL Server AlwaysOn and availability group with one of my colleague Nathan Courtine. During the installation, we talked about testing a disaster recovery(…)

Learning and troubleshooting: Follow the path

By Franck Pachot . You query a simple table to get its rows. Did you ever ask yourself how oracle knows which blocks to read from disk? Let's question everything and follow the path to dictionary, bootstrapping, spfile,... up to(…)

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