Installing the ArsDigita Oracle driver 2.0 for AOLserver

1. Download

Get the oracle8 driver from Arsdigita (or use the file oracle-2_0_1_tar.tgz in qfs01/data1/Linux/AOLserver).

If it's not there anymore and you need this version, you could ask me nicely :)

2. Untar

Create a directory anywhere for the driver. Type:
tar -zxf oracle-2_0_1_tar.tgz

This will extract the files needed.

3. Install necessary packages

If you don't already have the C++ compiler and associated files, you need to install them. If you don't know what is already installed, just reinstall them all.

mount the Red Hat CD (disk 1), go to RedHat/RPMS and type
rpm -i make [TAB]
rpm -i cpp [TAB]
rpm -i egcs-1 [TAB]
rpm -i glibc-dev [TAB]
rpm -i kernel-h [TAB]

4. Compile the Oracle8 driver

Go back to the directory where you untarred your files. The compiler needs to know where Oracle and AOLserver are installed. Edit makefile and make the changes to the paths stored in $ORACLE_HOME and $NS_HOME. In my case these are /apps/oracle/product/8.1.5 and /apps/aolserver respectively.

The compiler also expects an oracle library to exist which doesn't, so type

ln -s /apps/oracle/product/8.1.5/lib/ /apps/oracle/product/8.1.5/lib/
Edit the makefile and go down to the line that starts with ORACLE_81_OBJECTS= and swap around the order of libclntsh and lgeneric.

Now type make. You will get a few warnings, but ora8.o and should be created. Copy to your bin directory in aolserver's home (/apps/aolserver/bin for me).

5. Tell AOLserver about the driver

Add a line your aolup script in /usr/bin, before AOLserver is started, reading
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib
Fire up a web browser and point it to http://qfs02:9876/NS/Setup (where qfs02 is your Linux box). Click "Database Drivers"
Click "Add Database driver"
Enter oracle in the name field
Enter in the filename field
Click "Add"
Click "Add"

Back to the main setup page, and click "Database Pools"
Click "Add Database Pool"
Enter oraclepool in the name field
Click "Add" Select oracle from the pull-down list
Leave connections on 2 for now
Enter an Oracle user from which to access the database from in the user field
Enter that user's password in the password field
Set verbose off
Set LogSQLErrors on
Set ExtendedTableInfo on
Click "Add"