Infrastructure at your Service

Franck Pachot

Database is more than persistence. It is shared. My thoughts about Microservice Database.

By | Oracle | No Comments
 

 The development teams often see the database as a ‘persistence layer’ only. And sometimes it is mentioned that the database is always the cause of the problems, especially when implementing continuous integration and trying to be agile. Then cames the idea to have this ‘persistence layer’ in an isolated environment, such as a docker container, with the database for each developer. However, this overlooks the real cause of the problems, which is not the persistence…

Read More
Franck Pachot

Archivelog deletion policy on Data Guard configuration

By | Oracle | No Comments
 

 The deletion policy on a dataguard configuration should be: CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY; for the site where you don’t backup. It can be the standby or the primary. and: CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY BACKED UP 1 TIMES TO DISK; for the site where you do the backups. It can be the primary or the standby. I’ve always configured it in this way, but I recently…

Read More
Franck Pachot

VirtualBox 5.2 exports the VM to the Oracle Cloud

By | Database Administration & Monitoring | No Comments
 

 The new release of Oracle VM VirtualBox (aka VirtualBox) is there with a new functionality to export a VM to the Oracle Cloud Compute (aka Oracle Cloud Infrastructure). That can be interesting to prepare a VM on my laptop and move it to the Cloud to get it accessible from everywhere. Here’s my first try. In my opinion, it’s idea but probably need further evolution.

Read More
Mouhamadou Diaw

PostgreSQL Index Suggestion With Powa

By | Database Administration & Monitoring | No Comments
 

 A few time ago my colleague Daniel did a blog about POWA. In a nice article he shown how this tool can be used to monitor our PostgreSQL. In this present article I am going to show how this powerful tool can help by suggesting indexes which can optimize our queries. I am using postgeSQL 9.6 [root@pgservertools extension]# yum install postgresql96-server.x86_64 [root@pgservertools extension]# yum install postgresql96-contrib.x86_64 And Then I initialize a cluster [root@pgservertools extension]# /usr/pgsql-9.6/bin/postgresql96-setup…

Read More
Mehdi Bada

Managing Oracle Big Data Cloud – CE with REST API

By | Big Data, Cloud, Oracle | 2 Comments
 

 In this blog post, we will see how to manage Oracle Public Cloud Big Data service Compute Edition with REST API. Scheduling the start/stop/restart of a metered PaaS in the Oracle Cloud can be interesting for managing efficiently the consumption of your cloud credits. We should first have a look at the official documentation so as to understand what the API is composed of. https://docs.oracle.com/en/cloud/paas/big-data-compute-cloud/csbdp/QuickStart.html  Use the following URL composition to get access to REST endpoint: https://region-prefix.oraclecloud.com/resource-path According…

Read More
Stephane Biehler

Documentum: IndexAgent uninstalled continues to queue requests

By | Application integration & Middleware | No Comments
 

 We had a strange behavior by a customer regarding the indexing queue. We used to have two IA configured and we uninstalled one. I figured out that we still had indexing queue requests for the old index agent while it was totally uninstalled. I checked the following objects to see if the agent was still configured somewhere: dm_fulltext_index, dm_ftengine_config, dm_ftindex_agent_config. But the old IA was not declared anymore. The main problem is that it continued…

Read More
Eric Simbozel

SQL Server Management Studio 17.3 New Features

By | Database Administration & Monitoring | No Comments
 

 Regularly, Microsoft SQL Server comes up with its new features, and in particular SSMS 2017 17.3 in this post, i present you a new feature : Import flat files Wizard How does it works : Open SSMS, and right click on a selected database Choose Import Flat File   Click Next   Tip the Path of your file to import and the new target table’s name this is a preview of the file content Click Next…

Read More
Franck Pachot

Oracle Database Multilingual Engine (MLE)

By | Oracle | No Comments
 

 My ODC appreciation blog post was about Javascript in the database running in the beta of the Oracle Database Multilingual Engine (MLE). Here I’ll detail my first test which is a comparison, in performance, between a package written in Javascript, running in the MLE, and one written and running in PL/SQL.

Read More
Daniel Westermann

Changing the LOCALE in CentOS/RedHat 7

By | Database Administration & Monitoring | No Comments
 

 What I really don’t like is this: Someone wants me to work on a Linux system for whatever purpose and then I get messages like this: postgres@pgbox:/home/postgres/ [pg960final] cat /proc/sysrq-trigger cat: /proc/sysrq-trigger: Permission non accordée or: postgres@pgbox:/home/postgres/ [pg960final] cat /proc/sysrq-trigger cat: /proc/sysrq-trigger: Permiso denegado It is not that I don’t like French or Spanish but usually (well, not in that simple case) I am not able to translate that without the help from others. So…

Read More