Database Administration & Monitoring, Database management, Oracle A day of conferences with the Swiss Oracle User Group 17.11.2019 by Jérôme Dubar Introduction I’m not that excited with all these events arround Oracle technologies (and beyond) but it’s always a good place to learn new things, and maybe the most important, discover new ways of thinking. And regarding this point, I was(…)
Database Administration & Monitoring, Database management, Operating systems, Oracle odacli create-database error DCS-10802: Insufficient disk space on file system: database 11.11.2019 by Jérôme Dubar 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},(…)
Database Administration & Monitoring, Hardware & Storage, Oracle ODA X8-2: the new generation 17.09.2019 by Jérôme Dubar 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(…)
Database Administration & Monitoring, Operating systems, Oracle Useful Linux commands for an Oracle DBA 21.08.2019 by Jérôme Dubar 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(…)
Database Administration & Monitoring, Hardware & Storage, Operating systems, Oracle Patching or reimaging your ODA? 12.08.2019 by Jérôme Dubar 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,(…)
Database Administration & Monitoring, Database management, Oracle Why ODA reimaging doesn’t work on the first try? 07.06.2019 by Jérôme Dubar 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(…)
Database Administration & Monitoring, Database management, Hardware & Storage, Oracle How to patch your ODA lite to 18.3.0.0.0 08.03.2019 by Jérôme Dubar 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(…)
Database Administration & Monitoring OBUG 2019 – First event from Oracle Users Group in Belgium! 09.02.2019 by Jérôme Dubar 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(…)
Database Administration & Monitoring, Oracle ODA : Free up space on local filesystems 21.12.2018 by Jérôme Dubar 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(…)
Database Administration & Monitoring 5 mistakes you should avoid with Oracle Database Appliance 02.11.2018 by Jérôme Dubar 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(…)