Infrastructure at your Service


Hardware & Storage

Jérôme Dubar

Make Oracle database simple again!

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

Introduction Let’s have a look at how to make Oracle database as simple as it was before. Oracle database is a great piece of software, yes it’s quite expensive, but it’s still the reference and most of the companies can find a configuration that fits their needs according to a budget. Another complain about Oracle is the complexity: nothing is really simple, and you’ll need skillful DBA(s) to deploy, manage, upgrade, troubleshoot your databases. But…

Read More
Jérôme Dubar

ODA X8-2: the new generation

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

Introduction ODA X7-2 marked the maturity of the Oracle Database Appliance evolution, with 3 models suitable for nearly all customers using Oracle databases. The X7-2M was my favorite, with a lots of cores available (and restrainable), enough memory for dozens of databases, and strong storage performance and capacity (with a maximum of 50TB RAW NVMe). And taking up only 1U of space in your rack. Today, 2 years later, Oracle just introduced the new generation…

Read More
Jérôme Dubar

Patching or reimaging your ODA?

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

Introduction One of the key features of the ODA (Oracle Database Appliance) is the ability to patch the entire stack every three months, the goal being to keep all the components up-to-date. Most of the customers won’t patch so often, but one patch a year is quite a good average. But when comes the time for patching, comes the time for anxiety for the DBA. And it’s totally justified. Why ODA patching can eventually be…

Read More
Oracle Team

When you change the UNDO_RETENTION parameter, the LOB segment’s retention value is not modified

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

Below, I will try to explain, a particular case for the general error : ORA-01555 snapshot too old error.. Normally, when we have this error, we are trying to adapt the retention parameters or to tune our queries. SQL> show parameter undo; NAME TYPE VALUE ———————————— ———– —————————— temp_undo_enabled boolean FALSE undo_management string AUTO undo_retention integer 3600 –extended from 900, undo_tablespace string UNDOTBS1 But, are some scenarios where the above rule is not working . We…

Read More
Jérôme Dubar

How to patch your ODA lite to

By | Database Administration & Monitoring, Database management, Hardware & Storage, Oracle | 6 Comments

Even you don’t need 18c, or you’re not ready for this release, this patch will also update your 11gR2, 12cR1 and 12cR2 databases to the latest PSU available on ODA, it means for example the patchset from last July if you’re using 12cR1. Here is how to apply this latest patch for your ODA lite. In this example, the patch was applied on an X6-2S ODA running on previous release: 1) Download the patch…

Read More
Mouhamadou Diaw

Monitoring Linux With Nmon

By | Hardware & Storage, Operation systems | One Comment

I was looking for tools to monitor linux servers and I found an interesting one nmon ( short for Nigel’s Monitor). I did some tests. In this blog I am describing how to install nmon and how we can use it I am using a Oracle Enterprise Linux System. [[email protected] nmon]# cat /etc/issue Oracle Linux Server release 6.8 Kernel \r on an \m [[email protected] nmon]# For the installation I used the repository epel wget…

Read More
David Hueber

ODA Some curious password management rules

By | Database Administration & Monitoring, Hardware & Storage | One Comment

While deploying an ODA based on the DCS stack (odacli), it is mandatory to provide a “master” password at appliance creation. The web GUI provides for that a small tooltip which describes the rules applied on password management. However it looks like there is some flexibility with those rules. Lets try to check this out with some basics tests.

Read More