[ORACLE] Single DB 설치 전 환경 조성

-- vi /etc/sysctl.conf

kernel.shmall = 2097152 kernel.shmmni = 4096 kernel.shmmax = 4294967296 kernel.sem = 250 32000 100 128 fs.file-max = 6815744 net.ipv4.ip_local_port_range = 9000 65500 net.core.rmem_default = 262144 net.core.wmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_max = 1048576 fs.aio-max-nr = 1048576

/sbin/sysctl -p 확인

 

-- vi /etc/security/limits.conf

oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536 oracle soft stack 10240 oracle hard stack 32768 oracle soft memlock unlimited oracle hard memlock unlimited

-- 방화벽 끄기

systemctl status firewalld systemctl stop firewalld systemctl disable firewalld

-- selinux 끄기

setenforce 0 getenforce   vi /etc/selinux/config SELINUX=disabled

-- vi /etc/hosts

127.0.0.1  localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1        localhost localhost.localdomain localhost6 localhost6.localdomain6 PC IP      hostname

-- 패키지설치

-- group, user 생성

groupadd dba useradd -g dba oracle mkdir -p /oracle/base/product/12.1 chown -R oracle:dba /oracle chmod -R 775 /oracle

 

-- 환경변수 설정 

su - oracle vi .bash_profile   export PATH umask 022 export EDITOR=vi export PS1="[\u@\h-$ORACLE_SID:\w]$" export ORACLE_BASE=/oracle/base export ORACLE_HOME=$ORACLE_BASE/product/19.3 export ORACLE_SID=orcl export NLS_LANG=AMERICAN_AMERICA.AL32UTF8 export TNS_ADMIN=$ORACLE_HOME/network/admin export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib:.: export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:.:$PATH export ORACLE_TERM=xterm stty erase ^H alias ss='sqlplus / as sysdba' alias log='tail -f $ORACLE_BASE/diag/rdbms/orcl/orcl/trace/alert_orcl.log' alias dbs='cd $ORACLE_HOME/dbs' alias dp='cd $ORACLE_BASE/admin/orcl/dpdump'   . .bash_profile (계정 다시 접속 시 자동 저장)

-- display 설정 

[root] export DISPLAY=localhost:0.0 export $DISPLAY xhost + [oracle] export DISPLAY=localhost:0.0 export $DISPLAY

-- 설치 

cd $ORACLE_HOME ./runInstaller