버전 비교

이전 버전 6

changes.mady.by.user 윤병훈

에 저장

비교대상

새 버전 7

changes.mady.by.user 윤병훈

에 저장

키

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

Image Added

 

Image AddedImage Removed

 

Image RemovedImage Added

 

Image RemovedImage Added

 

Image RemovedImage Added

 

Image RemovedImage RemovedImage Added

 

Image RemovedImage Added

 

코드 블럭
languagebash
linenumberstrue
cat /etc/oracle-release
cat /etc/redhat-release
lsb_release -id
uname -r
펼치기
서식 미적용
[root@rac1 ~]# cat /etc/oracle-release
Oracle Linux Server release 6.5


[root@rac1 ~]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 6.5 (Santiago)


[root@rac1 ~]# lsb_release -id
Distributor ID:	OracleServer
Description:	Oracle Linux Server release 6.5


[root@rac1 ~]# uname -r
3.8.13-16.2.1.el6uek.x86_64
코드 블럭
languagebash
linenumberstrue
rpm -q binutils-*
rpm -q compat-libcap1-*
rpm -q compat-libstdc++-33-*
rpm -q gcc-*
rpm -q gcc-c++-*
rpm -q glibc-*
rpm -q glibc-devel-*
rpm -q ksh
rpm -q libgcc-*
rpm -q libstdc++-*
rpm -q libstdc++-devel-*
rpm -q libaio-*
rpm -q libaio-devel-*
rpm -q libXext-*
rpm -q libXtst-*
rpm -q libX11-*
rpm -q libXau-*
rpm -q libxcb-*
rpm -q libXi-*
rpm -q make-*
rpm -q sysstat-*
펼치기
서식 미적용
[root@rac1 ~]# rpm -q binutils-*
binutils-2.20.51.0.2-5.36.el6.x86_64


[root@rac1 ~]# rpm -q compat-libcap1-*
compat-libcap1-1.10-1.x86_64


[root@rac1 ~]# rpm -q compat-libstdc++-33-*
compat-libstdc++-33-3.2.3-69.el6.x86_64


[root@rac1 ~]# rpm -q gcc-*
gcc-4.4.7-4.el6.x86_64


[root@rac1 ~]# rpm -q gcc-c++-*
gcc-c++-4.4.7-4.el6.x86_64


[root@rac1 ~]# rpm -q glibc-*
glibc-2.12-1.132.el6.x86_64
glibc-2.12-1.132.el6.i686


[root@rac1 ~]# rpm -q glibc-devel-*
glibc-devel-2.12-1.132.el6.x86_64


[root@rac1 ~]# rpm -q ksh
ksh-20120801-10.el6.x86_64


[root@rac1 ~]# rpm -q libgcc-*
libgcc-4.4.7-4.el6.x86_64
libgcc-4.4.7-4.el6.i686


[root@rac1 ~]# rpm -q libstdc++-*
libstdc++-4.4.7-4.el6.x86_64


[root@rac1 ~]# rpm -q libstdc++-devel-*
libstdc++-devel-4.4.7-4.el6.x86_64


[root@rac1 ~]# rpm -q libaio-*
libaio-0.3.107-10.el6.x86_64


[root@rac1 ~]# rpm -q libaio-devel-*
libaio-devel-0.3.107-10.el6.x86_64


[root@rac1 ~]# rpm -q libXext-*
libXext-1.3.1-2.el6.x86_64


[root@rac1 ~]# rpm -q libXtst-*
libXtst-1.2.1-2.el6.x86_64


[root@rac1 ~]# rpm -q libX11-*
libX11-1.5.0-4.el6.x86_64


[root@rac1 ~]# rpm -q libXau-*
libXau-1.0.6-4.el6.x86_64


[root@rac1 ~]# rpm -q libxcb-*
libxcb-1.8.1-1.el6.x86_64


[root@rac1 ~]# rpm -q libXi-*
libXi-1.6.1-3.el6.x86_64


[root@rac1 ~]# rpm -q make-*
make-3.81-20.el6.x86_64


[root@rac1 ~]# rpm -q sysstat-*
sysstat-9.0.4-22.el6.x86_64
코드 블럭
languagebash
titlevi /etc/hosts
linenumberstrue
### Public
10.0.1.101 rac1.localdomain rac1
10.0.1.102 rac2.localdomain rac2
### Private
10.0.25.101 rac1-priv.localdomain rac1-priv
10.0.25.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
### DNS
#10.0.1.120 dns.localdomain dns
### SCAN
10.0.1.121120 rac-scan.localdomain rac-scan
10.0.1.122 rac-scan.localdomain rac-scan
10.0.1.123 rac-scan.localdomain rac-scan

