Several months ago I came across a similar problem.  Oracle 8.1.7 for RedHat
7.3.  Oracle ALWAYS pestered me stating they supported up to RedHat 7.1
(which has the older glibc 2.1 I think).  They used this to build Oracle for
Linux and will NOT certify that anything beyond 7.1 will work.

After much fevered work I was able to come up with something that worked for
us.  Since then I've come across the following web site which has helped a
great deal:

 http://staff.in2.hr/denis/oracle 

Denis has instructions for Oracle 8 and 9.  I didn't see anything for RedHat
8.0 however it should be close.

There is one other piece you will need to set things up just right.

export LD_ASSUME_KERNEL=2.2.5
source /usr/i386-glibc21-linux/bin/i386-glibc21-linux-env.sh

You will need the 6.2 compatibility libraries loaded.  If RedHat 8.0 has
this then you are in good shape.  

Here is the bulk of my install instructions.  It should be pretty complete.
 Hope it helps.  FYI.. they are posted in OTN also.  

The main system I built has been tested for nearly 2 months now and is
solid.  We've been pounding the system hard (disk/cpu utilization 80%-90%+).
 Two weeks ago it went beta production.  A one year test to see how it
handles the real world.  So far so good.  My supervisor is pleased :-)

I tried to clean it up a little for email.  Hope it's readable :-D


---
Things you need before the installation

Before you start installing Oracle, you need to have the following packages:

    *      jdk-1.1.8_v3 - Blackdown Linux port of Sun's Java Development Kit
- You can find it at www.blackdown.org

    *      Customized Linux kernel - Include memory/semaphore modifications.

Red Hat Linux 6.2 compatibility packages

    *      compat-libstdc++-6.2-2.9.0.16

    *      compat-glibc-6.2-2.1.3.2

    *      compat-libs-6.2-3

    *      compat-egcs-6.2-1.1.2.16


You can find these packages on your RedHat CDs, download them from RedHat
site, or from some mirror site.

    *      Patch 2062512 - ctx_env.mk modification. Found on Oracle's
Metalink site.


Customize Linux kernel

First things first. Oracle documentation specifies a number of changes to
the kernel source code. Perform the following changes before continuing.
Failure to complete may result in failure to start an Oracle instance.

#vi /usr/src/linux/include/asm/shmparam.h

add the following lines:


#define SHMMAX 4294967295
#define SHMMIN 1
#define SHMMNI 200
#define SHMSEG 20

save and exit.


Customize Linux kernel pt.2

Next modify sem.h

#vi /usr/src/linux/include/linux/sem.h

add the following lines:


#define SEMMNI 100
#define SEMMSL 250
#define SEMMNS 1000
#define SEMOPM 100
#define SEMVMX 32767


FYI: Some settings have been changed from the book. Modify as needed.


Installing compatibility packages

Install all of the RedHat 6.2 compatibility packages mentioned above by
issuing rpm -Uvh package_name, e.g:

# rpm -Uvh /mnt/cdrom/RedHat/RPMS/compat-libs-6.2-3.i386.rpm


Installing Java development kit

According to jdk documentation, we will install it under /usr/local by
issuing e.g.

# tar -xvjf jdk-1.1.8_v3.tar.bz2 -C /usr/local


Note that it is not necessary to add path to the java executables in PATH
environment variable, so you can safely keep whatever jdk or jre version you
already have. Also remember to create a symbolic link called 'java' under
/usr/local and used this for all Java references.


User oracle, groups and software mount points

We need to create group dba and user oracle..

The oracle user will own all the installation files. We also need group dba,
that will have oracle's SYSDBA and SYSOPER privileges granted. Note that all
linux users (accounts) that are in group dba will also get these privileges.

# groupadd oracle 
# groupadd dba
# useradd -g dba oracle 
# passwd whatever_you_want_here

Create directories in which database files will reside. Oracle recommends
OFA - Optimal Flexible Architecture (see oracle installation guide), but in
this example everything will be installed under /opt/oracle:


