Infrastructure at your Service

Category

Database management

Mouhamadou Diaw

Duplicate Database on ODA X4

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

The ODA X4 is still in use for some customers. The last time I was asked to validate the backups . Let me explain the context. Actually the backups are done via RMAN on local in a NFS share. After these backups are backep up by Netback on tape. The goal was just to validate that the backups done by Netback can be used to restore if needed. So the backup teams restored the backups…

Read More
Mouhamadou Diaw

Oracle 20c Data Guard : Standardization of Client-Side Broker Files

By | Database Administration & Monitoring, Database management, Oracle | One Comment

In an Oracle 20c Data Guard environment with a broker configured we can have following files called client-side broker files -The observer configuration file : observer.ora -The observer log file -The observer runtime datafile: fsfo.dat -The fast-start failover callout scripts (new feature in Oracle 20c) Before Oracle 20c, there was no default location for these files. Starting with Oracle 20c, now we can define a default location for all these files by setting an environment…

Read More
Furkan Suv

Starting with PostgreSQL

By | Database management, Postgres | No Comments

In this Post you will learn how I met PostgreSQL and started to learn. If you are planning PostgreSQL as your database but don’t know where to start, this blog may help you. My background I have used MySQL database like an external hard drive, just to save and store the data from an application. Several times I installed on CentOS/Ubuntu from the repository. Mostly I used preinstalled MySQL databases from webhosting providers. On the…

Read More
Saïd Mendi

Installing MariaDB Columnstore 1.5 on CentOS 8

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

In my previous blog, I talked about how to install the latest MariaDB Community Server 10.5.5 on CentOS 8 but now I will talk about the latest version of MariaDB ColumnStore 1.5 which is not anymore a separate fork of MariaDB but rather a pluggable storage engine.  This allows to move easily data from InnoDB to ColumnStore and it is also the first version to be released as a plugin for the community Server.

Read More
Mouhamadou Diaw

Reimaging an ODA to 19.8 Part II

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

In my previous blog, I described the steps to deploy an ODA 19.8 by reimaging. The ODA was reimaged with the latest available version 19.8 but some components were not up-to-dated. [[email protected] ~]# odacli describe-component System Version ————— 19.8.0.0.0 Component Installed Version Available Version —————————————- ——————– ——————– OAK 19.8.0.0.0 up-to-date GI 19.8.0.0.200714 up-to-date DCSAGENT 19.8.0.0.0 up-to-date ILOM 4.0.4.38.a.r132148 4.0.4.51.r134837 BIOS 52020500 52021300 OS 7.8 up-to-date FIRMWARECONTROLLER VDV1RL02 VDV1RL04 FIRMWAREDISK 1120 1102 HMP The patch was…

Read More
Jérôme Dubar

Boost your CPU speed with Standard Edition 2 on ODA

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

Introduction There is no need to decrease the number of cores on your ODA when using Standard Edition 2, because your license is based on the number of physical CPU. So why would you do that? Obviously, the more cores you have, the more performance you should get. But that simply isn’t always true. Base CPU speed and Turbo Boost If you didn’t read my previous blog, please do so to understand how Xeon processors…

Read More
Jérôme Dubar

ODA: odacli now supports Data Guard in 19.8

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

Introduction I’ve been dreaming of this kind of feature: just because most of the ODA configurations now include Disaster Recovery capabilities, through Data Guard or Dbvisit standy. If Dbvisit will obviously never be integrated to odacli, the lack of Data Guard features is now solved by the very latest 19.8 ODA software appliance kit. How Data Guard was implemented before 19.8? Those who have been using ODA and Data Guard for a while know that…

Read More
Ali Asghari

Create and configure an Oracle linked server in SQL Server Instance

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

What is Linked server ? Now a days in each company we have different applications and each one of them have different needs in term of databases support. When data exists on multiple databases the management become a little bit hard. For exemple moving some data from an Oracle database to a SQL Server database is not easy. A linked servers is configured to enable the Database Engine to execute a Transact-SQL statement that includes…

Read More
Franck Pachot

DBPod – le podcast Bases de Données

By | AWS, Cloud, Database Administration & Monitoring, Database management, Development & Performance, DevOps, NoSQL, Oracle, Postgres, SQL Server | No Comments

By Franck Pachot . J’essaie quelque chose de nouveau. Je publie beaucoup en anglais (blog, articles, présentations) mais cette fois quelque chose de 100% francophone. En sortant du confinement, on reprend les transports (train, voiture,…) et c’est l’occasion de se détendre en musique mais aussi de s’informer avec des podcasts. J’ai l’impression que c’est un format qui a de l’avenir: moins contraignant que regarder une video ou ou lire un article ou une newsletter. Alors…

Read More