버전 비교

이전 버전 2

changes.mady.by.user 윤병훈

에 저장

비교대상

새 버전 3

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 iptables off
chkconfig --level 123456 ip6tables off
chkconfig --level 123456 bluetooth off
chkconfig --level 123456 yum-updatesd off 

 

코드 블럭
languagebash
rpm -q binutils-2.*
rpm -q compat-libstdc++-33-*
rpm -q elfutils-libelf-0.*
rpm -q elfutils-libelf-devel-*
rpm -q gcc-4.*
rpm -q gcc-c++-4.*
rpm -q glibc-2.*
rpm -q glibc-common-2.*
rpm -q glibc-devel-2.*
rpm -q glibc-headers-2.*
rpm -q ksh-2*
rpm -q libaio-0.*
rpm -q libaio-devel-0.*
rpm -q libgcc-4.*
rpm -q libstdc++-4.*
rpm -q libstdc++-devel-4.*
rpm -q make-3.*
rpm -q sysstat-7.*
rpm -q unixODBC-2.*
rpm -q unixODBC-devel-2.* 

 

코드 블럭
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
### SCAN
10.0.1.110  rac-scan.localdomain rac-scan 

 

코드 블럭
languagebash
titlevi /etc/fstab
tmpfs  			/dev/shm  		tmpfs   size=1500m  	0 0 

 

코드 블럭
languagebash
mount -o remount /dev/shm
df -h
펼치기
서식 미적용
[root@rac1 ~]# mount -o remount /dev/shm

[root@rac1 ~]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/sda3              26G  2.7G   22G  12% /
/dev/sda1              99M   22M   73M  23% /boot
oracle                233G  123G  111G  53% /media/sf_oracle
shmfs                 1.5G     0  1.5G   0% /dev/shm

 

코드 블럭
languagebash
titlevi /etc/sysctl.conf
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
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 = 1048586

 

코드 블럭
languagebash
/sbin/sysctl -p
펼치기

[root@rac1 ~]# /sbin/sysctl -p
net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 2
net.ipv4.conf.default.accept_source_route = 0
kernel.sysrq = 0
kernel.core_uses_pid = 1
net.ipv4.tcp_syncookies = 1
kernel.msgmnb = 65536
kernel.msgmax = 65536
kernel.shmmax = 4294967295
kernel.shmall = 268435456
fs.aio-max-nr = 1048576
fs.file-max = 6815744
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 = 1048586

 

코드 블럭
languagebash
titlevi /etc/security/limits.conf
oracle  soft   nproc   2047
oracle  hard   nproc   16384
oracle  soft   nofile  1024
oracle  hard   nofile  65536
grid    hard   nproc   16384
grid    hard   nofile  65536 

 

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

 

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

 

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

 

코드 블럭
languagebash
mv /etc/sysconfig/ntpd /etc/sysconfig/ntpd.original
mv /etc/ntp /etc/ntp.original
mv /etc/ntp.conf /etc/ntp.conf.original

 

코드 블럭
languagebash
titlevi /etc/resolv.conf
nameserver 127.0.0.1 

 

코드 블럭
languagebash
chkconfig dnsmasq on
service dnsmasq start
nslookup rac-scan
펼치기
서식 미적용
[root@rac1 ~]# chkconfig dnsmasq on

[root@rac1 ~]# service dnsmasq start
Starting dnsmasq:                                          [  OK  ]


[root@rac1 ~]# nslookup rac-scan
Server:		127.0.0.1
Address:	127.0.0.1#53

Name:	rac-scan
Address: 10.0.1.110

 

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

[root@rac1 ~]# usermod -g oinstall -G dba,oper,asmdba,asmadmin,vboxsf oracle
[root@rac1 ~]# useradd -g oinstall -G dba,asmdba,asmoper,asmadmin,vboxsf grid

[root@rac1 ~]# id oracle
uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba),160(vboxsf),54323(oper),54324(asmdba),54326(asmadmin)

[root@rac1 ~]# id grid
uid=54322(grid) gid=54321(oinstall) groups=54321(oinstall),54322(dba),160(vboxsf),54324(asmdba),54325(asmoper),54326(asmadmin)

