Oracle XE production release Mini Review

Oracle XE production release Mini Review

Posted by Luis Majano
Feb 28, 2006 00:00:00 UTC
I just recently installed beta 3 of Oracle Express and was amazed with it. I have been doing Oracle development alongside ColdFusion for about 6 years now. Oracle is not an easy puppy to install and configure, especially under Linux or any Unix flavor. However, in windows, although performance lacking, but installation heaven.

Oracle release the production version of XE on Feb 24 and I should be trying to upgrade to it this week.


Administration Home

Object Browser Home

As for the beta 3 here is my mini-review:

With Oracle Database XE, you can now develop and deploy applications with a powerful, proven, industry-leading infrastructure, and then upgrade when necessary without costly and complex migrations.

Oracle Database XE can be installed on any size host machine with any number of CPUs, but this free version of the world's leading database will store up to 4GB of user data, use up to 1GB of memory, and use one CPU on the host machine.

The installer is pretty straightforward and easy to setup. The only weird thing I experienced was that I was unable to connect to other databases I had setup on my 10g Client install. Since XE replaces the system paths, everything looks at this new Oracle Home. So I basically had to move all my entries on my tnsnames.ora to the one in the XE directory. Simple and logical.

Apart from that little glitch, the database purrs!! I was connected to it through Toad, Coldfusion, DB Solo, and Aqua Data Studio with no problems. The database web tool is extremely intuiative and easy to use.

This database is a great starter database if you haven't messed in the Oracle World. Every feature is there as far as I can see, except well the 4gb of data limitation.

Here is a great blog by Tug, who has created a viewlet that shows you how easy it is to install this wonderful database.



Oscar Arevalo

What is really cool now is that the three major flavors of databases are now free for everyone to use: MSSQL Server (via SQL Server Express), MySQL and Oracle Express. Although I guess the only one that can scale as much as you want without having to purchase licenses is mySQL. Anyway, I think this kind of choice is nothing but good.

Site Updates

Entry Comments


Entries Search