Infrastructure at your Service

Category

Database Administration & Monitoring

Lazhar Felahi

Oracle Data Integrator Cloud

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

Data and applications integration is always a technical challenge for most of the companies. All data integration tool ensures that information is timely, accurate, and consistent across complex systems. Oracle Data Integrator (ODI) is different than traditional data integration tools in the sense it integrates data in a different orders. ODI is known as en E-LT because it Extracts data from the source system and Loads and Transforms data into the target system while traditional…

Read More
Franck Pachot

ORA-32635: not a single cell reference predicate

By | Database Administration & Monitoring | No Comments

By Franck Pachot . I spent 30 minutes to try to understand this error with a query that I’ve run in many environments for years. So if you google it you may arrive here and the solution may be checking whether you have NLS_COMP=LINGUISTIC SQL> alter session set nls_comp=linguistic; Session altered. SQL> alter session set nls_language=french; Session modifiee. SQL> select * from ( 2 select 42 snap_id,’TM’ type,’DB time’ name,0 microseconds from dual 3 )…

Read More
Daniel Westermann

PostgreSQL 14: LZ4 compression for TOAST

By | Database Administration & Monitoring | No Comments

In PostgreSQL a row or tuple can not span multiple pages (a page is typically 8kB), but of course you can store larger rows and PostgreSQL brakes and compresses these rows into smaller chunks by using a technique called TOAST. Once your table contains a toast-able data type a so-called toast table is created automatically. Up to PostgreSQL 13 you had no choice how the data is compressed, but a recent commit brings the option…

Read More
Stéphane Haby

Copy or Migrate a SSISDB environment 2.0

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

Based on the blog “Copy or Migrate a SSISDB environment” of my colleague Christophe, I create a new one named 2.0. In the precedent script, you need to give the folder name and environment name and he generates all environment variables for these 2 parameters. In my case, I need to generate all folders and what are in these folders. The 2.0 script will generate the creation of the folder and the environment name if…

Read More
Franck Pachot

Oracle – testing resource manager plans?

By | Database Administration & Monitoring, Oracle | No Comments

By Franck Pachot . I never remember that in order to use instance caging you need to set a Resource Manager Plan but don’t need to set CPU_COUNT explicitly (was it the case in previous versions?). Here is how to test it quickly in a lab. SQL> startup force ORACLE instance started. SQL> show spparameter resource_manager_plan SID NAME TYPE VALUE ——– —————————– ———– —————————- * resource_manager_plan string SQL> show spparameter cpu_count SID NAME TYPE VALUE…

Read More
Christophe Cosme

SQL Server – PolyBase Services when listening on all IP is disabled

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

Introduction You will find a lot of blogs explaining how to install the PolyBase feature with a SQL Server database instance. You will also learn how to configure it and how to use it in these blogs. But I could not find any solution for one case I was faced to. When you have several SQL Server instances on a server you will either allocate a fix port per instance or a dedicated IP per…

Read More
Daniel Westermann

Getting started with the Zalando Operator for PostgreSQL

By | Database Administration & Monitoring | No Comments

In the previous posts (Rancher, up and running, on EC2 – 1 – One node, Rancher, up and running, on EC2 – 2 – Three nodes, Rancher, up and running, on EC2 – 3 – Rancher setup, Rancher on SLES 15 as a demo environment, and Deploying a Kubernetes cluster on EC2 with Rancher) it was all about deploying a Kubernetes cluster and getting Rancher up and running. In this post we’ll use one of…

Read More
Jérôme Dubar

ODA: Move a DB to ASM after migrating from 11g to 19c

By | Database Administration & Monitoring, Database management, Hardware & Storage, Operation systems, Oracle | No Comments

Introduction Modern Oracle Database Appliances still support 11gR2, but there are several drawbacks using this old version: if you want/need support for your databases, you should pay for Market Driven Support (11gR2 is even no more under extended support – it ended at the end of 2020) some ODA features will not work with 11gR2 (odacli Data Guard feature for example) the use of ACFS filesystems is mandatory As I already told you, it’s more…

Read More
Daniel Westermann

Rancher on SLES 15 as a demo environment

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

If you followed the last posts (Rancher, up and running, on EC2 – 1 – One node, Rancher, up and running, on EC2 – 2 – Three nodes and Rancher, up and running, on EC2 – 3 – Rancher setup) about Rancher, you know how to setup Rancher in a highly available RKE cluster. While this is the way to go for a production clusters, you might want to play with Rancher on a local…

Read More
Jérôme Dubar

Oracle Database Appliance: ODA patch 19.10 is out

By | Database Administration & Monitoring, Database management, Hardware & Storage, Operation systems, Oracle | No Comments

Introduction 4 months after the 19.9, here comes the 19.10 version of the Oracle Database Appliance patch. Let’s have a look at what’s new. Will my ODA supports this 19.10 patch? The 19.10 release will be the same for all ODAs, as usual. The oldest ODA compatible with this release is the X5-2. Don’t expect to install this version on older models. X4-2 is stuck to 18.8, X3-2 is stuck to 18.5 and V1 is…

Read More