Infrastructure at your Service

Cesare Cervini

Two techniques for cloning a repository filestore, part I

By | Entreprise content management | No Comments

I must confess that my initial thought for the title was “An optimal repository filestore copy”. Optimal, really ? Relatively to what ? Which variable(s) define(s) the optimality ? Speed/time to clone ? Too dependent on the installed hardware and software, and the available resources and execution constraints. Simplicity to do it ? Too simple a method can result in a very long execution time while complexity can give a faster solution but be fragile,…

Read More
David Barbarin

Deploying SQL Server 2019 AGs on K8s with helm charts

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

This write-up follows my first article about helm chart with SQL Server. This time, I would like to cover the availability groups topic and how to deploy them with helm charts. In fact, to go through this feature for AGs was motivated to its usage in our Azure DevOps CI pipeline in order to deploy a configurable one on an AKS cluster with SQL Server 2019. If you look carefully at the release pipeline, Windocks…

Read More
Christophe Cosme

Copy or Migrate a SSISDB environment

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

Integration catalog is easy to work with and the environments feature is as well very convenient. In SQL Server management Studio, there are a lot of features available to administrate your SQL Server instances, but some are missing that can be very useful. You have the possibility to move an SSISDB environment but this is only possible in another folder of your SSIS catalog. But how if you will to duplicate your environment or move…

Read More
Stephane Biehler

Documentum 7+ internal error during installation or upgrade DBTestResult7092863812136784595.tmp

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

This blog will go straight to the topic. When upgrading/installing your content server to 7+, you may experience an internal error with a popup telling you to look into a file called something like: DBTestResult7092863812136784595.tmp In fact, the installation process failed to test the database connection. Even if it managed to find your schema previously. In the file you’ll find something like: Last SQL statement executed by DB was: #0 0x00000033b440f33e in waitpid () from…

Read More
Michael Hein

How to build a dummy resource plan

By | Database Administration & Monitoring | No Comments

Often switching off resource plan feature of Oracle database is desired. Unfortunately setting parameter RESOURCE_MANAGER_PLAN to empty string does not help, because it does not disable switching to another resource plan, e.g. with dbms_scheduler. Following procedure prevents this switching. 1. Creation of a dummy resource plan, e.g. TEST_PLAN: BEGIN DBMS_RESOURCE_MANAGER.CLEAR_PENDING_AREA(); DBMS_RESOURCE_MANAGER.CREATE_PENDING_AREA(); DBMS_RESOURCE_MANAGER.CREATE_PLAN( plan =>’TEST_PLAN’, comment => ‘plan for TEST’, mgmt_mth => ‘EMPHASIS’, active_sess_pool_mth => ‘ACTIVE_SESS_POOL_ABSOLUTE’, parallel_degree_limit_mth => ‘PARALLEL_DEGREE_LIMIT_ABSOLUTE’); DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE( plan =>’TEST_PLAN’, group_or_subplan => ‘OTHER_GROUPS’, comment…

Read More
Daniel Westermann

Using Ansible to bring up a three node Patroni cluster in minutes

By | Database Administration & Monitoring | No Comments

Automation is key today, nobody wants to do the same tasks over and over and again. Cloud without automation is not even possible. There are several tools around that help with automation and one of the most popular is Ansible. We already have several posts about Ansible on our blog platform but this one will be rather long. Setting up PostgreSQL high available architectures is our daily business and we as well try to automate…

Read More
Michael Hein

ODA: The Patch version must be 12.2.1.4.0

By | Database Administration & Monitoring | No Comments

When trying to patch your virtualized ODA with patch 12.1.2.12.0 and immediately after that with 12.2.1.4.0, you might consider to load the patches like this: [root@XX1 Oracle_Soft_Repo]# oakcli unpack -package /cloudfs/Oracle_Soft_Repo/p26433712_1212120_Linux-x86-64_1of2.zip Unpacking will take some time, Please wait… Successfully unpacked the files to repository. [root@XX1 Oracle_Soft_Repo]# oakcli unpack -package /cloudfs/Oracle_Soft_Repo/p26433712_1212120_Linux-x86-64_2of2.zip Unpacking will take some time, Please wait… Successfully unpacked the files to repository. [root@XX1 Oracle_Soft_Repo]# oakcli unpack -package /cloudfs/Oracle_Soft_Repo/p28216780_122140_Linux-x86-64_1of3.zip Unpacking will take some time, Please…

Read More
David Barbarin

Azure SQL Managed instances, Business Critical Tier and high availability

By | Cloud, SQL Server | No Comments

Last blog of this year 2018 with SQL databases and Cloud Azure and this is not trivial choice. <Speculation mode> I would say year 2019 could be important for all stakeholders. Cloud transformation has begun in many forms at customer shops and we heard about some big actors who are coming in Switzerland including Azure or Google. Data Platforms services will not be an exception in some degree of magnitude … <end of speculation mode>….

Read More