# mkdir
/opt/oracle/product
# cd
/opt/oracle/product
# mkdir 8.1.7
# chown -R
oracle:dba /opt/oracle/*


Setting the environment for oracle account

We should now login as user oracle and put the following lines at the end of
.bash_profile:

export LD_ASSUME_KERNEL=2.2.5
source /usr/i386-glibc21-linux/bin/i386-glibc21-linux-env.sh
export ORACLE_BASE=/opt/oracle
export ORACLE_HOME=$ORACLE_BASE/product/8.1.7
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export JAVA_HOME=/usr/local/java
export PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_SID=main

First two lines modify your environment so that gcc and ld look for glibc
2.1.3 compatibility headers and libraries. Note that all other variables
defined here are mandatory. It is highly recommended that JAVA_HOME be setup
to /usr/local/java and point to the Blackdown - Java distro.

The .bash_profile should now be executed in order to initialize these variables:

$ source /home/.bash_profile

or we can just log off and than back on as user oracle.

If you use some shell other than bash (tcsh, sh, ...) all of those variables
should be set according to syntax of your shell and put in script that
automatically executes at user login.


Running the installer

Oracle installer should be run from Xwindows by user oracle.

Start Xwindows and from terminal window mount Oracle 8i CD-ROM and start the
installer:

$ /mnt/cdrom/runInstaller

or if you have downloaded linux81701.tar from Oracle, untar it somewhere you
have read/write privledges and then run the installer:

$ tar -xvf linux81701.tar -C /tmp/ $ /tmp/Disk1/runInstaller

Creating the database

Chosing typical installation will result in an error message when compiling
env_ctx. Copy the env_ctx.mk patch (patch 2062512) to '$ORACLE_HOME/ctx/lib'
then click 'retry'. The linking will complete successfully. The database
assistant will successfully create/initialize the database.

Oracle will recommend installation of glibc21-stubs patch. During our
testing we experienced severe problems with linking oracle after applying at
the appropriate time. We recommend against using the glibc21-stubs patch
with Oracle 8.1.7 and RedHat 7.3


Running the database for the first time

Let's actually start the database now:

$ svrmgrl

Oracle Server Manager Release 3.1.7.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.

Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production
With the Partitioning option
JServer Release 8.1.7.0.1 - Production
SVRMGR> connect internal
Connected.
SVRMGR> startup
ORACLE instance started.
Total System Global Area 72704160 bytes
Fixed Size 73888 bytes
Variable Size 55681024 bytes
Database Buffers 16777216 bytes
Redo Buffers 172032 bytes
Database mounted.
Database opened.
SVRMGR> exit
Server Manager complete.
>$

In order to use dbstart and dbshut scripts for starting/stopping the
database we must edit the /etc/oratab.

It should contain a line that looks something like this:

*:/home/oracle/product/8.1.7:N

Just change the last parameter to Y

Now let's try to connect to the database using SQL*plus:

$ sqlplus scott/tiger


SQL*Plus: Release 8.1.7.0.0 - Production on Pon Srp 8 00:14:22 2002

(c) Copyright 2000 Oracle Corporation. All rights reserved.

Connected to:

Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production

With the Partitioning option

JServer Release 8.1.7.0.1 - Production

SQL> select sysdate from dual;

SYSDATE
--------
08.07.02

SQL> select * from dept;

DEPTNO DNAME LOC
---------- -------------- -------------
10 ACCOUNTING NEW YORK
>20 RESEARCH DALLAS
>30 SALES CHICAGO
40 OPERATIONS BOSTON
SQL> exit

Disconnected from Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production
With the Partitioning option
JServer Release 8.1.7.0.1 - Production

$

You can shut down the server using the dbshut script, or via server manager:

$ svrmgrl

Oracle Server Manager Release 3.1.7.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.

Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production
With the Partitioning option
JServer Release 8.1.7.0.1 - Production

SVRMGR> connect internal
Connected.
SVRMGR> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SVRMGR> exit
Server Manager complete.
$




-- 
redhat-list mailing list
unsubscribe mailto:[EMAIL PROTECTED]?subject=unsubscribe
https://listman.redhat.com/mailman/listinfo/redhat-list

Reply via email to