Centos에서 oracle 12c 설치하기
- 패키지 설치하기
$> yum install binutils compat-libcap1 compat-libstdc++-33 compat-libstdc++-33.i686 gcc gcc-c++ glibc glibc.i686 glibc-devel glibc-devel.i686 ksh libgcc -y $> yum install libgcc.i686 libstdc++ libstdc++.i686 libstdc++-devel libstdc++-devel.i686 libaio libaio.i686 libaio-devel libaio-devel.i686 libXext libXext.i686 -y $> yum install libXtst libXtst.i686 libX11 libX11.i686 libXau libXau.i686 libxcb libxcb.i686 libXi libXi.i686 unixODBC unixODBC-devel -y
- 커널파라미터 수정
$> echo "fs.file-max = 6815744 kernel.sem = 250 32000 100 128 kernel.shmmni = 4096 kernel.shmall = 1073741824 kernel.shmmax = 4398046511104 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 net.ipv4.ip_local_port_range = 9000 65500" >> /etc/sysctl.conf $> sysctl -p
- 계정정보 설정
$> echo "oracle soft nofile 1024 oracle hard nofile 65536 oracle soft nproc 16384 oracle hard nproc 16384 oracle soft stack 10240 oracle hard stack 32768" >> /etc/security/limits.conf $> groupadd -g 54321 oinstall $> groupadd -g 54322 dba $> groupadd -g 54323 oper $> useradd -u 54321 -g oinstall -G dba,oper oracle $> passwd oracle {{ 패스워드 입력 2회 }} $> mkdir -p /usr/local/oracle/product/12.1.0/db_1 $> mkdir /usr/local/oraInventory $> chown -R oracle:oinstall /usr/local/oracle $> chown oracle.oinstall /usr/local/oraInventory $> chmod -R 775 /usr/local/oracle
- 시스템 변수 설정
$> echo " # Oracle Settings export TMP=/tmp export TMPDIR=\$TMP export ORACLE_HOSTNAME=orcl.localdomain export ORACLE_UNQNAME=orcl export ORACLE_BASE=/usr/local/oracle export ORACLE_HOME=\$ORACLE_BASE/product/12.1.0/db_1 export ORACLE_SID=orcl export PATH=/usr/sbin:\$PATH export PATH=\$ORACLE_HOME/bin:\$PATH export LD_LIBRARY_PATH=\$ORACLE_HOME/lib:/lib:/usr/lib export CLASSPATH=\$ORACLE_HOME/jlib:\$ORACLE_HOME/rdbms/jlib" >> /home/oracle/.bash_profile
- 시스템 구동 후 DB실행
$> echo " source /etc/profile su - oracle -c \"\$ORACLE_HOME/bin/lsnrctl start\" su - oracle -c \"\$ORACLE_HOME/bin/dbstart\" " >> /etc/rc.d/rc.local