RAILS 4 + ORACLE

Quick and dirty setup.

Oracle gems

First you need to install few necessary gems, so put this code in your GEMFILE:

database.yml

Next, you need to edit this file, something like this:

This is a little bit different than configuring your postgres database since you define here a user that will be used as a database name, so you don't need to enter a database name separately, you need to put your SID under 'database' entry.

Oracle user

Since you configured your database.yml file like this, you need to manually create new user in your oracle database and that user will be 'testing'. Go to SQLPlus, log in as an admin and type this:

You created your user and now you need to grant him some privileges:

THE END

Now you do all that 'rake db:migrate' shit but there's no need to do 'rake db:create' too, since this is ORACLE, and ORACLE has to be different and special :)