Installation and Getting Up and Running with Oracle 11g Express (in 30 minutes or less!)

Introduction (aka “Why Yet Another Blog Post On This Topic”)

There are a billion blog entries already on this subject, so this post may seem redundant, but the fact is that I already went through all of those, but was only 70 80 90% successful in installing Oracle 11g Express on Ubuntu 13.10 (64-bit). Just being out of luck with the http interface and SQL Developer never wanted to connect to the database (although SQL*Plus did).

To avoid you being as unlucky as me, I wanted to provide an almost guaranteed successful installation of Oracle 11g Express. Creds goes to a colleague of mine who gave me the tip. I was up and running in 30 minutes (or less) [Depending on your bandwidth, really]!

It took me a great share of a day to (not) succeed, but I hope I can make it easier for you. Since EU just decided (February 16th 2014) that I am in fact allowed to link to other people’s pages without asking permission, I will indeed do just that.

Gentlemen, Start Your Stopwatches Now!

1. Install VirtualBox [http://www.virtualbox.org/]

2. Install Vagrant [http://www.vagrantup.com/downloads.html]

3. Install a pre-setup Vagrant box with Oracle Express 11g. Follow the simple steps:[https://github.com/hilverd/vagrant-ubuntu-oracle-xe]

4. Download Oracle SQL Developer (4.0) for a graphical interface to the database. The URL is approximately this (beware that they change all the time so it is probably dead by now): http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html

5. Install Oracle SQL Developer:

$ unzip the_downloaded_sqldeveloper_zip_file.zip
# sudo apt-get install alien
# sudo alien -d --scripts the_extracted_sqldeveloper_rpm_file.rpm
# sudo dpkg -i the_generated_deb_file.deb

6. Fix the Ubuntu/Gnome/Unity bug by locating the sqldeveloper script:

# sudo vim /usr/local/bin/sqldeveloper

Add this as the first line in that file:

unset -v GNOME_DESKTOP_SESSION_ID

7. Run sqldeveloper! If it cannot find Java, set the path to your java (JDK) installation int the JAVA_HOME environmental variable for the current user (e.g. add to your ~/.bashrc script)

8. You may have to manually start the Oracle instance in the VM. Do this by:

$ cd directory_where_i_cloned_the_oracle_box_repo
$ vagrant ssh
# sudo /etc/init.d/oracle-xe restart

Also make sure there are no other processes using port 1521 or 2222. Either stop/kill those processes, or manually change the ports to be forwarded in Vagrantfile in the root directory of your installation.

What the Hell did I just do?

You just created a virtual machine (VirtualBox), loaded an Ubuntu 12.10 64-bit image (Vagrant), and automatically installed, configured and started all dependencies (Puppet).

Err, But I Want To Do It Myself

Fine, here are a couple of carefully selected how-tos that I followed, but still lacked essential parts for me to succeed. In any case I suggest that you read more about how everything works, bits and bytes, e.g. configuration of tnsnames.ora, listener.ora and other *.ora friends.

...or you can browse through the github repository with Puppet configuration files to see and understand what that is being done.

... And Stop

if [ gt 30 {minutes} ] :
    increase_internet_bandwidth();
fi;
About these ads
This entry was posted in database, devops, linux, oracle, software development, ubuntu, ubuntu 13.10, Uncategorized, vagrant. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s