Infrastructure at your Service

Mouhamadou Diaw

Oracle 12.2 : Windows Virtual Account

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

 With Oracle 12.2 we can use a Virtual Account during the Oracle installation on Windows. Virtual Accounts allow you to install an Oracle Database and, create and manage Database services without passwords. A Virtual Account can be used as the Oracle Home User for Oracle Database Single Instance installations and does not require a user name or password during installation and administration. In this blog I want to share an experience I had with the…

Read More
Mehdi Bada

MongoDB OPS Manager

By | Big Data, Database Administration & Monitoring, Database management, NoSQL | No Comments
 

 MongoDB OPS Manager (MMS) is a tool for administering and managing MongoDB deployments, particularly large clusters. MongoDB Inc. qualified it as “the best way to manage your MongoDB data center“. OPS Manager also allows you to deploy a complete MongoDB cluster in multiple nodes and several topologies.  As you know, at dbi services, the MongoDB installation is based on our best practices, especially the MFA (MongoDB Flexible Architecture), more information here. Is OPS Manager compatible with…

Read More
Stephane Biehler

Java9 new features

By | Application integration & Middleware | No Comments
 

  Java9 is on its way now, in this blog I’ll talk about the new features I found interesting, the performances and so on. Configure Eclipse for Java9 Prior to Eclipse Oxygen 4.7.1a, you’ll have to configure eclipse a little bit to make it run your Java9 projects. Add in eclipse.ini after –launcher.appendVmargs -vm C:\Program Files\Java\jdk-9.0.4\bin\javaw.exe   Still in eclipse.ini add: –add-modules=ALL-SYSTEM   You should have something like this: –launcher.appendVmargs -vm C:\Program Files\Java\jdk-9.0.4\bin\javaw.exe -vmargs -Dosgi.requiredJavaVersion=1.6…

Read More
Petre Radut

Configure AFD with Grid Infrastructure software (SIHA & CRS) from very beginning.

By | Database Administration & Monitoring | No Comments
 

 Introduction : Oracle ASM Filter Driver (Oracle ASMFD) simplifies the configuration and management of disk devices by eliminating the need to rebind disk devices used with Oracle ASM each time the system is restarted. Oracle ASM Filter Driver (Oracle ASMFD) is a kernel module that resides in the I/O path of the Oracle ASM disks. Oracle ASM uses the filter driver to validate write I/O requests to Oracle ASM disks. In this blog I will…

Read More
Pascal Brand

User Session lost using ADF Application

By | Application integration & Middleware | No Comments
 

 In one of my missions, I was involved in a new Fusion Middleware 12C (12.2.1.2) installation with an ADF application and an Oracle report server instance deployments . This infrastructure is protected using an Access Manager Single Sign on Server. In Production, the complete environment is fronted by a WAF server ending the https. On the TEST The complete environment is fronted by a SSL reverse proxy ending the https. In the chosen architecture, all…

Read More
Daniel Westermann

EDB containers for OpenShift 2.3 – PEM integration

By | Database Administration & Monitoring | No Comments
 

 A few days ago EnterpriseDB announced the availability of version 2.3 of the EDB containers for OpenShift. The main new feature in this release is the integration of PEM (Postgres Enterprise Manager), so in this post we’ll look at how we can bring up a PEM server in OpenShift. If you did not follow the lats posts about EDB containers in OpenShift here is the summary: Deploying EDB containers in MiniShift/OpenShift Scaling the EDB containers…

Read More
Mouhamadou Diaw

Masking Data With PostgreSQL

By | Database Administration & Monitoring, Database management, Postgres | 4 Comments
 

 I was searching a tool for anonymizing data in a PostgreSQL database and I have tested the extension pg_anonymizer. PostgreSQL_anonymizer is a set of SQL functions that remove personally identifiable values from a PostgreSQL table and replace them with random-but-plausible values. The goal is to avoid any identification from the data record while remaining suitable for testing, data analysis and data processing. In this blog I am showing how this extension can be used. I…

Read More

Redhat Forum 2018 – everthing is OpenShift

By | Database Administration & Monitoring | No Comments
 

 I had an exiting and informational day at Redhat Forum Zurich. After starting with a short welcome in the really full movie theater in Zurich Sihlcity, we had the great pleasure to listen to Jim Whitehurst. With humor he told about the success of Redhat during the last 25 years. The partner and success stories of Vorwerk / Microsoft / Accenture / Avaloq / Swisscom and SAP showed impressivly the potential and the usage of…

Read More
Nicolas Penot

[Oracle 18c new feature] Quick win to improve queries with Memoptimized Rowstore

By | Database Administration & Monitoring, Development & Performance | No Comments
 

 With its 18th release Oracle comes with many improvements. Some of them are obvious and some of them more discrete. This is the case of the new buffer area (memory area) called the Memoptimize pool. This new area, part of the SGA, is used to store the data and metadata of standard Oracle tables (heap-organized tables) to improve significantly the performance of queries having filter on PKs. This new MEMPTIMIZE POOL memory area is split…

Read More
Mehdi Bada

PII search using HCI

By | Database Administration & Monitoring | No Comments
 

 In a previous blog, we described how to install Hitachi Content Intelligence the solution of Hitachi Ventara for data indexing and search. In this blog post, we will see how we can use Hitachi Content Intelligence to perform the basic search on personal information (PII). Data Connections HCI allows you to connect to multiple data source using default data connectors. The first step is to create a data connection. By default, multiples data connectors are…

Read More
Pierre Sicot

PDB lockdown with Oracle 18.3.0.0

By | Database Administration & Monitoring | No Comments
 

 The PDB lockdown feature offers you the possibility to restrict operations and functionality available from within a PDB, and might be very useful from a security perspective. Some new features have been added to the 18.3.0.0 Oracle version: You have the possibility to create PDB lockdown profiles in the application root like in the CDB root. This facilitates to have a more precise control access to the applications associated with the application container. You can…

Read More