Infrastructure at your Service

Julia Gugel

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
Cesare Cervini

Using a database trigger to request a rendition

By | Entreprise content management | No Comments
 

 Some time ago, a colleague asked around if someone knew a way to automatically request a rendition right after a document was checked in. This looked like a trigger to me and TBOs are here for that, right ? Sure but there was an additional condition: it should be set up by an administrator from the idql command-line tool as no programming was possible at that time on that system. Given that this tool, along…

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
David Barbarin

Connecting to Azure SQL Managed Instance from on-premise network

By | Cloud, Database Administration & Monitoring | No Comments
 

 A couple of weeks ago, I wrote up about my first immersion into the SQL Server managed instances (SQLMIs), a new deployment model of Azure SQL Database which provides near 100% compatibility with the latest SQL Server on-premises Database Engine. In the previous blog post, to test a connection to this new service, I installed an Azure virtual machine on the same VNET (172.16.0.0/16) including SQL Server management studio. For testing purpose, we don’t need more,…

Read More
Mouhamadou Diaw

Oracle 18c: Cluster With Oracle ASM Filter Driver

By | Database Administration & Monitoring, Database management | One Comment
 

 During the installation of Oracle Grid Infrastructure, you can optionally enable automated installation and configuration of Oracle ASM Filter Driver for your system with the Configure ASM Filter Driver check box on the Create ASM Disk Group wizard page. When you enable the Configure ASM Filter Driver box, an automated process for Oracle ASMFD is launched during Oracle Grid Infrastructure installation. If Oracle ASMLIB exists on your Linux system, then deinstall Oracle ASMLIB before installing…

Read More
Morgan Patou

Documentum – Silent Install – xPlore IndexAgent

By | Application integration & Middleware, Entreprise content management | No Comments
 

 In previous blogs, we installed in silent the Documentum binaries (CS), a docbroker (+licence(s) if needed), several repositories (here and here), D2 and finally the xPlore binaries & Dsearch. This blog will be the last one of this series related to silent installation on Documentum and it will be about how to install an xPlore IndexAgent on the existing docbase/repository created previously. So let’s start, as always, with the preparation of the properties file: [xplore@full_text_server_01…

Read More
Cesare Cervini

A SQLite extension for gawk (part III)

By | Entreprise content management | No Comments
 

 Welcome to part III of a three-part article on extending gawk with a SQLite binding. Part I is here. Part II is here. In this final part, I’ll explain succinctly the code that was listed in part II. This part is best read while having Part II opened in another browser window. sqlite_gawk.c Line 48: All the operations on a database requires a handle that is initialized once the database is successfully opened. The handle…

Read More
Michael Hein

SCAN listener does not know about service

By | Database Administration & Monitoring | One Comment
 

 When trying to connect to a database via SCAN listener in a RAC environment with sqlplus, an ORA-12514 error is thrown. Tnsping can resolve the connect string. Whereas connecting to the same database over node listener with sqlplus succeeds. One possible reason could be, that the parameter remote_listener of the database to be connected is not set to SCAN listener of RAC cluster. So try to set remote_listener to SCAN_LISTENER_HOST:SCAN_LISTENER_PORT like (e.g. host is scan_host,…

Read More
Morgan Patou

Documentum – Silent Install – xPlore binaries & Dsearch

By | Application integration & Middleware, Entreprise content management | No Comments
 

 In previous blogs, we installed in silent the Documentum binaries (CS), a docbroker (+licence(s) if needed), several repositories (here and here) and finally D2. I believe I only have 2 blogs left and they are both related to xPlore. In this one, we will see how to install the xPlore binaries as well as configure a first instance (Dsearch here) on it. Just like other Documentum components, you can find some silent installation files or…

Read More
Morgan Patou

Documentum – Silent Install – Remote Docbases/Repositories (HA)

By | Application integration & Middleware, Entreprise content management | No Comments
 

 In previous blogs, we installed in silent the Documentum binaries, a docbroker (+licence(s) if needed), several repositories and finally D2. In this one, we will see how to install remote docbases/repositories to have a High Availability environment with the docbases/repositories that we already installed in silent. As mentioned in the first blog of this series, there is a utility under “$DM_HOME/install/silent/silenttool” that can be used to generate a skeleton for a CFS/Remote CS but there…

Read More