2011.12.26 RHEL5 에 oracle10g(silent)

RHEL5에 oracle 10g silent설치하기

Pre-Installation Task

1.   유저 생성

# groupadd -g 5000 dba

# useradd -g 5000 oracle

# passwd oracle

 

2.  파일복사

# cp -rv patch patchset 10201_database_linux32.zip /home/oracle

(파일복사는 Winscp나 VMware Tool의 Shared Directory기능을 이용하세요.)

복사 후

# cd /home/oracle

# unzip 10201_database_linux32.zip

 

3.   /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
net.core.rmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_default = 262144
net.core.wmem_max = 262144

이후 변경사항을 적용해주기 위해
# sysctl -p 입력
 

4.   /etc/security/limits.conf 에 내용추가

oracle10g soft nproc 2047

oracle10g hard nproc 16384

oracle10g soft nofile 1024

oracle10g hard nofile 65536

 

5.   /etc/pam.d/login 에 내용추가

session    required     pam_limits.so

 

6.   /home/oracle/database/response/enterprise.rsp 수정

UNIX_GROUP_NAME="dba"

ORACLE_HOME="/home/oracle/product/10g"

ORACLE_HOME_NAME="OraHome"

n_configurationOption=3

COMPONENT_LANGUAGES={"en,ko"}

 

7.   소유권 설정

# chown -R oracle.dba /home/oracle

 

 

8.   /home/oracle/.bash_profile 에 내용추가

export EDITOR=vi

export ORACLE_BASE=/home/oracle

export ORACLE_HOME=$ORACLE_BASE/product/10g

export ORACLE_SID=testdb

export ORACLE_TERM=xterm

export NLS_LANG=AMERICAN_AMERICA.KO16MSWIN949

export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib

export PATH=$PATH:$ORACLE_HOME/bin

export CLASSPATH=$ORACLE_HOME/jre:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

export NLS_DATE_FORMAT='rrrr-mm-dd:hh24:mi:ss'

================================================================

 

Installation Task

1.   설치실행(oracle유저로 실행하세요)

./runInstaller -silent -force -waitforcompletion \

-responseFile /home/oracle/database/response/enterprise.rsp

 

2.   root로 시스템설정을 위한 파일실행

# /home/oracle/product/10g/root.sh

 

# /home/oracle/oraInventory/orainstRoot.sh

 

 

================================================================

Post-Installation Task

1.   패치설치(버전업)

A.    파일준비

$ cd /home/oracle/patchset

$ unzip p8202632_10205_LINUX.zip

 

B.    patchset.rsp 파일 수정

$ cd /home/oracle/patchset/Disk1/response

$ vi patchset.rsp

UNIX_GROUP_NAME="dba"

FROM_LOCATION="../stage/products.xml"

ORACLE_HOME="/home/oracle/product/10g"

ORACLE_HOME_NAME="OraHome"

COMPONENT_LANGUAGES={"en,ko"}

DECLINE_SECURITY_UPDATES=TRUE

C.    패치 실행

$ ./runInstaller -silent \

-responseFile /home/oracle/patchset/Disk1/response/patchset.rsp \

-force -waitforcompletion

 

D.   실행 중 에러가 난다면.

에러 1.  X-windows 사용 허가 $ export DISPLAY=:0.0 $ xhost + access control disabled, clients can connect from any host            이후 다시 실행

에러 2. 해당 rpm 설치 (RHEL5 dvd에서 찾거나 아래 링크에서 다운 후 rpm 설치하세요(root로) 다운경로: ftp://ftp.pbone.net/mirror/www.startcom.org/ML-5.0.6/updates/i386/libXp-1.0.0-8.i386.rpm $ su - # rpm -Uvh libXp-1.0.0-8.i386.rpm 이후 다시 실행

 wget ftp://ftp.pbone.net/mirror/www.startcom.org/ML-5.0.6/updates/i386/libXp-1.0.0-8.i386.rpm

 

 

E.    Root로 파일 실행

# /home/oracle/product/10g/root.sh  (Overwrite는 모두 y)

2.   DB 생성

A.    dbca.rsp 수정

$ vi /home/oracle/database/response/dbca.rsp

GDBNAME = "testdb"

SID = "testdb"

NATIONALCHARACTERSET= "UTF8" (주석풀기)

B.    DB생성하기

$ dbca -silent -templateName /home/oracle/product/10g/assistants/dbca/templates/General_Purpose.dbc \

-responseFile /home/oracle/database/response/dbca.rsp

 

완료 : 패치 및 DB생성확인 완료