Infrastructure at your Service

Category Archives: Database management

Joël Cattin

OEM Cloud Control 13c – Agent Gold Image

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

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 also have to install 3 Oracle Homes and one Cloud Control Agent 13c. An OMS13c server already exists including an Agent patched with the EM-AGENT Bundle Patch 13.2.0.0.181031 (28680866) : oracle@oms13c:/home/oracle/ [agent13c] opatch lsinventory |…

Read More
Thomas Rein

DOAG 2018: OVM or KVM on ODA?

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

The DOAG 2018 is over, for me the most important topics were in the field of licensing. The insecurity among the users is great, let’s take virtualization on the ODA, for example: The starting point: The customer uses Oracle Enterprise Edition, has 2 CPU licenses, uses Dataguard as disaster protection on 2 ODA X7-2M systems and wants to virtualize, he also has 2 application servers that are also to be virtualized. Sure, if I use…

Read More
Yann Neuhaus

Flashback to the DOAG conference 2018

By | Application integration & Middleware, Database Administration & Monitoring, Database management | No Comments

Each year, since the company creation in 2010, dbi services attends the DOAG conference in Nürnberg. Since 2013 we even have a booth. The primary goal of participating to the DOAG Conference, is to get an overview about the main trends in the Oracle business. Furthermore, this conference and our booth allow us to welcome our Swiss and German customers and thank them for their trust. They’re always pleased to receive some nice Swiss Chocolate…

Read More
Clemens Bleile

Technical and non-technical sessions at the DOAG 2018

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

The amazing DOAG 2018 conference is over now. As every year we saw great technical as well as great non-technical sessions. What impressed me was the non-technical presentation “Zurück an die Arbeit – Wie aus Business-Theatern wieder echte Unternehmen werden” (back to work – how business theatres become real business company again) provided by Lars Vollmer. It was very funny, but also thought-provoking. Lars started with the provocative sentence that people do work too less….

Read More
Stéphane Haby

SQL Pass Summit 2018: SQL Server 2019 features coming soon!

By | Database Administration & Monitoring, Database management, SQL Server, Technology Survey | No Comments

It’s the 20th anniversary of the event and the keynote today was amazing (see the blog from Christophe) for different reasons but the more important is that is every time better people. Not only DBA’s but also people using their application connected to the database. Today, one of my focus will be the next version of SQL Server 2019 with the session of Bob Ward, Asad Khan & Amit Banerjee from Microsoft. I already tested…

Read More
Christophe Cosme

Pass summit – dbi visit day 3

By | Big Data, Business Intelligence, Cloud, Database Administration & Monitoring, Database management, SQL Server | No Comments

The Microsoft data platform is evolving The third day began with the Keynote help by Rohan Kumar the Corporate Vice President of Azure Data by Microsoft The main message was “Hybrid data platform is the way for the future” and Microsoft is working in this direction. The use of AI and analytic to transform the customer business is also a key driver for the Microsoft data platform, which is building to enable this easily. Rohan…

Read More
David Barbarin

SQL Server 2019 availability groups – Introduction to R/W redirection

By | Database Administration & Monitoring, Database management, SQL Server | 3 Comments

writeThis is a second write-up about SQL Server 2019 CTP2.0 and availability group new features. This time the interesting one is about READRWRITE redirection capabilities. A couple of months ago, I wrote about SQL Server 2017 and new read-scale capabilities and listener management challenges regarding the operating system. Indeed, there are some scenarios where including listener will not as easy as we did with common ones on the top of Windows operation system. A list of…

Read More
Grégory Steulet

Oracle Open World 2018 D1: Top Five MySQL Query Tuning Tips

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

Yesterday (22.10.2018) I participated to the Janis Griffin’s session about “Top Five Query Tuning Tips” at #OOW2018. Janis is Senior DBA /Performance Evangelist for SolarWinds and Ace Director. She is specialized in Performance Tuning. She introduces her session by speaking about Challenges of Tuning. “Tuning takes time.”, “You cannot give enough power if SQL is ineficient”, “You therefore have to monitor wait time”. It sounds basic telling that it doesn’t worth adding CPU or memory when…

Read More
Petre Radut

How to migrate Grid Infrastructure from release 12c to release 18c

By | Application integration & Middleware, Database Administration & Monitoring, Database management, Oracle | No Comments

Oracle Clusterware 18c builds on this innovative technology by further enhancing support for larger multi-cluster environments and improving the overall ease of use. Oracle Clusterware is leveraged in the cloud in order to provide enterprise-class resiliency where required and dynamic as well as online allocation of compute resources where needed, when needed. Oracle Grid Infrastructure provides the necessary components to manage high availability (HA) for any business critical application. HA in consolidated environments is no…

Read More
Joël Cattin

From Oracle to Postgres with the EDB Postgres Migration Portal

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

EnterpriseDB is a valuable actor in PostgreSQL’s world. In addition to provide support, they also deliver very useful tools to manage easily your Postgres environments. Among these we can mention EDB Enterprise Manager, EDB Backup & Recovery Tool, EDB Failover Manager, aso… With this post I will present one of the last in the family, EDB Postgres Migration Portal, a helpful tool to migrate from Oracle to Postgres. To acces to the Portal, use your…

Read More