June 26, 2006
Esteemed readers, this blog has moved. Please update your bookmarks and feed readers to point to http://www.halfcooked.com/blog instead of this page.
I shan't be posting any more entries to this blog but rest assured that the archives are staying. As part of this move comments have been closed on all of my existing weblog entries. If you have any problems with the new location or just fancy a chat send me an email. My address is andy47 at halfcooked.com.
June 18, 2006
More Oracle XE on Ubuntu
It's a pleasure to install and work with, but I've had just one niggling problem. Oracle XE uses Application Express for administration and development, except that I couldn't get it to work.
Thanks to this forum thread (sorry, you'll need a login to read it) I just needed to perform a simple chmod 666 to my $ORACLE_HOME/network/log/listener.log file and everything started working fine.
Apparently the Oracle XE application express application is served through the good old fashioned Oracle database listener and it wasn't starting properly. Something as simple as the permissions on the listener log file were causing it to fail at start up, Something I'd probably have figured out myself if I'd bothered to look at the other log files.