전산쟁이의 기억노트

Centos에서 oracle 12c 설치하기 본문

oracledb

Centos에서 oracle 12c 설치하기

잘나가는전산쟁이 2022. 8. 1. 15:38
728x90
반응형
SMALL

패키지 설치하기

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

 

출처 - http://igoni.kr/books/dbms/page/centos-oracle-12c

 

Centos에서 oracle 12c 설치하기 | igoni.kr

패키지 설치하기 $> yum install binutils compat-libcap1 compat-libstdc++-33 compat-libstdc++-33.i686...

igoni.kr

 

728x90
반응형
LIST
Comments