Redhat5에 설치 (2009.08.20)
- Oracle Database 10g install
##################################################
# 오라클 OS 설정
##################################################
1. rpm -r (package_name)
binutils-2.15.92.0.2-10.EL4
compat-db-4.1.25-9
control-center-2.8.0-12
gcc-3.4.-9.EL4
gcc-c++-3.4.3-9.EL4
glibc-2.3.4-2
glibc-common-2.3.4-2
gnome-libs-1.4.1.2.90-44.1 ----->
libstdc++-3.4.3-9.EL4
libstdc++-devel-3.4.3-9.EL4
make-3.80-5
pdksh-5.2.14-30 ----->
sysstat-5.0.5-1
xscreensaver-4.18-5.rhel4.2 ----->
libaio
-64bit일 경우 추가
compat-libstdc++-33
glibc-kernheaders
glibc-headers
libaio
libaio (32bit)
glibc-devel
glibc-devel (32bit)
1-1. SUSE Linux
gcc-3.3.3-43.34
gcc-64bit-9-200505240008
gcc-c++-3.3.3-43.34
glibc-2.3.3-98.47
glibc-64bit-9-200506062240
libgcc-3.3.3-43.34
libgcc (64-bit) 9-200505240008
libstdc++-3.3.3-43.34
libstdc++-devel-3.3.3-43.34
libaio-0.3.102-1.2
libaio-64bit-9-200502241152
libaio-devel-0.3.102-1.2
libaio-devel-0.3.102-1.2 (64-bit)
Gmake-3.80-184.1
binutils-2.15.90.0.1.1-32.10
binutils-64bit-9-200505240008
2. cat /proc/version
3. uname -r
##################################################
# 오라클 그룹 및 사용자 계정 생성
##################################################
mkdir /oradata
mkdir /oracle
mkdir /oracle/app
mkdir /oracle/app/oracle
mkdir /oracle/app/oracle/product
/usr/sbin/groupadd -g 2000 dba
/usr/sbin/useradd -u 200 -g dba -d /oracle/app/oracle/product/10g -s /bin/bash oracle
id oracle
passwd oracle
chown -R oracle:dba /oracle
chown -R oracle:dba /oradata
##################################################
# /etc/sysctl.conf 커널매개변수 설정
##################################################
kernel.shmall = 2097152
kernel.shmmax = 2147483648
#kernel.shmmax = 4589934590
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 327679
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
-설정 확인
/sbin/sysctl -a | grep shm
/sbin/sysctl -a | grep sem
/sbin/sysctl -a | grep file-max
/sbin/sysctl -a | grep ip_local_port_range
- 설정 반영
/sbin/sysctl -p
- SUSE 시에는 다음과 같이 리붓
/sbin/chkconfig boot.sysctl on
#################################################
# oracle 사용자 계정의 Shell Limit 설정
#################################################
- /etc/security/limits.conf
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
- /etc/pam.d/login
session required /lib/security/pam_limits.so
#################################################
# oracle 계정을 위한 환경변수
#################################################
-/etc/profile(SUSE는 /etc/profile.local)
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi
- .bash_profile
###################################################
# Oracle 10g ENV
###################################################
export ORACLE_BASE=/oracle/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0
export ORACLE_TERM=vi100
export TMPDIR=$ORACLE_BASE/tmp
export TEMP=$ORACLE_BASE/tmp
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export NLS_LANG=AMERICAN_AMERICA.KO16KSC5601
export LANG=C
export TNS_ADMIN=$ORACLE_HOME/network/admin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/X11R6/lib
export PATH=$ORCACLE_HOME/oracm/bin:$ORACLE_HOME/bin:/bin:/usr/bin:/sbin:/usr/local/bin:/usr/X11R6/bin:$PATH:.
export DISPLAY=192.168.28.1:0.0
export inventory_loc=/oracle/app/oracle/orainventory
export ORACLE_SID=ORCL
export ORACLE_OWNER=oracle
PS1='[${ORACLE_SID}]'`hostname`':$PWD> '
alias dba='sqlplus "/as sysdba"'
alias t='tail -f /oracle/app/oracle/admin/${ORACLE_SID}/bdump/*.log'
umask 022
set -o vi
stty erase ^H
------------------------------------------------------
.bash_profile 반영
$> . ./.bash_profile
ProC Program 설치
클라이언트 프로그래머 옵션 사용
ProC Program 확인
$ORACLE_HOME/bin/proc
$ORACLE_HOME/precomp 에 라이브러시 설치 확인
###################################################
# Oracle Installation
###################################################
.runInstaller -ignoreSysPrereqs 실행후 GUI 화면으로 설치 시작
X11 문제로 runInstaller가 안되면
1. root에서 xhost +를 실행하고 su - oracle로 들어가 runInstaller를 실행한다.
2. 그래도 문제가 되면 .bash_profile에서 DISPLAY부분을 주석처리하고 한다.
- 설치후 아래 두 스크립터 실행
ⓐ sh ./oracle/app/oracle/oraInventory/orainstRoot.sh
ⓑ sh ./oracle/app/oracle/product/102/root.sh
※ 설치후 SID와 관련된 내용은 /etc/oratab에 추가됨
$ORACLE_HOME/bin/localconfig add (root로 실행)
dbca 실행
sqlplus / as sysdba
SQL> startup
startup이 안되면 $ORACLE_SID를 확인하고 맞는것으로 변경한다.
===========================================
* 실행시 자동으로 Oracle DB실행되도록
/etc/rc.d/rc.local에서 /oracle/start.sh를 부르도록 함
/oracle/start.sh
#!/bin/ksh
su - oracle << EOF
sqlplus "/as sysdba" << EOF
startup
exit
EOF
su - oracle << EOF
lsnrctl start
exit
EOF
/oracle/stop.sh
#!/bin/ksh
su - oracle << EOF
lsnrctl stop
exit
EOF
su - oracle << EOF
sqlplus "/as sysdba" << EOF
shutdown immediate
exit
EOF
chmod 755 start.sh
chmod 755 stop.sh
===========================================
cubeone 설치시 오라클 연결이 안되면 다음을 한다.
$ORACLE_HOME/bin/oracle 의 permission 이 6755 인지 확인
아니면 chmod 6755 oracle