As I discussed in some of my recent talks at conferences (at the DOAG for example), MySQL 8 came out with new features which bring lots of improvements in terms of security.
Read More
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…
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….
In the previous blog I changed the Docbase Name to repository1 instead of RepoTemplate using MigrationUtil, in this blog it is Server Config Name’s turn to be changed.
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…
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…
Oracle released a new way to search for database features, and it is …
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…
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…
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!…
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…
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…