The
Ultimate
Business Machine

Technology, business
and innovation.

And, not least, about
the Mac.

Weblog • Archive • Cutedge

by: Bernard Teo








Creative Commons License

Copyright © 2003-2012
Bernard Teo
Some Rights Reserved.

The Ultimate Business Machine - Archives

List of Categories : Database * Technology * Commentary * Singapore * Travel *

Tue 03 Aug 2004

Oracle 10g on OS X

Category : Technology/Oracle10g.txt

We've got Oracle 10g running on OS X. This is the Oracle Database 10g Early Adopters' Release 2 for Mac OS X.

It's supposed to need OS X Panther Server but we've managed to install and run it on a normal OS X Panther machine. But the installation process seems to have gotten so much harder. Even I could handle Oracle 9i but, for 10g, we've got to send in the commandos (command-line-philiac people like Chiang Hai Hwee).

We're testing it by running Luca (our Accounting application) over it. This is what we've found so far, in comparison to running Luca over MySQL.

The first one is minor. There are some incompatible SQL statements, due to the differences in the SQL dialects spoken by Oracle and MySQL.

Second. We've got to take note of the following while programming Luca - MySQL search strings are not Case-Sensitive, but Oracle's are, so some searches can be found by MySQL, but not by Oracle.

Here's a major showstopper. MySQL handles semaphores (so that we can prevent more than one person updating a database record at the same time) by names, but we had to use table locking in Oracle, which results in deadlocks, even with a single user logged in. We need to review this part. Maybe we're wrong?

On top of it, Oracle 10g feels significantly slower than both 9i or MySQL, when tested on the same machine. But then, we don't know much, yet, about tuning this beast. And this, I must stress, is not the final product.

It's interesting how MySQL gets more and more attractive all the time. Score one for the Open Source Movement?

Posted at 10:25AM UTC | permalink

Mac@Work
Put your Mac to Work

• Sivasothi.com? Now how would you do something like that?
• Weblogs. Download and start a weblog of your own.
• A Mac Business Toolbox
A survey of the possibilities
• A Business Scenario
How we could use Macs in businesses
• VPN Enabler for Mavericks
• MailServe for Mavericks
• DNS Enabler for Mavericks
• DNS Agent for Mavericks
• WebMon for Mavericks
• Luca for Mavericks
• Liya for Mountain Lion & Mavericks
• Postfix Enabler for Tiger and Panther
• Sendmail Enabler for Jaguar

Services running on this server, a Mac Mini running Mac OS X 10.9.2 Mavericks:

  • Apache 2 Web Server
  • Postfix Mail Server
  • Dovecot IMAP Server
  • Fetchmail
  • SpamBayes Spam Filter
  • Procmail
  • BIND DNS Server
  • DNS Agent
  • WebDAV Server
  • VPN Server
  • PHP-based weblog
  • MySQL database
  • PostgreSQL database

all set up using MailServe, WebMon, DNS Enabler, DNS Agent, VPN Enabler, Liya and our SQL installers, all on Mavericks.