After messing around with Postgres I decided I like Oracle better, but I like my Mac for a dev box. Unfortunately I have an old iMac and I think Oracle would overwhelm it so the first step was to install Oracle on an XP box. Next step was getting the Mac client working. Here are the steps:
- Download and install Oracle 9i on XP
- Download and install Oracle 9i for OSX
- cp oraenv and dbhome to /usr/local/bin
- create an /etc/oratab
- Make sqlplus work. I had to make a few symlinks
Barry-Books-Computer:/Users/oracle/Source bfb$ pwd
/Users/oracle/Source
Barry-Books-Computer:/Users/oracle/Source bfb$ ls -l
total 8
lrwxr-xr-x 1 root oracle 26 10 Feb 10:59 9iR2 -> /Users/oracle/9iR2/orahome
and in orahome
ln -s lib dylib
while you are at it
cd bin
ln -s bash ksh
- Get the 2.7 Oracle driver and build it
- comment out
apm_callback_and_log $callback "
- Loading SQLJ code $path/$file_path...
"
#db_source_sqlj_file -callback $callback "$path/$file_path"
#apm_callback_and_log $callback "
\n"
in acs-tcl/tcl/apm-install-procs.tcl
- Do all the usual Oracle install stuff.
I haven't done much testing but I can login. It should be possible to loadjava the CR files on a different machine if needed.