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, 29 May 2015
Migrate MySQL to Oracle using multiple virtualboxes
Labels:
migrate to oracle,
MySQL,
SqlDeveloper,
Virtualbox
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.
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.
Labels:
Github,
PuTTy,
Vagrant,
Virtualbox,
Virtualisation,
Windows
Monday, 18 May 2015
In-Memory Database Columnar Technology in a VirtualBox
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.
Labels:
Github,
In-Memory,
Migration,
Oracle12.,
pluggable database,
Vagrant,
Virtualbox
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.
Labels:
Datapump,
Migration,
Oracle12,
Virtualisation
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.
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
Labels:
Migration,
Oracle12,
Upgrade,
Vagrant,
Virtualbox
Monday, 4 May 2015
Oracle's Enterprise Manager and Vagrant
The Problem
It is said impossible to use graphical tools like Enterprise Manager in Vagrant. Using Vagrant's Port Forwarding does make it possible.
Labels:
Enterprise Manager,
Migration,
Oracle12,
Upgrade,
Virtualbox,
Virtualisation
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 ?
Labels:
Migration,
Oracle12,
SqlDeveloper,
Upgrade,
Vagrant,
Virtualbox,
Virtualisation,
VM