Search
Search Menu

Oracle 10g Express Edition on a Mac

This article is from 2007. Since Oralce has taken over Sun, you can now grab a pre-built VM with everything installed and ready to use:
http://www.oracle.com/technetwork/community/developer-vm/index.html

Well, at least on an Intel Mac it is now possible to run and use the Oracle 10g Express Edition, the free version for small projects and software development, which unfortunately does not exist for Mac OS X.

Thanks to virtualization you can install Oracle 10g Express on a Linux or Windows VM and use it from the Mac side (your Java application, Eclipse,…).

Oracle 10g Express Edition on a Mac

I used Ubuntu Ultimate 1.4 on VMware Fusion. Before you can install Oracle 10g express, you have to increase the swap size. In my case the installer reported that the Express Edition requires 750 MB of swap space. I followed these instructions and increased the swap space to 800MB. Since I wanted to use the universal release, I used ‘apt-get install oracle-xe-universal’ to install Oracle (Oracle also offers RPM packages). The rest is straight forward. Just follow the instructions. As you can see in the screenshot, I can contact the 10g database from SQL Developer running on Mac OS X on the same machine. The Ubuntu windows shows the web-interface of Oracle.

I ran the same maven build again (clean install with database scripts and full tests) and now the time went down to 2:50 (from 3:30 with a remote database). The Core 2 Duo of my MacBook Pro had to work hard and memory usage went up to 1.5 GB, but there was enough room to continue working.

So, this is great. Now I have a completely independent mobile software development platform.

8 Comments Write a comment

  1. I have managed to get 10g XE loaded on Ubuntu using parallels. But I cannot connect using SQLDeveloper on native OS X. Any Ideas? What should the connect string be? How do I find out what the connection values should be. Any help would be appreciated.

    The ubuntu port is 1521 the host is set to 127.0.0.1.

  2. 127.0.0.1 is your localhost. You must find out the public IP address of the Ubuntu VM. Parallels offers just like VMware different network modes. On VMware those are NAT, bridged and host only. I use bridged and set the IP manually. In Ubuntu go to System > Administration > Network Tools. It will show you the IP addresses per network device. In SQL Developer used XE as SID value. Now you should be able to connect as user system and create your own users and databases.

  3. Thanks so much for your help. That worked as you suggested by going into Ubuntu and goint to the System > Administration > Network Tools and got the IP Address of the Network Device – Ethernet Interface (eth0) and used that address in the Host field and with port set to 1521 and SID as XE.

    Thanks again.

    Paul

  4. hi i want to know exactly how i can set everything in my mac, beacuase i allready have ubuntu with oracle but i’m using netbeans to develop my programs and i want to know how can i connect to the databse in ubuntu.

    thanks in advance

  5. Why go through the pain? I just installed windoze XP in my parallels with oracle XE and it worked.

  6. This blog post was from 2007. The easiest solution now is to grab the available VMware image with Oracle XE and tools ready to go from http://www.bertscalzo.com/page5.html. Of course you could convert this for Virtualbox or Parallels. For our project XE is not enough any longer in the development/build phase as we depend on features which are not being supported by XE.

  7. oh what a surprise, i was sure XE was just for localhost connection and couldn’t in any case connect from remote servers.
    So the limit is just to max 10 connections

Leave a Comment

Required fields are marked *.