Infrastructure at your Service

All Posts By

Jérôme Dubar

Jérôme Dubar

odacli create-database error DCS-10802: Insufficient disk space on file system: database

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

Introduction I was reimaging an X6-2M ODA after various patching troubles, and everything was fine. After several databases created, the next ones could no more be created. DCS-10802: Insufficient disk space on file system: database. Expected free space (MB): {1}, available space (MB): {2} I’ve spent some time on it, and finally found the cause of the problem. And the solution. Context After successfully reimaged an X6-2M ODA with 18.5, and applied the patch for…

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

Useful Linux commands for an Oracle DBA

By | Database Administration & Monitoring, Operation systems, Oracle | 3 Comments

Introduction Oracle & Linux is a great duet. Very powerfull, very scriptable. Here are several commands that make my life easier. These tools seems to be widespread on most of the Linux distributions. watch with diff It’s my favorite tool since a long time. watch can repeat a command indefinitely until you stop it with Ctrl+C. And it’s even more useful with the – -diff parameter. All the differences since last run are highlighted. For…

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
Jérôme Dubar

Why ODA reimaging doesn’t work on the first try?

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

Introduction Reimaging an ODA is a good practice for a lot of reasons. To make your ODA cleaner if it’s running for many years and if you patch regularly. To simplify patching because if you’re late you could have to apply multiple intermediate patches to reach the target version. Or simply because you need to change the configuration (for example network configuration) and you want to make things clean, and be sure that future patches…

Read More
Jérôme Dubar

How to patch your ODA lite to 18.3.0.0.0

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: 12.2.1.4.0. 1) Download the patch…

Read More
Jérôme Dubar

OBUG 2019 – First event from Oracle Users Group in Belgium!

By | Database Administration & Monitoring | No Comments

Introduction It’s the first edition of the Techdays, the Oracle community event in Belgium. This event happened in Antwerp these past 2 days, and a lot of speakers came from around the world to talk about their experience on focused subjects. Really amazing to heard such high-level conferences. And it was a great pleasure for me because I’ve been working in Belgium for several years before. I’ll will try to give you a glimpse of…

Read More
Jérôme Dubar

ODA : Free up space on local filesystems

By | Database Administration & Monitoring, Oracle | One Comment

Introduction When you work on ODA you sometimes get struggled with local filesystem free space. ODA has terabytes of space on data disks, but local disks are still limited to a raid-1 array of 2x 480GB disks. And only few GB are dedicated to / and /u01 filesystems. You do not need hundreds of GB on these filesystems, but I think that you prefer to keep at least 20-30% of free space. And if you…

Read More
Jérôme Dubar

5 mistakes you should avoid with Oracle Database Appliance

By | Database Administration & Monitoring | 4 Comments

Introduction It has been 5 years I’m working on ODA and I now have a quite good overview of the pros and the cons of such a solution. On one hand, ODA can greatly streamline your Oracle Database environment if you understand the purpose of this appliance. On the other hand, ODA can be your nightmare if you’re not using it as it supposed to be used. Let’s discover the common mistakes to avoid from…

Read More
Jérôme Dubar

Reimaging an old X3-2/X4-2 ODA

By | Database Administration & Monitoring, Oracle | One Comment

Introduction X3-2 and X4-2 ODAs are still very capable pieces of hardware in 2018. With 256GB of RAM and at least 16 cores per node, and with 18TB RAW disk capacity as a standard these appliances are far from obsolete even you probably don’t have any more support on the hardware from Oracle. If you own several ODAs of this kind, hardware support may not really be a problem. If something fails, you can use…

Read More