Running applications

Oracle

The information provided here is for sample purposes only. We recommend that you refer to the Oracle documentation for detailed information about installing and configuring Oracle. Visit the LKP web site for the latest information about running Oracle on the LKP. Information is provided here for both Oracle 8.1.7 and Oracle 9i installations. Oracle 9i is certified by Oracle for use with UnixWare 7 running the LKP.

Installing Oracle 8.1.7

The following tunable kernel parameter values were in effect for this sample installation:

SHMMAX = 2147483647

SHMMIN = 1

SHMMNI = 100

SEMMNI = 10000

SEMMSL = 300

SEMMNI = 10000

SEMMSL = 300

SEMMNS = 610

SEMOPM = 20

SCORLIM = 0x7fffffff

HCORLIM = 0x7fffffff

SDATLIM = 0x7fffffff

HDATLIM = 0x7fffffff

SVMMLIM = 0x7fffffff

HVMMLIM = 0x7fffffff

SFSZLIM = 0x7fffffff

HFSZLIM = 0x7fffffff

HFNOLIM = 2048

SFNOLIM = 128

NPROC = 12500

ARG_MAX = 1048576

NPBUF = 100

MAXUP = 5000

RECVRETRIES = 5

MAXULWP = 10000

FLCKREC = 2000

Limitations

Currently, Oracle database files can be no larger than 2GB.

Users and groups

Add a Database Administrator (dba) group:
```
   groupadd dba
```
Add a user called ``oracle'' to the dba group:
```
   useradd -g dba -d /home/oracle -s /linux/bin/bash -c 'oracle account' oracle
```
NOTE: You can make any other user a database administrator by putting them in the dba group. Having several database administrators can be useful for auditing purposes.

Create an oracle directory and change ownership and group.

   mkdir /home/oracle
   chown oracle /home/oracle
   chgrp dba /home/oracle

Set a password for the oracle user:
```
   passwd oracle
```

Workarounds

A workaround is necessary to run Oracle on LKP/Caldera OpenLinux. Obtain the glibc-2.1.3-stubs.tar.gz patch for Oracle 8.1.7 from the Oracle download site (Oracle bug references 1489496 and 1467074). This patch allows Oracle 8.1.7 to install properly on Linux distributions based on glibc versions 2.2 and above. Keep this patch handy for use later in the install.

Oracle 8.1.7 requires a specific release of Java. You can download this from: ftp://ftp.tux.org/pub/java/JDK-1.1.8/i386/v3/jdk118_v3-glibc-2.1.3.tar.bz2

   # linux
   bash# mkdir /home/oracle/oracle_java
   bash# chown oracle:dba /home/oracle/oracle_java
   bash# cd  /home/oracle/oracle_java
   bash# bzcat /tmp/jdk118_v3-glibc-2.1.3.tar.bz2 | tar xf -
   bash# rm /tmp/jdk118_v3-glibc-2.1.3.tar.bz2
   bash# ln -s jdk118_v3 java

Put in links to satisfy hardcoded references in Oracle install scripts for /bin/awk and /bin/grep.
```
   bash# ln -s /usr/bin/gawk /bin/awk
   bash# ln -s /usr/bin/grep /bin/grep
```
The Oracle http daemons require libdb.so.3, which is not available by default. Verify that the csm-compat-1.0-3 RPM package is installed on your system.
```
   rpm -q csm-compat-1.0-3
```
If it is not there, install the package from the Caldera OpenLinux 3.1 CD.
Edit /etc/ld.so.conf and add this line.
```
   /opt/csm/lib/compat
```
Make the library available by running:
```
   bash# ldconfig
```

Installing Oracle

From UNIX mode, mount the Oracle CD.

   # mount -F cdfs -o ro /dev/cdrom/cdrom1 /linux/mnt/cdrom

Edit your shell's startup file, or a separate file, and set environment variables. For example, the sample file my_oracle_env contains:

   ORACLE_HOME=/home/oracle/oracle817
   export ORACLE_HOME
   ORACLE_SID=db1
   export ORACLE_SID
   PATH=/bin:/usr/bin:/usr/local/bin:/opt/bin:/opt/kde2/bin:/opt/kde/bin:/usr/java/bin:/usr/X11R6/bin:/opt/teTeX/bin:$ORACLE_HOME/bin
   export PATH
   LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
   export LD_LIBRARY_PATH

Make the environment variables active.

   bash$ . ./my_oracle_env

Change directory and list directory contents.

   bash$ cd /mnt/cdrom
   bash$ ls
   doc  index.htm  install  response  runInstaller  stage

Run the installer
```
   bash$ ./runInstaller
```
and follow the instructions on the screen.
NOTE: The Oracle Database Configuration Assistant might be automatically launched during the install. If it fails to run, ignore the reported error. If it succeeds in launching before you have installed the glibc-2.1.3-stubs.tar.gz patch from Oracle, cancel it at the earliest opportunity.
When you have finished the install, apply the glibc-2.1.3-stubs.tar.gz patch before running Oracle. Copy the patch file into your ORACLE_HOME directory, then:
```
   bash$ cd $ORACLE_HOME
   bash$ tar xfz glibc-2.1.3-stubs.tar.gz
   bash$ ./setup_stubs.sh
```
Oracle is now ready for use. If you want to create an initial database using the Oracle Database Configuration Assistant, run
```
   bash$ dbassist
```

Installing Oracle 9i

Oracle 9i is certified on UnixWare 7 with Maintenance Pack 1 (ou800pk1) and Support Level Supplement ptf8002 (the Oracle9i PTF). Both ou800pk1 and ptf8002 are included in Release 7.1.3.