[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.

[root@rac1 ~]# passwd grid
Changing password for user grid.
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/11.2.0/grid
mkdir -p /u01/app/oracle/product/11.2.0/db_1
chown -R grid:oinstall /u01
chown -R oracle:oinstall /u01/app/oracle/product
chmod -R 755 /u01
펼치기
서식 미적용
[root@rac1 ~]# mkdir -p /u01/app/11.2.0/grid
[root@rac1 ~]# mkdir -p /u01/app/oracle/product/11.2.0/db_1
[root@rac1 ~]# chown -R grid:oinstall /u01
[root@rac1 ~]# chown -R oracle:oinstall /u01/app/oracle/product
[root@rac1 ~]# chmod -R 755 /u01

 

코드 블럭
languagebash
titlevi ~grid/.bash_profile
export TMP=/tmp
export TMPDIR=$TMP
export EDITOR=vi
export ORACLE_HOSTNAME=rac1  # rac2
export ORACLE_UNQNAME=racdb  # instance_name
export ORACLE_BASE=/u01/app/oracle
export GRID_HOME=/u01/app/11.2.0/grid
export DB_HOME=$ORACLE_BASE/product/11.2.0/db_1
export ORACLE_HOME=$GRID_HOME
export ORACLE_SID=+ASM1      # +ASM2
export ORACLE_TERM=xterm
export BASE_PATH=/usr/sbin:$PATH
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
export NLS_LANG=AMERICAN_KOREA.AL32UTF8
export PS1='[\u@$ORACLE_SID \W]$ '

if [ $USER = "grid" ]; then
    if [ $SHELL = "/bin/ksh" ]; then
        ulimit -p 16384
        ulimit -n 65536
    else
        ulimit -u 16384 -n 65536
    fi
fi 
펼치기
서식 미적용
[root@rac1 ~]# cat ~grid/.bash_profile 
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
	. ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH

export TMP=/tmp
export TMPDIR=$TMP
export EDITOR=vi
export ORACLE_HOSTNAME=rac1  # rac2
export ORACLE_UNQNAME=racdb  # instance_name
export ORACLE_BASE=/u01/app/oracle
export GRID_HOME=/u01/app/11.2.0/grid
export DB_HOME=$ORACLE_BASE/product/11.2.0/db_1
export ORACLE_HOME=$GRID_HOME
export ORACLE_SID=+ASM1      # +ASM2
export ORACLE_TERM=xterm
export BASE_PATH=/usr/sbin:$PATH
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
export NLS_LANG=AMERICAN_KOREA.AL32UTF8
export PS1='[\u@$ORACLE_SID \W]$ '

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

 

코드 블럭
languagebash
titlevi ~oracle/.bash_profile
export PATH
export TMP=/tmp
export TMPDIR=$TMP
export EDITOR=vi
export ORACLE_HOSTNAME=rac1  # rac2
export ORACLE_UNQNAME=racdb  # instance_name
export ORACLE_BASE=/u01/app/oracle
export GRID_HOME=/u01/app/11.2.0/grid
export DB_HOME=$ORACLE_BASE/product/11.2.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:$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
export NLS_LANG=AMERICAN_KOREA.AL32UTF8
export PS1='[\u@$ORACLE_SID \W]$ '

if [ $USER = "oracle" ]; then
    if [ $SHELL = "/bin/ksh" ]; then
        ulimit -p 16384
        ulimit -n 65536
    else
        ulimit -u 16384 -n 65536
    fi
fi
펼치기
서식 미적용
[root@rac1 ~]# cat ~oracle/.bash_profile 
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
	. ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH
export TMP=/tmp
export TMPDIR=$TMP
export EDITOR=vi
export ORACLE_HOSTNAME=rac1  # rac2
export ORACLE_UNQNAME=racdb  # instance_name
export ORACLE_BASE=/u01/app/oracle
export GRID_HOME=/u01/app/11.2.0/grid
export DB_HOME=$ORACLE_BASE/product/11.2.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:$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
export NLS_LANG=AMERICAN_KOREA.AL32UTF8
export PS1='[\u@$ORACLE_SID \W]$ '

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