Sonntag, 3. Mai 2015

Practicing Oracle12c migration made simple

My professional experience with Oracle is that there is no "5 minute introduction tutorial". That means you need to be serious about getting started with Oracle (or just try out a new feature) because things won't get smooth until you pass the entry barrier of installing and configuring Oracle.
Sadly, this experience results in
  1. Developers that are used to more lightweight persistence layers just...don't get started with Oracle ("Meh, let´s try MongoDb or Elasticsearch instead")
  2. Database Administrators that would benefit from keeping up with the latest features...just skip it because it's too cumbersome to get an isolated playground Oracle DB up and running
What can we do to lower this entry barrier? Vagrant to the rescue! Over the past weeks i contributed to the GitHub repository wkoertgen/train.oracle12.migration whichs aims to alleviate most of the nastyness of setting up Oracle. It is also a great resource on installation and configuration.


  1. If you can go with XE, good. It is a lot smaller and the installer is a 10 minute no-brainer. However, the ODAC/ODP.Net installation kind of clutters your machine which is why i prefer xcopy-deployment with Vagrant et al.

  2. The Oracle IT crowd seems to get closer for this sort of sandboxes; they start to see the benefits.

    I wonder what they will think about the coming project, migrating other database systems like MySQL, Sybase, MS SQL, DB2 to Oracle: We plan to realize this with running multiple virtual machines, either in a private network or a public network.