Infrastructure at your Service

 
Daniel Westermann

Working with files on the filesystem in PostgreSQL

By | Database Administration & Monitoring | No Comments

PostgreSQL comes with various helper functions that support you with working with files on the filesystem on the host PostgreSQL is running on. You might ask yourself why that is important but there are use cases for that. Maybe you want to list the contents of a directory because new files that showed up since the last check do trigger something. Maybe you want to load a file into the database (which you also can…

Read More
Petre Radut

Create a primary database using the backup of a standby database on 12cR2

By | Database Administration & Monitoring, Database management, Oracle | No Comments

The scope of this blog will be to show how to create a primary role database based on a backup of a standby database on 12cR2. Step1: We are assuming that an auxiliary instance has been created and started in nomount mode. rman target / restore primary controlfile from ‘backup_location_directory/control_.bkp’; exit; By specifying “restore primary” , will modify the flag into the controlfile, and will mount a primary role instance instead of a standby one….

Read More
Michael Hein

DOAG day “database migration” in Mannheim at 19.02.2019

By | Database Administration & Monitoring | No Comments

Yesterday I attended DOAG conference in Mannheim about migrating Oracle databases. First presentation was about challenges about migrating to multitenant databases. With Oracle 20 it is probably not possible anymore to create a non CDB database or to upgrade from a non CDB database. So in the next years all databases have to be migrated to multitenant architecture. Problems with licensing, different charactersets were covered and some migration methods to PDB were shown. In the…

Read More
Mouhamadou Diaw

PostgreSQL : barman rsync method vs streaming method

By | Database Administration & Monitoring, Postgres | No Comments

Barman is a tool to perform backup and recovery for PostgreSQL databases. It can do backup using two methods: -rsync/ssh -streaming In this blog I am going to explain how to use these two methods to backup a PostgreSQL database. Generally it is a good practice to dedicate a server for barman instead of installing it on the database server. My environment is described below postgreSQL server: dbi-pg-essentials 192.168.22.101 Centos 7 barman server: pgservertools 192.168.22.104…

Read More
Cesare Cervini

A few scripting languages for Documentum

By | Entreprise content management | No Comments

Beside the obsolete dmbasic, the autistic dmawk, the verbose java with the DfCs, the limited iapi (for API) and idql (for DQL) command-line tools, Documentum does not offer any scripting language for the administrator and the out-of-the-box experience is quite frustrating in this respect. It has been so even before the java trend so it is not a maneuver to force the use of the DfCs or to rely on it for administrative tasks. It…

Read More
Mehdi Bada

Docker EE – UCP 3.1.2 installation failed in Azure

By | DevOps, Docker | No Comments

Docker EE 2.1 is a Containers-as-a-Service (CaaS) platform on-premise or in the cloud. To manage your cluster of containers, Docker EE allows you to install UCP (Universal Control Panel). When you plan to install the UCP 3.1.2 in Azure, the installation fails during the deployment of the UCP service. You will get the following error message. [[email protected] ~]$ docker logs ucp-reconcile   If you google the error message you will get a lot of answers…

Read More
Diawo Mayaki

How To Deploy A New Container Group Using Azure PowerShell

By | Cloud | No Comments

Deploying A New Container Group Using Azure PowerShell Before starting, a MSDN account is needed to use the Azure platform, please refer to your manager for further information. In this tutorial, the PowerShell commandlets will be used to deploy a Windows image that packages Internet Information Services (IIS). Launch the command prompt and type az login to authenticate on the Azure platform (see below): Wait until a browser is launched so that you can login (see below): You have logged into Microsoft Azure!…

Read More
Diawo Mayaki

How To Create A New Container Group Using Azure CLI

By | Cloud | No Comments

Steps To Create A New Container Group Using Azure CLI Before starting to create a container group, a MSDN account is needed to use the Azure platform, please refer to your manager for further information. In this tutorial, the Azure CLI command-line tool will be install on Windows and we will deploy a website running the open source GHOST platform. Choose the right operating system to install the command-line tool. The information can be found here. When the installation…

Read More
Jérôme Dubar

OBUG 2019 – First event from Oracle Users Group in Belgium!

By | Database Administration & Monitoring | No Comments

Introduction It’s the first edition of the Techdays, the Oracle community event in Belgium. This event happened in Antwerp these past 2 days, and a lot of speakers came from around the world to talk about their experience on focused subjects. Really amazing to heard such high-level conferences. And it was a great pleasure for me because I’ve been working in Belgium for several years before. I’ll will try to give you a glimpse of…

Read More