[{TableOfContents}]

!!! 참고 URL
*[구굴링 결과중 하나|http://72.14.253.104/search?q=cache:iPHro3NqOmUJ:blogmeme.com/blog/index.php%3Fblog_code%3Dcomdemo%26article_id%3D463+p3006854_9204_LINUX.zip&hl=ko&gl=kr&ct=clnk&cd=1&lr=lang_ko&client=firefox]
*[오라클 9i설치|http://blog.empas.com/leejung0/read.html?a=6553024]
*[runinstall 에러 관련|http://www.soqool.com/servlet/board?cmd=view&cat=130&subcat=1310&seq=290&page=1&position=1]
*[래드햇9설치|http://suny1211.egloos.com/284113]
*[오랠리 래드햇9 설치 | http://linux.oreillynet.com/lpt/a/4141]
*[OTN문서|http://www.oracle.com/technology/global/kr/pub/articles/hunter_rac_3.html]
*[개인홈페이지 문서|http://ccc.mzin.net/lecture/linux/applications/oracle/9i-install.txt]

!!!ORACLE 9i설치(Redhat 9.0에서 테스트)

!! 오라클 Group과 유저 생성
{{{
groupadd dba
useradd -g dba oracle

passwd oracle

mkdir -p /usr/oracle/product/9.2
mkdir /var/opt/oracle
chown oracle.dba /var/opt/oracle
chown -R oracle.dba /usr/oracle
chmod 755 /var/opt/oracle
}}}


!! 필수 패키지 설치
{{{
gcc-3.2.2-5
cpp-3.2.2-5
glibc-devel-2.3.2-11.9
binutils-2.13.90.0.18-9
compat-gcc-7.3-2.96.118.i386.rpm
compat-libgcj-7.3-2.96.118.i386.rpm
compat-libgcj-devel-7.3-2.96.118.i386.rpm
nss_db-compat-2.2-20.i386.rpm
}}}


!! 시스템 환경 변수 수정
{{{
vi /etc/sysctl.conf
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.shmall = 2097152
kernel.sem    = 250 32000 100 128
fs.file-max   = 65536

net.ipv4.ip_local_port_range = 1024 65000
   
vi /etc/security/limits.conf
oracle soft nofile 65536
oracle hard nofile 65536
oracle soft nproc 16384
oracle hard nproc 16384
    
echo 250 32000 100 128 > /proc/sys/kernel/sem
echo 536870912 > /proc/sys/kernel/shmmax
echo 4096 > /proc/sys/kernel/shmmni
echo 2097152 > /proc/sys/kernel/shmall
echo 65536 > /proc/sys/fs/file-max
echo 1024 65000 > /proc/sys/net/ipv4/ip_local_port_range
    
}}}    




!! 환경 변수 설정
{{{    
su - oracle
vi .bash_profile

# Oracle Environment
export ORACLE_BASE=/usr/oracle
export ORACLE_HOME=$ORACLE_BASE/product/9.2
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/Apache/Apache/bin:$PATH
export ORACLE_OWNER=oracle
export ORACLE_SID=ora9
export ORACLE_TERM=vt100
export LD_ASSUME_KERNEL=2.4.1
export THREADS_FLAG=native
export LD_LIBRARY_PATH=$ORACLE_HOME/product/9.2/lib:$LD_LIBRARY_PATH
export PATH=$ORACLE_HOME/product/9.2/bin:$PATH
export NLS_LANG=AMERICAN_AMERICA.KO16KSC5601;

}}}

!! XWindow 상에서 오라클 설치
{{{

언어설정 (한글깨지는거 영문으로)
linux#]unset LANG

다운로드 : http://www.oracle.com/technology/software/products/oracle9i/htdocs/linuxsoft.html
다운 받은 파일의 압축을 풀어준다.
[oracle@localhost oracle]$ zcat ship_9204_linux_disk1.cpio.gz | cpio -idmv
[oracle@localhost oracle]$ zcat ship_9204_linux_disk2.cpio.gz | cpio -idmv
[oracle@localhost oracle]$ zcat ship_9204_linux_disk3.cpio.gz | cpio -idmv
}}}

!! runinstall수행시 다음과 같은 애러가 났을때 패치

symbol __libc_wait, version GLIBC_2.0 not defined in file libc.so.6 with link time reference

{{{
# 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
}}}

!! 리스너 생성
{{{
$/usr/oracle/product/9.2/bin/netmgr
#디렉토리 서비스 사용 안함 선택
}}}


!! 데이터베이스 생성
{{{    
$/usr/oracle/product/9.2/bin/dbca    
new database 선택
데이터베이스명과 SID=ORCL
정적선택
메모리는 기본을 선택
}}}



!! 오라클 실행
{{{    
[root@miniroko]# su - oracle
[oracle@miniroko oracle]$ lsnrctl start
[oracle@miniroko oracle]$ sqlplus /nolog
     
SQL*Plus: Release 9.2.0.1.0 - Production on ?et Svi 29 13:52:34 2003
 
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
     
SQL> connect / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.
     
Total System Global Area   93393176 bytes
Fixed Size                   450840 bytes
Variable Size              75497472 bytes
Database Buffers           16777216 bytes
Redo Buffers                 667648 bytes
Database mounted.
Database opened.
SQL> exit
}}}
   
    
!! 오라클 종료
{{{
[root@miniroko]# su - oracle
[oracle@miniroko oracle]$ lsnrctl stop
[oracle@miniroko oracle]$ sqlplus /nolog
     
SQL*Plus: Release 9.2.0.1.0 - Production on ?et Svi 29 13:55:32 2003
     
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
     
SQL> connect / as sysdba
Connected.
SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit 
}}}