It has been a while since I last posted to the blog, my time has been consumed with all things Oracle and Open Source. At work, I have been placed on a team that will be leading the implementation of a new fundraising system form SunGardHe called Advance. As a result, I am leaving the world of Microsoft to develop my skills in Oracle. The product is running on Oracle 10g with an ASP.Net front end application.
In order to get “comfortable” with Oracle and specifically PL/SQL, I have been setting up a testing environment at home. The plan was to set up a Solaris box with a development version of Oracle 10g running that I could then play with and test without upsetting the dba’s at work. In theory this was a great idea however, it has proven to be somewhat daunting.
The problems started with the Solaris install. I downloaded the iso files only to find out that the DVD files that I downloaded were not liked by Toast on the Mac as it insisted they were CD files and refused to write them to my DVD. After losing much time with this task, I decided to set up a Win 2003 server and use the Windows version of 10g (not XE). I set up the server and implemented the necessary server settings. All was well.
Next, I downloaded and installed in on the Win server. Problems re-occurred. Days pass. Problem researched, solution found… or so I thought! After re-running then install several times, I decided to scrap the 10g set up and move to 10g XE. Becasue I was making this move, I decided it would be a learning experience to install 10g on the Mandriva Linux distribution (Limited Edition 2005). I downloaded Linux, installed and configured it. I then became familiar with Linux.
Next, I downloaded Oracle 10g XE for Linux, took me a couple of times to realize I needed the rpm version of the file. Got the right file and all is well. I ran the install and was abruptly met with a libaio error saying to install a version >= 0.3.98 or something to that effect. After much searching (it was not available from updates) I found a version (0.3.104), downloaded it, installed it and re-ran the install for Oracle 10g XE.
Error still there. Can’t get the correct version of libaio to satisfy Oracle, can’t get Oracle installed… so…
I nthe meantime, I tested a Windows Oracle install (10g full version) on a Win Media Center pc and all went well. New problem though is that I can’t get the listener to work…
New plan you say? I am thinking of going back the Win Server 2003 and installing the Oracle 10g XE engine on the server. I have this running on my XP laptop for work and it seems to work quite well.
Next new problem, Java Creator Studio and web deployment to my web hosting provider. I am new to Java leaving .Net behind and I am finding that the sites I create in Studio require Tomcat or some other java server component in order to run properly. If anyone knows if this is the case or not, please let me know!
I have plenty of Microsoft experience in both asp, VB, Windows/Networking and .Net however, the open source world of PHP and Java is calling… I only wish I had the patience to figure it out! Help a newbie!!!!