버전 비교

이전 버전 1

changes.mady.by.user 윤병훈

에 저장

비교대상

새 버전 현재

changes.mady.by.user 윤병훈

에 저장

키

  • 이 줄이 추가되었습니다.
  • 이 줄이 삭제되었습니다.
  • 서식이 변경되었습니다.

 

 

 

 

 

 

 

코드 블럭
languagebash
chkconfig --level 123456 xinetd off
chkconfig --level 123456 sendmail off
chkconfig --level 123456 cups off
chkconfig --level 123456 cups-config-daemon off
chkconfig --level 123456 smartd off
chkconfig --level 123456 isdn off
chkconfig --level 123456 pcmcia off
chkconfig --level 123456 iptables off
펼치기
서식 미적용
[root@rac1 ~]# chkconfig --level 123456 xinetd off
[root@rac1 ~]# chkconfig --level 123456 sendmail off
[root@rac1 ~]# chkconfig --level 123456 cups off
[root@rac1 ~]# chkconfig --level 123456 cups-config-daemon off
[root@rac1 ~]# chkconfig --level 123456 smartd off
[root@rac1 ~]# chkconfig --level 123456 isdn off
[root@rac1 ~]# chkconfig --level 123456 pcmcia off
[root@rac1 ~]# chkconfig --level 123456 iptables off

 

코드 블럭
languagebash
rpm -q binutils-*
rpm -q compat-db-4*
rpm -q control-center-2*
rpm -q gcc-3*
rpm -q gcc-c++-3*
rpm -q glibc-2*
rpm -q glibc-common-2*
rpm -q gnome-libs-1*
rpm -q libstdc++-3*
rpm -q libstdc++-devel-3*
rpm -q make-3* 
펼치기
서식 미적용
[root@rac1 ~]# rpm -q binutils-*
binutils-2.15.92.0.2-25
[root@rac1 ~]# rpm -q compat-db-4*
compat-db-4.1.25-9
[root@rac1 ~]# rpm -q control-center-2*
control-center-2.8.0-12.rhel4.5
[root@rac1 ~]# rpm -q gcc-3*
gcc-3.4.6-11.0.1
[root@rac1 ~]# rpm -q gcc-c++-3*
gcc-c++-3.4.6-11.0.1
[root@rac1 ~]# rpm -q glibc-2*
glibc-2.3.4-2.43
[root@rac1 ~]# rpm -q glibc-common-2*
glibc-common-2.3.4-2.43
[root@rac1 ~]# rpm -q gnome-libs-1*
gnome-libs-1.4.1.2.90-44.2
[root@rac1 ~]# rpm -q libstdc++-3*
libstdc++-3.4.6-11.0.1
[root@rac1 ~]# rpm -q libstdc++-devel-3*
libstdc++-devel-3.4.6-11.0.1
[root@rac1 ~]# rpm -q make-3*
make-3.80-7.EL4

 

코드 블럭
languagebash
titlevi /etc/hosts
### Public
10.0.1.101  rac1.localdomain rac1
10.0.1.102  rac2.localdomain rac2
### Private
10.0.5.101  rac1-priv.localdomain rac1-priv
10.0.5.102  rac2-priv.localdomain rac2-priv
### Virtual
10.0.1.111  rac1-vip.localdomain rac1-vip
10.0.1.112  rac2-vip.localdomain rac2-vip 
펼치기
서식 미적용
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1   localhost.localdomain localhost

### Public
10.0.1.101  rac1.localdomain rac1
10.0.1.102  rac2.localdomain rac2
### Private
10.0.5.101  rac1-priv.localdomain rac1-priv
10.0.5.102  rac2-priv.localdomain rac2-priv
### Virtual
10.0.1.111  rac1-vip.localdomain rac1-vip
10.0.1.112  rac2-vip.localdomain rac2-vip

 

코드 블럭
languagebash
titlevi /etc/sysctl.conf
# Controls whether core dumps will append the PID to the core filename.
# Useful for debugging multi-threaded applications.
kernel.core_uses_pid = 1
fs.file-max = 327679
kernel.msgmni = 2878
kernel.msgmax = 8192
kernel.msgmnb = 65536
kernel.sem = 250 32000 100 142
kernel.shmmni = 4096
kernel.shmall = 1073741824
kernel.shmmax = 4294967295
net.core.rmem_default = 262144
# For 11g recommended value for net.core.rmem_max is 4194304
# net.core.rmem_max = 4194304
# For 10g uncomment the following line, comment other entries for this parameter and re-run sysctl -p
# net.core.rmem_max=2097152
net.core.wmem_default = 262144
net.core.wmem_max = 262144
fs.aio-max-nr = 3145728
net.ipv4.ip_local_port_range = 1024 65000
vm.lower_zone_protection = 100
펼치기
서식 미적용
[root@rac1 ~]# sysctl -p

