Installing Oracle 9i Client on Redhat 8 JRun Server Notes: http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/A96167_01/html/plan.htm#sthref23 http://www.tldp.org/HOWTO/Oracle-9i-RH8-HOWTO.html http://www.tldp.org/HOWTO/Oracle-9i-RH8-HOWTO-4.html#ss4.2 http://puschitz.com/InstallingOracle9i.shtml http://thomasfly.com/Oranux/Oracle9i.htm http://www.redhat.com/docs/manuals/rhea/RHEA-5.0-Manual/install-guide/install-prereqs.html Why is client needed: http://archive.develooper.com/dbi-users@perl.org/msg16482.html Create Oracle account: # groupadd oracle # useradd -c "The Oracle" -d /OraHome -m -g oracle oracle Create the OFA: # mkdir /u01 # mkdir /u02 # mkdir /u03 # mkdir /u04 # mkdir /u05 # chown oracle:oracle /u01 # chown oracle:oracle /u02 # chown oracle:oracle /u03 # chown oracle:oracle /u04 # chown oracle:oracle /u05 Login as oracle and set SSH Port Forwarding for X11 Reset the display (you musy install Oracle in the xterm window): $ unset DISPLAY The Pregame Show: $ mkdir /OraHome/ora9ias $ unset LD_LIBRARY_PATH $ ORACLE_BASE=/OraHome/ora9client; export ORACLE_BASE $ ORACLE_HOME=/OraHome/ora9client; export ORACLE_HOME Make sure you have the Xterm installed. # rpm -ivh /tmp/XFree86-xauth-4.2.0-72.i386.rpm # rpm -ivh /tmp/XFree86-base-fonts-4.2.0-72.i386.rpm # rpm -ivh /tmp/XFree86-4.2.0-72.i386.rpm If you had to install xauth and xterm now logout and log back in again making sure you have OpenSSH X11 port forwarding turned on. You should see: /usr/X11R6/bin/xauth: creating new authority file /OraHome/.Xauthority $ xterm (now inside the xterm) $ /orainst/Disk1/install/linux/runInstaller If you see... "../jre/bin/i386/native_threads/java: error while loading shared libraries: libstdc++-libc6.1-1.so.2: cannot open shared object file: No such file or directory" You probably need to install the compat-libstdc++ RPM which is a package for "Standard C++ libraries for Red Hat Linux 6.2 backwards compatibility". To rectify this problem, install the compat-libstdc++ RPM. http://rpmfind.maine.edu/RPM/redhat/8.0/i386/compat-libstdc++-7.3-2.96.110.i386.html # rpm -ivh /tmp/compat-libstdc++-7.3-2.96.110.i386.rpm Preparing... ########################################### [100%] 1:compat-libstdc++ ########################################### [100%] The install display should popup on the workstation. Install the Infrastructure first!! Prompts: Inventory: /OraHome/or9client/inventory UNIX Group Name: oracle The installer will now prompt you to run /tmp/orainstRoot.sh /tmp/orainstRoot.sh as root (in another window) Creating Oracle Inventory pointer file (/etc/oraInst.loc) Changing groupname of /OraHome/ora9client/oraInventory to oracle. You can now go back to the installer and click on "CONTINUE". File Locations: Take all the defaults should be fine. Select Client Install and Runtime Only Summary screen: Click on "Install". After the linking stage you will be asked to the root.sh script. In another window as root enter: # /OraHome/ora9client/root.sh Running Oracle9 root.sh script... \nThe following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /OraHome/ora9client Enter the full pathname of the local bin directory: [/usr/local/bin]: Copying dbhome to /usr/local/bin ... Copying oraenv to /usr/local/bin ... Copying coraenv to /usr/local/bin ... \nCreating /etc/oratab file... Adding entry to /etc/oratab file... Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root.sh script. Now product-specific root actions will be performed. After the install: # chmod 755 /OraHome # chmod 755 /OraHome/ora9client/jdbc/lib # chmod 755 /OraHome/ora9client/jdbc/lib/* Move the JDBC libraries into the JRun directory: # su - jrun $ cp /OraHome/ora9client/jdbc/lib/* /usr/local/jrun4/servers/lib/. Edit the .bashrc for the Java application requiring Type 2 JDBC driver and add the following lines: ORACLE_BASE=/OraHome/ora9client; export ORACLE_BASE ORACLE_HOME=/OraHome/ora9client; export ORACLE_HOME ORA_HOME= ORA_OWNER=oracle ORACLE_SID= # Oracle Environment ORACLE_HOME=/opt/oracle; export ORACLE_HOME ORACLE_SID=sid; export ORACLE_SID ORACLE_TERM=xterm; export ORACLE_TERM TNS_ADMIN=#ORACLE_HOME/network/admin; export TNS_ADMIN NLS_LANG=AMERICAN_AMERICA.UTF8; export NLS_LANG