http://public-yum.oracle.com/repo/OracleLinux/OL6/latest/x86_64/

코드 블럭
rpm -ivh oracle-rdbms-server-12cR1-preinstall-*
펼치기
서식 미적용
[root@rac1 sf_oracle]# rpm -ivh oracle-rdbms-server-12cR1-preinstall-1.0-11.el6.x86_64.rpm 
경고: oracle-rdbms-server-12cR1-preinstall-1.0-11.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
준비 중...               ########################################### [100%]
   1:oracle-rdbms-server-12c########################################### [100%]
코드 블럭
languagebash
titlevi /etc/sysctl.conf
linenumberstrue
kernel.sem    = 250   32000   100   128
kernel.shmmni = 4096
fs.file-max   = 6815744
net.ipv4.ip_local_port_range = 9000   65535
net.core.rmem_default = 262144
net.core.rmem_max     = 4194304
net.core.wmem_default = 262144
net.core.wmem_max     = 1048576
fs.aio-max-nr         = 1048576 
코드 블럭
languagebash
titlevi /etc/security/limits.conf
linenumberstrue
oracle  hard  nofile   65536
oracle  hard  nproc    16384
oracle  soft  nproc    2047
oracle  hard  memlock  4572857
코드 블럭
languagebash
linenumberstrue
service dnsmasq start
chkconfig dnsmasq on
코드 블럭
languagebash
linenumberstrue
chkconfig --level 123456 xinetd off
chkconfig --level 123456 cups off
chkconfig --level 123456 smartd off
chkconfig --level 123456 iptables off
chkconfig --level 123456 ip6tables off
chkconfig --level 123456 bluetooth off
코드 블럭
languagebash
linenumberstrue
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/sysconfig/selinux
SELINUX=permissive
코드 블럭
languagebash
titlevi /etc/security/limits.d/90-nproc.conf
linenumberstrue
# Change this
*          soft    nproc    1024

# To this
* 		   - 	   nproc    16384
코드 블럭
languagebash
linenumberstrue
# groupadd oinstall
# groupadd dba
groupadd oper
groupadd backupdba
groupadd dgdba
groupadd kmdba
groupadd asmdba
groupadd asmoper
groupadd asmadmin
 
usermod -g oinstall -G dba,oper,backupdba,dgdba,kmdba,asmdba,asmoper,asmadmin,vboxsf oracle
passwd oracle
펼치기
서식 미적용
[root@rac1 ~]# groupadd oper
[root@rac1 ~]# groupadd backupdba
[root@rac1 ~]# groupadd dgdba
[root@rac1 ~]# groupadd kmdba
[root@rac1 ~]# groupadd asmdba
[root@rac1 ~]# groupadd asmoper
[root@rac1 ~]# groupadd asmadmin

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

[root@rac1 ~]# passwd oracle
oracle 사용자의 비밀 번호 변경 중
새  암호:
잘못된 암호: 사전에 있는 단어를 기반으로 합니다  
잘못된 암호: 너무 간단함
새  암호 재입력:
passwd: 모든 인증 토큰이 성공적으로 업데이트 되었습니다.
코드 블럭
languagebash
linenumberstrue
mkdir /u01
chown -R oracle:oinstall /u01
코드 블럭
languagebash
titlevi .bash_profile
linenumberstrue
export TMP=/tmp
export TMPDIR=$TMP
export EDITOR=vi
export ORACLE_HOSTNAME=rac1.localdomain     # rac2.localdomain => 2번 노드
export ORACLE_UNQNAME=racdb
export ORACLE_BASE=/u01/app/oracle
export GRID_HOME=/u01/app/12.1.0/grid
export DB_HOME=$ORACLE_BASE/product/12.1.0/db_1
export ORACLE_HOME=$DB_HOME
export ORACLE_SID=racdb1     # racdb2 => 2번 노드
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
코드 블럭
languagebash
titlevi .db_env
linenumberstrue
export ORACLE_SID=racdb1     # racdb2 => 2번 노드
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 .grid_env
linenumberstrue
export ORACLE_SID=+ASM1     # +ASM2 => 2번 노드
export ORACLE_HOME=$GRID_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 grid_env='. ~/.grid_env'
alias db_env='. ~/.db_env'
alias ss='sqlplus / as sysdba'
alias ltr='ls -ltr'