How to install oracle9i on Linux(RHEL AS 3)

Here I show a simplified steps for installation oracle9i in Linux (Red Hat Enterprise Linux Advanced Server 3)

–set system environment
su – root
echo `expr 512 \* 1024 \* 1024` > /proc/sys/kernel/shmmax
groupadd dba
useradd -c “Oracle software owner” -g dba oracle
passwd oracle
oracle (input twice)
mkdir -p /opt/oracle/product/9.2.0
chown -R oracle.dba /opt/oracle
mkdir -p /var/opt/oracle
chown oracle.dba /var/opt/oracle
chmod 755 /var/opt/oracle

add content below to ~oracle/.bash_profile
————————————————————
#added for oracle
# Set the LD_ASSUME_KERNEL environment variable only for Red Hat 9 and
# for Red Hat Enterprise Linux Advanced Server 3 (RHEL AS 3) !!
# Use the “Linuxthreads with floating stacks” implementation instead of NPTL:
export LD_ASSUME_KERNEL=2.4.1

# Oracle Environment
export ORACLE_BASE=/opt/oracle
export ORACLE_HOME=/opt/oracle/product/9.2.0
export ORACLE_SID=test
export ORACLE_TERM=xterm
# export TNS_ADMIN= Set if sqlnet.ora, tnsnames.ora, etc. are not in $ORACLE_HOME/network/admin
export NLS_LANG=AMERICAN;
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/network/lib
export LIBPATH=$ORACLE_HOME/lib32:$ORACLE_HOME/lib

# Set shell search paths
export PATH=$PATH:$ORACLE_HOME/bin

————————————————————

–relink gcc g++
su – root
mv /usr/bin/gcc /usr/bin/gcc323
ln -s /usr/bin/gcc296 /usr/bin/gcc
mv /usr/bin/g++ /usr/bin/g++323      # if g++ doesn’t exist, then gcc-c++ was not installed
ln -s /usr/bin/g++296 /usr/bin/g++

–install system patch
download the patch p3006854_9204_LINUX.zip from http://metalink.oracle.com.
See bug 3006854 for more information.
su – root
# unzip p3006854_9204_LINUX.zip
Archive:  p3006854_9204_LINUX.zip
creating: 3006854/
inflating: 3006854/rhel3_pre_install.sh
inflating: 3006854/README.txt

# cd 3006854
# sh rhel3_pre_install.sh
Applying patch…
Patch successfully applied
#

–install oracle
su – oracle
Now runInstaller can be started from the CD:
….

–upgrade oracle
download the Oracle 9i Release 2 Patch Set Version 9.2.0.6.0 for Linux x86 from http://metalink.oracle.com.
su – oracle
$ cp p3948480_9206_LINUX.zip /tmp
$ cd /tmp
$ unzip p3948480_9206_LINUX.zip
…..
$ cd /tmp/Disk1/
$ ./runInstaller
install “Oracle Universial Installer 2.2.0.18.0 ”
install “Oracle9iR2 Patch Set 9.2.0.6.0 !””

–set system parameter
add content below to ~oracle/.bash_profile
————————————————————
#for oracle
kernel.shmmax=536870912
kernel.sem= 250 32000 100 128
fs.file-max=65536
————————————————————

–restart machine

–create db (pna)

su – oracle
dbca

Advertisements

About Alex Zeng
I would be very happy if this blog can help you. I appreciate every honest comments. Please forgive me if I'm too busy to reply your comments in time.

One Response to How to install oracle9i on Linux(RHEL AS 3)

  1. neworacledba says:

    Installation in RHEL has been explained clearly

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: