Friday 29 May 2015

Migrate MySQL to Oracle using multiple virtualboxes

After 10 years I have come back to MySQL and there is quite a lot of things which may concern an Oracle DBA.

MySQL and Oracle live under the same company roof
as I have predicted 12 years ago and the results of the meanwhile peaceful  conjugal live have turned out to be impressing for Oracle DBA's as well.

Friday 22 May 2015

Vagrant on Windows

Refers to train.oracle12.migration

The Problem

People focussed on Windows have problems in understanding and setting up vagrant projects on their machines. They simply don't like the commandline and insist on "clicking in GUIs". If one pretends to work seriously, he must not be attached to this attitude. Here are the basic steps.

Monday 18 May 2015

In-Memory Database Columnar Technology in a VirtualBox

Refers to train.oracle12.migration

The Problem
You have imported the user OE into the pluggable database PDB1 inside your guest VM. Now you want to test the In-Memory features of Oracle12c.

Oracle's datapump between host and guestVM

Refers to train.oracle12.migration  
The Problem
You want to load data from your host database into your VM database. Instead of theoretical instruction I will show you an example.

Saturday 9 May 2015

Git & Vagrant for Dummies

Refers to github project train.oracle12.migration

The Shortest Introduction Possible for Oracle IT Crowd

Some friends in the Oracle IT Crowd have problems to understand and setup my project. Here are the basic steps.

Thursday 7 May 2015

Upgrade impossible for Oracle 11.2.0.1 ?

This refers to github project train.oracle12.migration


The Problem

Oracle 11.2.0.1 is said to be impossible to upgrade to Orarcle12c. This is only partially true. There are generally  4 methods to upgrade to Oracle12c

Monday 4 May 2015

Oracle's Enterprise Manager and Vagrant

This refers to github project train.oracle12.migration
 
The Problem

It is said  impossible to use graphical tools like Enterprise Manager in Vagrant. Using Vagrant's Port Forwarding does make it possible.


Oracle's SQLDeveloper and Vagrant

Refers to github project train.oracle12.migration

The Problem
You want to run your SQLDeveloper on the host and you want to let it work on the databases inside the guest VM.  How do we tell SQLDeveloper, that it should connect to the databases inside the guest VM ?