Infrastructure at your Service

Daniel Westermann

When does PostgreSQL create the table and index files on disk?

By | Database Administration & Monitoring | No Comments
 

 A question that pops up from time to time is: When we create a table or an index in PostgreSQL are the files on disk created immediately or is this something that happens when the first row is inserted? The question mostly is coming from Oracle DBAs because in Oracle you can have deferred segment creation. In PostgreSQL there is no parameter for that so lets do a quick test.

Read More
Morgan Patou

Documentum – Silent Install – Docbroker & Licences

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

 In a previous blog, I quickly went through the different things to know about the silent installations as well as how to install the CS binaries. Once the CS binaries are installed, you can install/configure a few more components. On this second blog, I will continue with: Documentum docbroker/connection broker installation Configuration of a Documentum licence   1. Documentum docbroker/connection broker installation As mentioned in the previous blog, the examples provided by Documentum contain almost…

Read More
Franck Pachot

Oracle 18c preinstall RPM on RedHat RHEL

By | Oracle | No Comments
 

 By Franck Pachot . The Linux prerequisites for Oracle Database are all documented but using the pre-install rpm makes all things easier. Before 18c, this was easy on Oracle Enterprise Linux (OEL) but not so easy on RedHat (RHEL) where the .rpm had many dependencies on OEL and UEK. Now that 18c is there to download, there’s also the 18c preinstall rpm and the good news is that it can be run also on RHEL…

Read More
Morgan Patou

Documentum – Silent Install – Things to know, binaries & JMS installation

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

 Documentum introduced some time ago already the silent installations for its software. The way to use this changed a little bit but it seems they finally found their way. This blog will be the first of a series to present how to work with the silent installations on Documentum because it is true that it is not really well documented and most probably not much used at the moment. We are using this where possible…

Read More
Petre Radut

Upgrade Oracle Grid Infrastructure from 12.1.0.2.0 to 12.2.0.1.0

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

 The following blog will provide the necessary steps to upgrade the Grid Infrastructure from 12.1 to 12.2, for a Standalone Server. One of the new features of GI 12.2 is the usage of the AFD (Oracle ASMFD Filter Driver). Assumptions : You have installed Oracle GI 12.1 as grid user You have installed Oracle Database 12.1 as oracle user You have configured the groups asmadmin,asmoper,asmdba You installed oracle-rdbms-server-12cr2-preinstall rpm You patched your Oracle GI to…

Read More
Mehdi Bada

Hitachi Content Intelligence deployment

By | Big Data | No Comments
 

 Hitachi Content Intelligence (HCI) is a search and data processing solution. It allows the extraction, classification, enrichment, and categorization of data, regardless of where the data lives or what format it’s in. Content Intelligence provides tools at large scale across multiple repositories. These tools are useful for identifying, blending, normalizing, querying, and indexing data for search, discovery, and reporting purposes. Architecture HCI has components called data connections that it uses to access the places where…

Read More
Cesare Cervini

A password() function for dmgawk

By | Entreprise content management | No Comments
 

 A few days ago, as I was preparing a dmawk script for a presentation, I stumbled against another unexpected error. The script was attempting to connect to a docbase by providing a docbase name, a user name and a password. But before that, it tested whether a password was provided as a command-line parameter (I know, this is not very secure but it was for demonstration purpose only); if not, it prompted for one using…

Read More
Jérôme Dubar

Patching ODA lite to 12.2.1.4.0

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

 Here is how to apply the latest patch for your ODA. As usual the Oracle documentation is not 100% accurate. I applied this patch on 2 ODAs X7-2M previously deployed in 12.2.1.2.0, no intermediate patch was needed. 1) Download the patch The patch number is 28216794. This patch will update the following components:  dcs (odacli), operating system, bios/firmwares, ilom, GI, dbhomes and databases. Download and copy the patch to a temporary folder on the server,…

Read More
Michael Hein

Logical standby: No view for data guard status on session level

By | Database management, Oracle | No Comments
 

 On logical standby you have to switch off data guard at least on session level to make modifications on objects which are maintained by data guard. This is done by command alter session disable guard; Dataguard can be reenabled for this session by issuing alter session enable guard; For executing these commands “alter database” privilege is at least needed, which is often not liked by IT security staff. Command “alter session disable guard” is also…

Read More
Marc Wagner

ODA, network interface and configure-firstnet

By | Database Administration & Monitoring | No Comments
 

 Deploying new ODA X7-2S or 2M, I have been curious how configure-firstnet would interact with the fiber and copper ethernet network interfaces. Reading documentation on the web, I could not clearly understand if it is mandatory to have the ODA connected to the LAN when performing an ODA reimage and/or running the configure-firstnet in additionnal of having ILOM connection. After digging deeper and few tests, I wanted to share my experience in this blog.

Read More
Michael Hein

How to shrink tables with on commit materialized views

By | Database Administration & Monitoring | No Comments
 

 Usually it is not possible to shrink tables which are used by on commit materialized views. The result is an ORA-10652 “Object has on-commit materialized views” error, for which in action section nothing is suggested. There is a workaround for this error: Convert all materialized views which rely on your table to be shrinked from on-commit to on-demand views. Application must tolerate that the affected materialized views are not updated during shrinking space of the…

Read More
David Barbarin

Running SQL Server containers on K8s Docker for Windows CE stable channel

By | Database Administration & Monitoring, DevOps, SQL Server | No Comments
 

 The release of Docker for Windows Stable version 18.06..0-ce-win70 comes with some great new features I looked for a while including the K8s support! That’s a pretty good news because this support has existed on Edge channel since the beginning of this year but no chance to install a beta version on my laptop from my side. So, we get now a good opportunity to test locally our SQL Server image with a K8s single…

Read More