Application integration & Middleware, Oracle Understand Oracle Text at a glance 13.12.2018 by Oracle Team What is Oracle Text? Oracle Text provides indexing, word and theme searching, and viewing capabilities for text in query applications and document classification applications. Oracle text activation for a user create user ORATXT identified by oratxt ; grant ctxapp(…)
Database Administration & Monitoring Transparent Data Encryption – Certificate in master database: is it really a good practice? 11.12.2018 by Nathan Courtine As encryption solution in SQL Server, Transparent Data Encryption (TDE) is simple and quick to set up. That's why this is a common encryption mechanism. TDE encrypts data with a certificate at the page level, before SQL Server writes on(…)
Database Administration & Monitoring Foglight 10.12.2018 by Oracle Team As many Oracle Database Administrators, I am a regular user of Oracle Enterprise Manager in order to monitor or administer my client’s databases. I am lucky because most of them have the diagnostic pack and the tuning pack :=). But(…)
DevOps, Docker First immersion in the Docker Conference EU 2018 08.12.2018 by Microsoft Team In short, a very interesting event for both Devs and Ops. Every day was organized around workshops, hands-on-labs sessions and Hallway tracks. My colleague Mehdi Bada and I tried to attend as much sessions as possible but obviously it was(…)
Database Administration & Monitoring PostgreSQL : Get my database server name 07.12.2018 by Oracle Team By Mouhamadou Diaw I was looking for a build-in function to get the hostname of the server hosting my PostgreSQL cluster. But seems that there is no build-in function. Looking in the extensions, I find the extension hostname which(…)
Database Administration & Monitoring, PostgreSQL PostgreSQL 12 : New option –socketdir for pg_upgrade 07.12.2018 by Oracle Team By Mouhamadou Diaw PostgreSQL 12 is under development but tests can be done. Steps to install this version can be found in this dbi blog . Many thanks to Daniel. While reading the documentation I(…)
DevOps, Docker DockerCon18 Barcelona – Day 3 06.12.2018 by DevOps Wednesday was the last day of the DockerCon18 Europe. Like the previous day, we started the journey by a keynote of 2 hours, more oriented “Docker Community”, the core message of the keynote, the community is one of the pillars of(…)
DevOps, Docker DockerCon18 Barcelona – Day 2 06.12.2018 by DevOps Tuesday was the second day in Barcelona for the DockerCon18. We attend the first general session in the morning. It was a mix of presentations, live demos and the participation of Docker big customer in EMEA such as Société Général in(…)
Database Administration & Monitoring, Database management, Oracle OEM Cloud Control 13c – Agent Gold Image 05.12.2018 by Joël Cattin Introduction I am currently setting up a new “Base Image” virtual machine (Red Hat Enterprise Linux 7.6) which will be used to create 6 brand new Oracle database servers requested by a customer. Besides installing and configuring the OS, I(…)
Database Administration & Monitoring, Oracle odacli create-database fails on ODA X7-2HA with java.lang.OutOfMemoryError 04.12.2018 by Thomas Rein Today I was onsite at my customer and he told me: I can no longer create databases on my ODA X7-2HA, every time I try to use odacli create-database it fails, please help. Ok, let’s check what happens, the customer(…)