NETTEMWiki: Oracle9i_Install

More...

참고 URL
ORACLE 9i설치(Redhat 9.0에서 테스트)
오라클 Group과 유저 생성
필수 패키지 설치
시스템 환경 변수 수정
환경 변수 설정
XWindow 상에서 오라클 설치
runinstall수행시 다음과 같은 애러가 났을때 패치
리스너 생성
데이터베이스 생성
오라클 실행
오라클 종료

참고 URL#

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