Installing Oracle 9i Client on Solaris 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

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.

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/runInstaller

The install display should popup on the workstation. 

Install the Infrastructure first!!

Prompts:

Inventory: /OraHome/ora9client/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 (/var/opt/oracle/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...

The 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 ...


Creating /var/opt/oracle/oratab file...
Adding entry to /var/opt/oracle/oratab file...
Entries will be added to the /var/opt/oracle/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 .profile 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