Installing Oracle 9i Client on Redhat 9 Server

Notes:

http://www.oreillynet.com/cs/user/view/cs_msg/25151
http://linux.oreillynet.com/pub/a/linux/2003/09/04/oracle_install.html

Unbundle the software:

# mkdir -p /install
# cp *.gz from each of the three cdrom's labeled "Oracle Linux 9.2.0.1 Disk n" to
the /install directory
# mkdir -p /orainst
# cd /orainst
# cpio -idmv </install/lnx_920_disk1.cpio
# cpio -idmv </install/lnx_920_disk2.cpio
# cpio -idmv </install/lnx_920_disk3.cpio
# rm /install/lnx_920_disk1.cpio
# rm /install/lnx_920_disk2.cpio
# rm /install/lnx_920_disk3.cpio

Add to /etc/profile (assuming oracle logs into ksh):

LD_ASSUME_KERNEL=2.4.1; export LD_ASSUME_KERNEL=2.4.1
ORACLE_BASE=/OraHome/ora9client; export ORACLE_BASE
ORACLE_HOME=/OraHome/ora9client; export ORACLE_HOME

Create Oracle account:

# groupadd oracle 
# useradd -c "The Oracle" -d /OraHome -m -g oracle oracle

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.3.0-2.i386.rpm
# rpm -ivh /tmp/XFree86-base-fonts-4.3.0-2.i386.rpm
# rpm -ivh /tmp/XFree86-4.3.0-2.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/orainventory

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/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=<your_Oracle_HOME_dir>
ORA_OWNER=oracle
ORACLE_SID=<your_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