Infrastructure at your Service
We were recently confronted with one of our playbook constraint while trying to identify which database software could be uninstalled from our servers. Until now, we ran the playbook to de-install a specific version which were “discovered manually”. However, we even got lazy to run this “discovery phase” manually. This short post explains how to design a play around the results of a specific task like generating a list of obsolete Oracle RDBMS software.
A couple of days ago, we upgraded some MariaDB instances on a consolidated database server. However, after the software update we were not able to manage our instances anymore using mysqld_multi whatever the MariaDB release (10.3.18 or the latest 10.4.x). Previously, everything worked fine with 10.3.14. So, what happened to our system?
Amazing conference, amazing people and awesome party like every year and of course great networking like every year This year, I was quite impressed about the number of different technologies. Speeches were not only centered around the big red O. As already summarized, by my colleague Alain yesterday: DOAG 2018 – Not only database – Docker and Kubernetes rule the world Open Source RDBMS, containers and microservices are arising much more quickly than cloud computing…
Recently, I tried to install and connect to Oracle databases directly from my new Mac Book using perl (Yes, perl is still one of the most friendly programming language for DBAs). What first seemed to be easy was in reality quite difficult and long. Alone, the huge quantity of hits on the WorldWideWeb was impressive. However none of the hits were providing the entire solution. Follows, all the steps to prepare and install the Oracle…
Some time ago, my colleague Michael Schwalm wrote about a new Oracle Database 12c feature for moving database files online. In this post, we will not describe the syntax of the command, but focus on Oracle internals. To do that, I have written a tiny test protocol composed of two parts: Session 1: starts a batch (schema BATCH) processing which runs for hours Session 2: that’s us, we are connected as SYS (of course we…
Letztes Jahr hat Oracle CEO Larry Ellison während der Oracle OpenWorld in San Francisco ein neues Datenbank Release angekündigt, das nun endlich zur Verfügung steht. In diesem Blogbeitrag möchte ich einige der wichtigsten Data Pump-Neuigkeiten vorstellen. Eine komplette Übersicht der Features finden Sie in Oracles Dokument „Oracle Database Utilities“. Fangen wir an mit dem riesen Hype von Oracle 12c! Oracle 12c Pluggable Databases (PDB): wie soll ich mit diesem Feature umgehen? In Oracle Database 12c…
Ganz klar: Unser dbi services Goldhase war das inoffizielle Maskottchen der Frankfurter Datenbanktage! Der Nachfrage nach zu urteilen war es sowohl ein Augen- als auch ein Gaumenschmaus … wir haben auch schon eines “geschlachtet” und brüderlich geteilt. Wir waren in 3 Sessions aktiv und hatten die Freude, viele interessierte Teilnehmer an unserem Stand zu begrüssen! Stéphane Haby hat in seiner Session ein neues SQL Server Monitoring-Tool für Microsoft DBAs vorgestellt: “SQL Server Management Datawarehouse”. Die…
Diese Frage habe ich in den letzten Jahren öfters gehört. Zumindest seitdem die DBAs Oracle Datapump verwenden anstatt des alten Export/Import Tools. Angeblich war es früher mit dem Import-Parameter-Tool „INDEXFILE“ viel einfacher. Tja, die Wahrheit ist: Mit Datapump geht es noch leichter! Dies möchte ich anhand eines ganz normalen Datapump-Export–Files verdeutlichen. In folgendem Beispiel handelt es sich um einen einfachen Schema-Export, der wie folgt erzeugt wurde: [email protected]:/u00/app/oracle/admin/DB112/etc/ [DB112] cat expdp_SalesApp.par SCHEMAS=sh DIRECTORY=data_pump_dir DUMPFILE=expdp_SH_2013-02-17.dmp LOGFILE=expdp_SH_2013-02-17.log PARALLEL=4 [email protected]:/u00/app/oracle/admin/DB112/etc/…
Well, this last day really was funny! We met some old friends (they will recognize themselves) and also Oracle guru Jonathan Lewis. We must confess Larry Ellison really has good friends. His America’s cup boat is really amazing (see picture below) as was last night’s party. Today, we were really tired 😉 and the speakers too. Most of today’s content was a review of what Pierre and I reported during the week. It fits exactly…
Today, we had the opportunity to follow several sessions concerning the upcoming Oracle Database 12c release. Like Apple, Oracle keeps the secret over Oracle Database 12c, but tends to deviate from the Silicon Valley secret culture. However, we can relay all that we heard to you 😉 Over the past 10 years, Oracle has worked on plenty of state of the art topics like compression, in-memory operations, scalability, and this is still true for Oracle…