net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
net.ipv4.conf.default.accept_source_route = 0
kernel.sysrq = 1
kernel.core_uses_pid = 1
fs.file-max = 327679
kernel.msgmni = 2878
kernel.msgmax = 8192
kernel.msgmnb = 65536
kernel.sem = 250 32000 100 142
kernel.shmmni = 4096
kernel.shmall = 1073741824
kernel.shmmax = 4294967295
net.core.rmem_default = 262144
net.core.rmem_max = 20971524194304
net.core.wmem_default = 262144
net.core.wmem_max = 262144
fs.aio-max-nr = 3145728
net.ipv4.ip_local_port_range = 1024 65000
vm.lower_zone_protection = 100

 

코드 블럭
languagebash
titlevi /etc/security/limits.conf
oracle   soft   nofile    131072
oracle   hard   nofile    131072
oracle   soft   nproc    131072
oracle   hard   nproc    131072
oracle   soft   core    unlimited
oracle   hard   core    unlimited
oracle   soft   memlock    3500000
oracle   hard   memlock    3500000

 

코드 블럭
languagebash
titlevi /etc/pam.d/login
session    required     pam_limits.so

 

코드 블럭
languagebash
titlevi /etc/profile
if [ \$USER = "oracle" ]; then
        if [ \$SHELL = "/bin/ksh" ]; then
        ulimit -p 16384
        ulimit -n 65536
    else
        ulimit -u 16384 -n 65536
    fi
umask 022
fi 

 

코드 블럭
languagebash
titlevi /etc/modprobe.conf
options hangcheck-timer hangcheck_tick=30 hangcheck_margin=180

 

코드 블럭
languagebash
titlevi /etc/rc.local
/sbin/modprobe hangcheck-timer

 

코드 블럭
languagebash
# groupadd oinstall
# groupadd dba
groupadd oper
# useradd -g oinstall -G dba,oper,vboxsf oracle
usermod -g oinstall -G dba,oper,vboxsf oracle
passwd oracle
펼치기
서식 미적용
[root@rac1 ~]# groupadd oper

[root@rac1 ~]# usermod -g oinstall -G dba,oper,vboxsf oracle

[root@rac1 ~]# passwd oracle
Changing password for user oracle.
New UNIX password:
BAD PASSWORD: it is based on a dictionary word
Retype new UNIX password:
passwd: all authentication tokens updated successfully.

 

코드 블럭
languagebash
mkdir -p /u01/app/oracle
chown -R oracle:oinstall /u01
펼치기
서식 미적용
[root@rac1 ~]# mkdir -p /u01/app/oracle
[root@rac1 ~]# chown -R oracle:oinstall /u01

 

코드 블럭
languagebash
titlevi .bash_profile
PATH=$PATH:$HOME/bin:/u01/app/11.1.0/crs/bin

 

코드 블럭
languagebash
titlevi .bash_profile
export TMP=/tmp
export TMPDIR=$TMP
export EDITOR=vi
export ORACLE_HOSTNAME=rac1  # rac2.localdomain
export ORACLE_UNQNAME=racdb
export ORACLE_BASE=/u01/app/oracle
export CRS_HOME=/u01/app/11.1.0/crs
export DB_HOME=$ORACLE_BASE/product/11.1.0/db_1
export ORACLE_HOME=$DB_HOME
export ORACLE_SID=racdb1   # racdb2
export ORACLE_TERM=xterm
export BASE_PATH=/usr/sbin:$PATH
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$CRS_HOME/bin:$BASE_PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
export NLS_LANG=AMERICAN_KOREA.AL32UTF8

if [ $USER = "oracle" ]; then
    if [ $SHELL = "/bin/ksh" ]; then
        ulimit -p 16384
        ulimit -n 65536
    else
        ulimit -u 16384 -n 65536
    fi
fi

 

코드 블럭
languagebash
titlevi ~/.crs_env
linenumberstrue
export ORACLE_SID=+ASM1   # +ASM2
export ORACLE_HOME=$CRS_HOME
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$CRS_HOME/bin:$BASE_PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

 

코드 블럭
languagebash
titlevi ~/.db_env
linenumberstrue
export ORACLE_SID=racdb1   # racdb2
export ORACLE_HOME=$DB_HOME
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$GRID_HOME/bin:$BASE_PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

 

코드 블럭
languagebash
titlevi ~/.bashrc
linenumberstrue
alias crs_env='. ~/.crs_env'
alias db_env='. ~/.db_env'
alias ss='sqlplus / as sysdba'
alias ltr='ls -ltr'