RHEL5_11g_Silent

< RHEL5 11g Silent 설치 >

 

 

1. 계정생성

oracle 계정의 주 그룹으로 oinstall을, 보조그룹으로 dba, oper를 지정함

 

2. RPM 확인

 

[root@localhost ~]# rpm -qa | grep compat-libstdc++-33-3.2.3

compat-libstdc++-33-3.2.3-61

[root@localhost ~]# rpm -qa | grep binutils-2.17.50.0.6

binutils-2.17.50.0.6-9.el5

[root@localhost ~]# rpm -qa | grep elfutils-libelf

elfutils-libelf-0.137-3.el5

elfutils-libelf-devel-static-0.137-3.el5

elfutils-libelf-devel-0.137-3.el5

[root@localhost ~]# rpm -qa | grep gcc-4.1.2

libgcc-4.1.2-44.el5

gcc-4.1.2-44.el5

[root@localhost ~]# rpm -qa | grep gcc-c++

gcc-c++-4.1.2-44.el5

[root@localhost ~]# rpm -qa | grep glibc-2.5

glibc-2.5-34

[root@localhost ~]# rpm -qa | grep glibc-common

glibc-common-2.5-34

[root@localhost ~]# rpm -qa | grep glibc-headers

compat-glibc-headers-2.3.4-2.26

glibc-headers-2.5-34

[root@localhost ~]# rpm -qa | grep kernel-headers

kernel-headers-2.6.18-128.el5

 

[root@localhost ~]# rpm -qa | grep ksh

ksh-20080202-2.el5

[root@localhost ~]# rpm -qa | grep libaio

libaio-0.3.106-3.2

[root@localhost ~]# rpm -qa | grep libgcc-4.1.2

libgcc-4.1.2-44.el5

[root@localhost ~]# rpm -qa | grep libstdc++

compat-libstdc++-296-2.96-138

libstdc++-devel-4.1.2-44.el5

compat-libstdc++-33-3.2.3-61

libstdc++-4.1.2-44.el5

[root@localhost Server]# rpm -qa | grep numactl-devel <- 설치 안되어서 설치합니다

 

 

 

[root@localhost Server]# rpm -qa | grep sysstat-7.0.2 <- 설치 안되어서 설치합니다.

 

 

[root@localhost Server]# rpm -qa | grep unixODBC-32bit-2.2.11 <- 설치해야 합니다.

[root@localhost Server]# rpm -ivh unixODBC-*

 

 

 

3. /etc/profile 수정 변경 전 값 : ulimit –s –c 0 > /dev/null 2 > &1

변경 후 값: ulimit –s –c unlimited > /dev/null 2 > &1

 

 

 

# vi /etc/sysctl.conf

다음과 같이 추가

 

kernel.core_uses_pid = 1

fs.suid_dumpable = 1

 

 

 

# vi /etc/security/limits.conf

 

oracle soft nproc 2047

oracle hard nproc 16384

oracle soft nofile 1024

oracle hard nofile 65536

oracle soft stack 10240

 

# /etc/pam.d/login

session required pam_limits.so

oraInst.loc 파일 생성 ( 오라클 설치시 로그를 볼수 있다 )

# vi /etc/oraInst.loc

 

inventory_loc=/app/oracle/oraInventory

nst_group=dba

 

# chown -R oracle:dba /etc/oraInst.loc

 

# vi /etc/sysctl.conf

 

fs.aio-max-nr = 1048576

fs.file-max = 6815744

kernel.shmall = 2097152

kernel.shmmax = 4294967295

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

net.ipv4.ip_local_port_range = 9000 65500

net.core.rmem_default = 262144

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 1048576

 

 

 

# /etc/security/limits.conf 설정 값 적용

# /sbin/sysctl -p ( 입력하면 된다 )

 

Oracle 압축파일 풀기~

# pwd

/app

 

# unzip p10098816_112020_LINUX_1of7.zip \

> && unzip p10098816_112020_LINUX_2of7.zip \

> && unzip p10098816_112020_LINUX_3of7.zip \

> && unzip p10098816_112020_LINUX_4of7.zip \

> && unzip p10098816_112020_LINUX_5of7.zip \

> && unzip p10098816_112020_LINUX_6of7.zip \

> && unzip p10098816_112020_LINUX_7of7.zip

# ls -l

 

# chown -R oracle:dba /home/oracle/

 

silent 설치를 위한 Responsefile 수정

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

 

 

 

 

 

silent 설치를 위한 Responsefile 수정

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

 

 

Oracle 11g 설치를 위한 환경 설정

 

# vi /home/oracle/.bash_profile

export ORACLE_BASE=/home/oracle

export ORACLE_HOME=$ORACLE_BASE/product/11g

export ORACLE_SID=testdb

export LANG=C

export ORACLE_TERM=xterm

export NLS_LANG=AMERICAN_AMERICA.KO16MSWIN949

export ORA_NLS10=$ORACLE_HOME/nls/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

 

 

Responsefile 수정

$ vi db_install.rsp

 

29 oracle.install.option=INSTALL_DB_SWONLY

42 UNIX_GROUP_NAME=oinstall

49 INVENTORY_LOCATION=/home/oracle/oraInventory

86 SELECTED_LANGUAGES=en,ko

91 ORACLE_HOME=/home/oracle/product/11g

96 ORACLE_BASE=/home/oracle

107 oracle.install.db.InstallEdition=EE

116 oracle.install.db.EEOptionsSelection=true

135 oracle.install.db.optionalComponents=oracle.rdbms.partitioning:11.2.0.2.0

153 oracle.install.db.DBA_GROUP=dba

159 oracle.install.db.OPER_GROUP=oper

SECURITY_UPDATES_VIA_MYORACLESUPPORT=false

400 DECLINE_SECURITY_UPDATES=true

445 oracle.installer.autoupdates.option=SKIP_UPDATES

 

 

responsefile을 통한 silent 설치$./runInstaller -silent -force -waitforcompletion -responseFile /app/oracle/database/response/db_install.rsp

 

 

- root 계정으로 스크립트 실행

 

 

- oracle 11g 엔진 설치 확인

 

 

DB 생성

1. responsefile 설정

$ pwd

/app/oracle/database/response

$ vi dbca.rsp

GDBNAME = "testdb"

SID = "testdb"

SYSPASSWORD = "password"

SYSTEMPASSWORD = "password"

CHARACTERSET = "US7ASCII"

NATIONALCHARACTERSET= "UTF8"

2. DB 생성

$ pwd

/app/oracle/product/11g/bin$./dbca -silent -templateName /app/oracle/product/11g/assistants/dbca/templates/New_Database.dbt -responseFile /app/oracle/database/response/dbca.rsp

 

 

 

 

- 정상적으로 설치 완료