실습을 위해 VirtualBox에서 구축된 환경에서는 편의를 위해 VBOXADDITIONS를 설치해야 합니다.
root 유저에서 진행을 해야 하므로 기타... 버튼을 클릭합니다.
사용자 이름에 "root"를 입력하고 <로그인>을 클릭합니다.
암호에 root 사용자의 암호를 입력하고 <로그인>을 클릭합니다.
경고 메시지가 나오면 <닫기> 버튼을 클릭합니다.
cat /etc/oracle-release cat /etc/redhat-release lsb_release -id uname -r
[root@rac1 ~]# cat /etc/oracle-release Oracle Linux Server release 6.8 [root@rac1 ~]# cat /etc/redhat-release Red Hat Enterprise Linux Server release 6.8 (Santiago) [root@rac1 ~]# lsb_release -id Distributor ID: OracleServer Description: Oracle Linux Server release 6.8 [root@rac1 ~]# uname -r 4.1.12-37.4.1.el6uek.x86_64
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.44.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-17.el6.x86_64 [root@rac1 ~]# rpm -q gcc-c++-* gcc-c++-4.4.7-17.el6.x86_64 [root@rac1 ~]# rpm -q glibc-* glibc-2.12-1.192.el6.x86_64 glibc-2.12-1.192.el6.i686 [root@rac1 ~]# rpm -q glibc-devel-* glibc-devel-2.12-1.192.el6.x86_64 [root@rac1 ~]# rpm -q ksh ksh-20120801-33.el6.x86_64 [root@rac1 ~]# rpm -q libgcc-* libgcc-4.4.7-17.el6.x86_64 libgcc-4.4.7-17.el6.i686 [root@rac1 ~]# rpm -q libstdc++-* libstdc++-4.4.7-17.el6.x86_64 [root@rac1 ~]# rpm -q libstdc++-devel-* libstdc++-devel-4.4.7-17.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.3-1.el6.x86_64 [root@rac1 ~]# rpm -q libXtst-* libXtst-1.2.2-2.1.el6.x86_64 [root@rac1 ~]# rpm -q libX11-* libX11-1.6.3-2.el6.x86_64 [root@rac1 ~]# rpm -q libXau-* libXau-1.0.6-4.el6.x86_64 [root@rac1 ~]# rpm -q libxcb-* libxcb-1.11-2.el6.x86_64 [root@rac1 ~]# rpm -q libXi-* libXi-1.7.4-1.el6.x86_64 [root@rac1 ~]# rpm -q make-* make-3.81-23.el6.x86_64 [root@rac1 ~]# rpm -q sysstat-* sysstat-9.0.4-31.el6.x86_64
vi /etc/hosts
### Public 10.0.1.101 ora12cr1
vi /etc/fstab
tmpfs /dev/shm tmpfs size=4g 0
MEMORY_TARGET 파라미터를 사용하기 위해 설정
vi /etc/sysctl.conf
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
vi /etc/security/limits.conf
oracle hard nofile 65536 oracle hard nproc 16384 oracle soft nproc 2047 oracle hard memlock 4572857 grid hard nofile 65536 grid soft nproc 2047
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
# 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,asmadmin,asmdba,vboxsf oracle useradd -g oinstall -G dba,asmdba,asmoper,asmadmin,vboxsf grid passwd oracle passwd grid
[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,asmadmin,asmdba,vboxsf oracle [root@rac1 ~]# useradd -g oinstall -G dba,asmdba,asmoper,asmadmin,vboxsf grid [root@rac1 ~]# passwd oracle oracle 사용자의 비밀 번호 변경 중 새 암호: 잘못된 암호: 사전에 있는 단어를 기반으로 합니다 잘못된 암호: 너무 간단함 새 암호 재입력: passwd: 모든 인증 토큰이 성공적으로 업데이트 되었습니다. [root@rac1 ~]# passwd grid grid 사용자의 비밀 번호 변경 중 새 암호: 잘못된 암호: 사전에 있는 단어를 기반으로 합니다 잘못된 암호: 너무 간단함 새 암호 재입력: passwd: 모든 인증 토큰이 성공적으로 업데이트 되었습니다.
mkdir -p /u01/app/oracle/product chown -R grid:oinstall /u01 chmod -R 770 /u01
grid 유저 : vi .bash_profile
export TMP=/tmp export TMPDIR=$TMP export EDITOR=vi export ORACLE_BASE=/u01/app/oracle export GRID_HOME=$ORACLE_BASE/12.1.0/grid export DB_HOME=$ORACLE_BASE/product/12.1.0/db_1 export ORACLE_HOME=$GRID_HOME export ORACLE_SID=+ASM export ORACLE_TERM=xterm export BASE_PATH=/usr/sbin:$PATH export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$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]$ '
oracle 유저 : vi .bash_profile
export TMP=/tmp export TMPDIR=$TMP export EDITOR=vi export ORACLE_UNQNAME=racdb export ORACLE_BASE=/u01/app/oracle export GRID_HOME=$ORACLE_BASE/12.1.0/grid export DB_HOME=$ORACLE_BASE/product/12.1.0/db_1 export ORACLE_HOME=$DB_HOME export ORACLE_SID=orcl 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]$ '
