Setup Oracle Database Link to MySQL
Johannes Ahrends 4This Blog describes how to set up a Database link from an Oracle Database to a MySQL Database. As an (…)
read moreWho is SYSTEM?
Johannes AhrendsIn many companies the DBAs – and not only them – are working with the user “SYSTEM“. Is that wrong? (…)
read moreAre Database Templates useful?
Johannes AhrendsIf you create a database using dbca (Database Configuration Assistant) step 3 allows you to select one of two templates (…)
read moreRead-Only Oracle Home
Johannes Ahrends 1Since Oracle 18 (with some restrictions) it’s possible to set the Oracle software installation directory <ORACLE_HOME> into read only. And (…)
read moreStandard Edition High Availability
Johannes Ahrends 4On May 7th Oracle released “Standard Edition High Availability” (SEHA). There has been a high availability gap so far because (…)
read moreOracle 12.2.0.1 Support Extended
Johannes AhrendsApril 15th was patch day again. New security patches, patch sets, release update and whatever they are named became available. (…)
read moreData loss with Database Services
Johannes AhrendsIn one of my projects we had a disaster most recently: An application was connected to two databases simultaneously and (…)
read moreMultitenant for Everybody
Johannes AhrendsAt the Openworld conference 2019 Oracle announced that Oracle 19c will allow up to three pluggable database per database on (…)
read moreCloning with RMAN is easy!
Johannes AhrendsIn this blog I will show you how to use an RMAN backup to create a database clone. In my (…)
read moreRecovery with RMAN is easy!
Johannes AhrendsIn this blog I will show you how easy it is to restore a corrupted tablespace or datafile using RMAN. (…)
read more
