Oracle8i release 3 (8.1.7) on RedHat 9

From Oracle FAQ
Jump to: navigation, search

Login as root.

First remove the package compat-libstdc++-devel-7.3-2.96.118 as:

# rpm -e --nodeps compat-libstdc++-devel

Then remove compat-libstdc++-7.3-2.96.118 as:

# rpm -e --nodeps compat-libstdc++

Then install following packages which are provided with Oracle 8.1.7 CD in the same order as given below:Ensure that there is no error during this package installation

# cd /mnt/cdrom
# rpm -ivh compat-libstdc++-6.2-2.9.0.16.i386.rpm
# rpm -ivh compat-glibc-6.2-2.1.3.2.i386.rpm
# rpm -ivh compact-egcs-6.2-1.1.2.16.i386.rpm
# rpm -ivh compact-egcs-c++-6.2-1.1.2.16.i386.rpm                                         
# rpm -ivh compact-egcs-g77-6.2-1.1.2.16.i386.rpm
# rpm -ivh compact-egcs-objc-6.2-1.1.2.16.i386.rpm 			 
# rpm -ivh compact-libs-6.2-3.i386.rpm	                                

Copy and extract the file i386-glibc-2.1-linux.tar

# cp i386-glibc-2.1-linux.tar /home1 
# cd /home1    
# tar -xvf i386-glibc-2.1-linux.tar

While extracting this tar file,a directory named ‘usr’ will be generated in current path.Copy the ‘i386-glibc21-linux’ directory of ‘usr/i386-glibc-2.1-linux’ to /usr.

Before installing Oracle 8i,check the following are available:

# cd /usr/bin
# ls -l gcc
# ls -l cc
# ls -l i386-glibc21-linux-gcc

Group and User creation

Create group oinstall,dba

# groupadd oinstall
# groupadd dba

Create user oracle with group dba with home directory /home1/oracle

# useradd -g oinstall -G dba -d /home1/oracle oracle
# passwd oracle          ( Give oracle password )

Profile Modification

# su - oracle
# vi .bash_profile

This file should be as follows:

# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/bin
. /usr/i386-glibc21-linux/bin/i386-glibc21-linux-env.sh	[Please note space ‘. /usr’]
export PATH
umask 022
unset USERNAME
export TERM=vt100
export LD_ASSUME_KERNEL=2.2.5
export ORACLE_BASE=/home2/oracle
export ORACLE_HOME=/home2/oracle/product/8.1.7
export PATH=.:/usr/bin:/bin:/usr/local/bin:$ORACLE_HOME/bin:$ORACLE_HOME/ctx/lib:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib:$LD_LIBRARY_PATH
export ORACLE_SID=prutech
export ORACLE_TERM=xterm
export DISPLAY=localhost:0.0
export KDE_DISPLAY=localhost:0.0
export LDEMULATION=elf_i386

copy the file j2sdk-1_3_1_02-linux-i386.bin to /usr.Give full permission to this bin file.

# chmod 777 j2sdk-1_3_1_02-linux-i386.bin

Install Java as follows:

# ./j2sdk-1_3_1_02-linux-i386.bin

Press space bar when license agreement shows. After this installation, create a link as:

# cd /usr/local
# ln -s /usr/jdk1.3.1_02 java

Copy the file linux81701.tar to /home1 and extract it.

# tar -xvf linux81701.tar

Then a directory named ‘Disk1’ will be created

Log on as root

# xhost +localhost
# su - oracle

(Note :- Press Num Lock ON state).

Change directory to Disk1/install/linux

$ cd Disk1/install/linux
$ ./runInstaller

Now graphical installation will be starts.Select the options as per requirement. During this session the installer prompted to run a shell orainstRoot.sh

To run this shell,it is necessary to switch from oracle user to root user.i.e (Don’t use su -)

$ su root
# cd /home2/oracle/product/8.1.1
# sh orainstRoot.sh

After run this shell successfully,click Retry button of warning message.

Select the required options and continue installation.Ignore relink errors.

When this pre-installation finish, a prompt will shows to run root.sh

# sh root.sh

Enter full path of local bin directory - /usr/local/bin

Oracle installer also starts some automatic tools installation,ie some database configuration tools...cancel it. Finish the runInstaller.

Post Installation procedure

Copy the glibc-2.1.3-stubs.tar file to /home2/oracle/product/8.1.7

$ tar -xvf glibc-2.1.3-stubs.tar

This will create a directory lib, two files setup_stubs.sh, README.stub

$ cd $ORACLE_HOME
$ sh setup_stubs.sh
$ vi genclntsh

then edit LD_SELF_CONTAINED=” “

$ ./gencltsh
$ ./relink all
$ dbassist

Creates the database as per user configuration. i.e for tablespaces, db block buffers, redolog buffers and log buffers... Finish dbassist. Database creation completed.

Edit init.ora update parameters if required.

cd $ORACLE_HOME/bin
$ ./netca (for listener and tnsnames.ora  creation)
$  vi listener.ora

verify host,port,sid..etc.

$  lsnrctl services   (for checking listener )
$  tnsping webwvr     ( to check ping  to same database websvr)    
$  sqlplus system/manager@websvr (connect to same database to check listener.ora                  

and tnsnames.ora are working)

$ cd $ORACLE_HOME/sqlplus
$ vi glogin.sql and add               define _editor=vi

set nls_date_format=’DD/MM/YYYY’

$ cd /$ORACLE_HOME/bin   sh helpins.sh     (to get help in sqlsplus)
$ cd /$ORACLE_HOME/bin/   vi dbshut  add ‘immediate’  before shutdown word.

Let me know your status. Mail me at dhanooj_kp@yahoo.co.in or dhanooj_kp@hotmail.com.