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

Categories: oracle