Infrastructure at your Service

Category Archives: Database Administration & Monitoring

Franck Pachot

TRANSPORT_CONNECT_TIMEOUT and RETRY_COUNT

By | Database Administration & Monitoring, Oracle | One Comment

By Franck Pachot . When you have a Data Guard configuration, you want the application to connect to the right server, where the primary is, without taking too much time. The default TCP timeout is 1 minute which is too long. When you don’t want to configure a virtual IP address (VIP) you can simply list all the addresses in the client connection string. But then you need to reduce the timeout. A short duration…

 
Read More
Mouhamadou Diaw

Using Oratcptest

By | Database Administration & Monitoring | No Comments

Last day I did some tests with Oratcptest. This a command line tool which can be used to measure network bandwidth and network latency between client and server. In this blog I am going to show how to use this tool in a DataGuard environment. I am using a DataGuard environment with following configuration. Configuration – PROD Protection Mode: MaxAvailability Members: PROD_SITE1 – Primary database PROD_SITE2 – Physical standby database PROD_SITE3 – Physical standby database…

 
Read More
Daniel Westermann

Backing up and restoring EDB containers in MiniShift/OpenShift

By | Database Administration & Monitoring | 2 Comments

The last blogs in the series are already some days old: Setting up MiniShift, Deploying EDB containers in MiniShift/OpenShift, Customizing PostgreSQL parameters in EDB containers in MiniShift/OpenShift, Scaling the EDB containers in MiniShift/OpenShift, EDB Failover Manager in EDB containers in Minishift/OpenShift and EDB Failover Manager in EDB containers in Minishift/OpenShift – Failovers. What is missing is how you can backup and restore instances running in this container deployment and that is the topic of this…

 
Read More
Daniel Westermann

Catching interface state changes with Network Manager

By | Database Administration & Monitoring | No Comments

Sometimes it is required that you can react on state changes of your network interfaces. Maybe you want to get notified by mail or you want to execute a script that does something in case an event is trapped. As usual I will be using CentOS 7 for this little demonstration but as most distributions use systemd and NetworkManager nowadays this should work more or less the same on Debian based distributions.  

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