Database Administration & Monitoring, Database management, Oracle OEM Cloud Control 13c – Agent Gold Image 05.12.2018 by Joël Cattin Introduction I am currently setting up a new “Base Image” virtual machine (Red Hat Enterprise Linux 7.6) which will be used to create 6 brand new Oracle database servers requested by a customer. Besides installing and configuring the OS, I(…)
Database Administration & Monitoring, Oracle odacli create-database fails on ODA X7-2HA with java.lang.OutOfMemoryError 04.12.2018 by Thomas Rein Today I was onsite at my customer and he told me: I can no longer create databases on my ODA X7-2HA, every time I try to use odacli create-database it fails, please help. Ok, let’s check what happens, the customer(…)
DevOps, Docker DockerCon2018 Barcelona – Day 1 03.12.2018 by DevOps As a football fan, traveling to Barcelona without watching a football game is inconceivable, so I started my travel by attending the game against Villareal in Camp Nou 😎 DockerCon Day 1 Today, with David Barbarin, was our first day at(…)
Database Administration & Monitoring Oooooops or how to undelete a file on an ext4 filesystem 03.12.2018 by Oracle Team It happens within the blink of an eye. A delete command was executed and half a second after you hit the enter button you knew it. That was a mistake. This is the scenario which leads to this blog entry(…)
Database Administration & Monitoring OEM 13c Repository view gc$metric_values_daily 03.12.2018 by Oracle Team Oracle OEM 13c offers the possibility to generate reports about Oracle Database Tablespace Monthly Space Usage. The displayed information is quite useful and display a lot of information: The report displays the details for(…)
Technology Survey AWS re:invent 2018 – Day 5 – Final day 01.12.2018 by Nicolas Jardot On Friday, it’s the last day for AWS re:Invent convention in Las Vegas. I didn’t know in advance what to expect because I have to admit that even if I started to use AWS, there is still a lot to learn.
Database Administration & Monitoring PostgreSQL 12: csv output format for psql 01.12.2018 by Daniel Westermann Getting data out of PostgreSQL in csv format is not a big issue. Using copy you can do that easily. PostgreSQL 12 will enhance psql so that you can directly return csv formatted output from a(…)
Database Administration & Monitoring PostgreSQL 12: log_statement_sample_rate 30.11.2018 by Daniel Westermann A common way to identify long running queries in PostgreSQL is to set log_min_duration_statement to a value that is known to cause troubles. In other words: If you know most of your statements usually execute in(…)
Technology Survey AWS re:invent 2018 – Day 4 30.11.2018 by Nicolas Jardot Thursday morning it’s time for the keynote from Dr Werner Vogels. A big part of the keynote was about databases again. Maybe AWS people knows that there are still lots of DBAs out there! It’s also again a focus on(…)
Database Administration & Monitoring Extend a Oracle Access Manager 12.2.1.3 with User Messaging Service 30.11.2018 by Middleware Team After upgrading a Oracle Access Manager from 11.1.2.3 to 12.2.1.3, one of my customer requested from me to configure the Forget Password feature. This feature requires the User Messaging Service that was part of the SOA software in previous versions.