02. 운영체제(리눅스) 환경 설정

cat /etc/oracle-release
cat /etc/redhat-release
lsb_release -id
uname -r

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-*

vi /etc/hosts

### Public
10.0.1.101 rac1.localdomain rac1
10.0.1.102 rac2.localdomain rac2
### Private
10.0.2.101 rac1-priv.localdomain rac1-priv
10.0.2.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.121 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%]

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  no file  65536
oracle  hard  nproc    16384
oracle  soft  nproc    2047

service dnsmasq start
chkconfig dnsmasq on

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

mv /etc/sysconfig/ntpd /etc/sysconfig/ntpd.original
mv /etc/ntp /etc/ntp.original
mv /etc/ntp.conf /etc/ntp.conf.original

vi /etc/sysconfig/selinux

SELINUX=disabled

# 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

mkdir /u01
chown -R oracle:oinstall /u01

vi .bash_profile

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

vi .db_env

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

vi .grid_env

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

vi .bashrc

alias grid_env='. ~/.grid_env'
alias db_env='. ~/.db_env'
alias ss='sqlplus / as sysdba'
alias ltr='ls -ltr'

Content

공간 도구