Database Administration & Monitoring, Hardware & Storage, Operating systems, Oracle Patching ODA from 18.3 to 18.8 28.04.2020 by Jérôme Dubar Introduction 19c will soon be available for your ODAs. But you may not be ready. Here is how to patch your ODA from 18.3 to 18.8, the very latest 18c release. This patch has here been applied on X7-2M hardware.
Database Administration & Monitoring, Database management, Hardware & Storage, Oracle Speed up datapump export for migrating big databases 21.02.2020 by Jérôme Dubar Introduction Big Oracle databases (several TB) are still tough to migrate to another version on a new server. For most of them, you’ll probably use RMAN restore or Data Guard, but datapump is always a cleaner way to migrate. With(…)
Database Administration & Monitoring, Database management, Hardware & Storage, Operating systems, Oracle odacli create-database extremely slow on ODA X8-2 with 19.5 14.02.2020 by Jérôme Dubar Introduction ODA X8-2, in the S, M or HA flavour, is the new database appliance from Oracle. But as a brand new product, you can experience troubles due to the lack of maturity. This time, it concerns database creation that(…)
Database Administration & Monitoring, Database management, Hardware & Storage, Operating systems, Oracle Should I go for ODA 19.5 or should I wait until 19.6? 07.02.2020 by Jérôme Dubar Introduction As you may know, Oracle Database 19c is available for new (X8-2) or older Oracle Database Appliances since several weeks. Current version is 19.5. But when you go to the official ODA documentation , it(…)
Database Administration & Monitoring, Database management, Development & Performance, Hardware & Storage, Operating systems Make Oracle database simple again! 22.01.2020 by Jérôme Dubar 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(…)
Database Administration & Monitoring, Database management, Oracle Focus on 19c NOW! 29.11.2019 by Jérôme Dubar Introduction For years, Oracle used the same mechanism for database versioning. A major version, represented by the first number. And then a release number, 1 for the very first edition, and a mature and reliable release 2 for production databases.
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(…)