All articles

Documentum xPlore: Failed to load content file + file system full

We had issues with our indexing server when launching batches of indexes to the queue, in the xPlore server. The indexing was taking so much time to index documents and almost all queue items fell down to the warning/error state.

Creating and Using a Parcel Repository for Cloudera Manager

This blog post describes how to create a hosted Cloudera repository and use it in your Cloudera Manager deployment. The first step is to install a web server, which will host RPM packages and repodata. The common way, is to(…)

Oracle Database Vault: Realm in a Pluggable Database

By Mouhamadou Diaw Database Vault can also be used in a multitenant environment. In a multitenant environment we must register Oracle Database Vault in the root first, then after in the PDBs. In this blog we will see how(…)

Create an HDFS user’s home directory

Let’s assume we need to create an HDFS home directory for a user named “dbitest”. We need first to verify if the user exists on the local filesystem. It’s important to understand that HDFS is mapping users from the local(…)

Deploy a Cloudera cluster with Terraform and Ansible in Azure – part 3

After the deployment step with Terraform and the configuration/installation with Ansible, we will continue the installation of our Cloudera cluster with Cloudera Manager. By following the below steps you will see how to install CDH on our hosts using Cloudera(…)

Data Guard: always set db_create_file_dest on the standby

By Franck Pachot . The file name convert parameters are not dynamic and require a restart of the instance. An enhancement request was filled in 2011. I mentioned recently on Twitter that it can be annoying with Active Data Guard(…)

My tmux scripts to script demos

By Franck Pachot . When I did my first demo using tmux, I have written the following blog post to explain it: https://www.dbi-services.com/blog/using-tmux-for-semi-interactive-demos/. Since then I've done all my demos with this technique. My scripts and(…)

18c: Order by in WITH clause is not preserved

By Franck Pachot . For a previous post I’ve run on 18c a script of mine to get the V$MYSTAT delta values between two queries. This script (new version available on(…)

ODA fiber interface link detection issue

Configuring fiber interfaces during an ODA installation can sometime been challenging. The configuration can depend on the kind of gigabit interface converter (GBIC) and switch been used. In this blog, I would like to show a real case faced during(…)

18c: some optimization about redo size

By Franck Pachot . Some years ago, at the time of 12.1 release, I published in the SOUG newsletter some tests to show the amount of redo generated by different operations on a 10000 rows(…)