Infrastructure at your Service

Morgan Patou

Documentum – Checking warnings&errors from an xPlore full re-index

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

 When working with xPlore as a Full Text Server (indexing), there are a few ways to perform a full re-index. You can potentially do it from the IndexAgent UI, from the Dsearch UI, from the file system (with an ids.txt file for example, it is usually for a “small” number of r_object_id so that’s probably not an ideal way) or from the docbase (mass-queue, it’s not really a good way to do it either). Performing…

Read More
Mouhamadou Diaw

Oracle 18c : Active Data Guard and AWR Reports

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

 Since Oracle Database 12c Release 2 (12.2), Automatic Workload Repository (AWR) data can be captured for Active Data Guard (ADG) standby databases. This feature enables analyzing any performance-related issues for ADG standby databases AWR snapshots for ADG standby databases are called remote snapshots. A database node, called destination, is responsible for storing snapshots that are collected from remote ADG standby database nodes, called sources. The AWR data captures for Active Data Guard require certain steps…

Read More
Petre Radut

SQL Plan stability in 11G using stored outlines

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

 Plan stability preserves execution plans in stored outlines. An outline is implemented as a set of optimizer hints that are associated with the SQL statement. If the use of the outline is enabled for the statement, then Oracle Database automatically considers the stored hints and tries to generate an execution plan in accordance with those hints (Oracle documentation). Oracle Database can create a public or private stored outline for one or all SQL statements. The…

Read More
Pascal Brand

Upgrade Oracle Internet Directory from 11G (11.1.1.9) to 12C (12.2.1.3)

By | Application integration & Middleware | No Comments
 

 There is no in-place upgrade for the OID 11.1.1.9 to OID 12C 12.2.1.3. The steps to follow are the following: Install the required JDK version Install the Fusion Middleware Infrastructure 12c (12.2.1.3) Install the OID 12C (12.2.1.3) in the Fusion Middleware Infrastructure Home Upgrade the exiting OID database schemas Reconfigure the OID WebLogic Domain Upgrade the OID WebLogic Domain 1. Install JDK 1.8.131+ I have used the JDK 1.8_161 cd /u00/app/oracle/product/Java tar xvf ~/software/jdk1.8.0_161 set…

Read More
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