How to install Oracle 9.2.0.4 on Redhat linux 9

Setting Shared Memory

(root 계정으로 진행)
1. # cat /proc/sys/kernel/shmmax
2147483648
# echo 2147483648 > /proc/sys/kernel/shmmax
# sysctl -w kernel.shmmax=2147483648
# echo "kernel.shmmax=2147483648" >> /etc/sysctl.conf
2. # cat /proc/sys/kernel/shmmni
4096
# echo 4096 > /proc/sys/kernel/shmmni
# sysctl -w kernel.shmmni=4096
# echo "kernel.shmmni=4096" >> /etc/sysctl.conf
3 $ getconf PAGE_SIZE
4096
# cat /proc/sys/kernel/shmall
2097152
# echo 2097152 > /proc/sys/kernel/shmall
# sysctl -w kernel.shmall=2097152
# echo "kernel.shmall=2097152" >> /etc/sysctl.conf

Creating Oracle User Accounts

4. su - root
groupadd dba # group of users to be granted with SYSDBA system privilege
groupadd oinstall # group owner of Oracle files
useradd -c "Oracle software owner" -g oinstall -G dba oracle
passwd oracle

Creating Oracle Directorieser

5. su - root
mkdir -p /u01/app/oracle/product/9.2.0
(mkdir -p /oracle/product/9.2.0)
chown -R oracle.oinstall /u01
(chown -R oracle.oinstall /oracle)
(chown -R oracle.oinstall /ora-data)

mkdir /var/opt/oracle
chown oracle.dba /var/opt/oracle
chmod 755 /var/opt/oracle

Setting Oracle Environments

6.
(oracle 계정으로 진행 # su - oracle)
# Set the LD_ASSUME_KERNEL environment variable only for Red Hat 9,
# RHEL AS 3, and RHEL AS 4 !!
# Use the "Linuxthreads with floating stacks" implementation instead of NPTL:
export LD_ASSUME_KERNEL=2.4.1 # for RH 9 and RHEL AS 3
export LD_ASSUME_KERNEL=2.4.19 # for RHEL AS 4

# Oracle Environment
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/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
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib
export LD_LIBRARY_PATH
export DISPLAY=127.0.0.1:0.0

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

JDK
According to the JDK documentation, install JDK under /usr/local. Then create a symbolic link to the JDK under /usr/local/java:
7. su - root
bzip2 -dc jdk118_v3-glibc-2.1.3.tar.bz2 | tar xf - -C /usr/local
ln -s /usr/local/jdk118_v3 /usr/local/java

8. radhat 9에 /usr/bin/gcc296을 gcc로 링크한다.
# 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++

Uncompress and unpack downloaded files: For Oracle9i (9.2.0):

8. # cd /work
# zcat ship_9204_linux_disk1.cpio.gz | cpio -idmv
9. # zcat ship_9204_linux_disk2.cpio.gz | cpio -idmv
10. # zcat ship_9204_linux_disk3.cpio.gz | cpio -idmv


11. # startx <- x윈도우 실행하고
# cd /oracle/Disk1
# ./runoraInstaller
11.1 오라클 인스톨러 실행중 한글이 깨져서 보일때
11.1.1 Disk1/stage/Components/oracle.swd.jre/1.3.1.0.0/1/DataFiles/Expanded/jre/linux/lib/fonts
위의 경로에 batang.ttc gulim.ttc mingliu.ttc (windows font) 세 파일을 복사해넣는다.
11.1.2 Disk1/stage/Components/oracle.swd.jre/1.3.1.0.0/1/DataFiles/Expanded/jre/linux/lib/fonts/fonts.dir
의 내용을 edit하여 다음 3라인을 추가한다.
batang.ttc -ms-batang-medium-r-normal--0-0-0-0-c-0-ksc5601.1987-0
gulim.ttc -ms-gulim-medium-r-normal--0-0-0-0-c-0-ksc5601.1987-0
mingliu.ttc -ms-mingliu-medium-r-normal--0-0-0-0-c-0-ksc5601.1987-0
11.1.3 Disk1/stage/Components/oracle.swd.jre/1.3.1.0.0/1/DataFiles/Expanded/jre/linux/lib
위의 경로에 font.properties.ko 파일을 추가한다

12. 오라클 인스톨러 실행중에
'/tmp/orainstRoot.sh'를 root 계정으로 실행하고 continue하란다.. 시키는데로 하자
12.1 인스톨 중, 끝부분에서 Linking 을 할때(84%) 쯤에, Error in invoking target install of makefile /Oracle/product/9.2.0/ctx/lib/ins_ctx.mk 에러메세지가 발생한다면
12.1.1 $vi $ORACLE_HOME/ctx/lib/env_ctx.mk 를 에디트
"INSO_LINK =" 이 부분에 "$(LDLIBFLAG)dl" 추가
예)
INSO_LINK =
-L$(CTXLIB) $(LDLIBFLAG)m $(LDLIBFLAG)dl $(LDLIBFLAG)sc_ca $(LDLIBFLAG)sc_fa
$(LDLIBFLAG)sc_ex $(LDLIBFLAG)sc_da $(LDLIBFLAG)sc_ut $(LDLIBFLAG)sc_ch $(LDLIBFLAG)sc_fi
$(LLIBCTXHX) $(LDLIBFLAG)c -Wl,-rpath,$(CTXHOME)lib $(CORELIBS) $(COMPEOBJS)

13. sys/sysadmin
14. system/sysadmin

15. #sqlplus /nolog
sql>connect sys/sysadmin as sysdba
sql>quit
#lsnrctl
lsnrctl>start
lsnrctl>quit