1. 리눅스 세팅 및 엔진 설치
########################
## 운영체제 버전 확인(root) ##
########################
uname -a
cat /etc/redhat-release
cat /etc/*system-release*
######################
## 디스크 공간 확인(root) ##
######################
df -h
##########################
## 메모리 및 SWAP 체크(root) ##
##########################
grep MemTotal /proc/meminfo
grep SwapTotal /proc/meminfo
free -h
#meminfo 값은 정확하고 free -h 값을 내림 처리한 듯
#####################
## hosts 파일 설정(root) ##
#####################
cat /etc/hosts
vi /etc/hosts
<서버접근 ip> <hostname>
192.168.7.115 test
######################
## 방화벽 중지 체크(root) ##
######################
systemctl status firewalld
#방화벽 중지
systemctl stop firewalld
#방화벽 비활성화 - 재부팅 이후에도 실행 안됨
systemctl disable firewalld
###################
## SELinux 설정(root) ##
###################
vi /etc/sysconfig/selinux
SELINUX=disabled
##########################
## 커널 파라미터 값 설정(root) ##
##########################
vi /etc/sysctl.conf
kernel.shmall = 2097152
kernel.shmmni = 4096
kernel.shmmax = 4050477056
kernel.sem = 250 32000 100 128
fs.file-max = 6815744
fs.aio-max-nr = 1048576
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
net.ipv4.ip_local_port_range = 9000 65500
/sbin/sysctl -p
/sbin/sysctl -a
#커널 파라미터 값 단위는 바이트
#getconf PAGE_SIZE << page size 구하는 방법
#kernel.shmall: Physical Size/PAGE_SIZE
#kernel.shmmax: 1/2 of Physical Size or more
#######################
## 유저 제한 값 설정(root) ##
#######################
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
######################
## 유저 및 그룹 생성(root) ##
######################
grep dba /etc/group
grep oracle /etc/passwd
grep 500 /etc/group
grep 500 /etc/passwd
groupadd -g 500 dba
useradd -g dba -u 500 oracle
id oracle
passwd oracle
#########################
## 오라클 디렉토리 생성(root) ##
#########################
ls -arlt /ora*
mkdir -p /oracle/app/oracle/product/19c/db_home
mkdir /oradata
mkdir /oraarch
mkdir /oracd
#########################################
## 오라클 디렉토리 소유자 변경 및 권한 부여(root) ##
#########################################
ls -arlt /ora*
chown -R oracle:dba /oracle
chown -R oracle:dba /oradata
chown -R oracle:dba /oraarch
chown -R oracle:dba /oracd
chmod -R 775 /oracle
#####################
## local repository(root) ##
#####################
#리눅스 설치파일 삽입 후 작업
mount /dev/sr0 /media
cd /etc/yum.repos.d
ls
mkdir back
mv *.repo back
vi local.repo
[rpm]
name=localRepository
baseurl=file:///media/local
enabled=1
gpgcheck=0
yum update
##################
## 패키지 설치(root) ##
##################
Linux7
rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n' bc binutils compat-libcap1 compat-libstdc++ compat-libstdc++.i686 elfutils-libelf-devel gcc gcc-c++ glibc.i686 glibc glibc-devel.i686 glibc-devel ksh libaio.i686 libaio libaio-devel libaio-devel.i686 libgcc.i686 libgcc libstdc++.i686 libstdc++ libstdc++-devel.i686 libstdc++-devel make sysstat xorg-x11-utils xorg-x11-xauth unixODBC unixODBC-devel
yum install bc binutils compat-libcap1 compat-libstdc++ compat-libstdc++.i686 elfutils-libelf-devel gcc gcc-c++ glibc.i686 glibc glibc-devel.i686 glibc-devel ksh libaio.i686 libaio libaio-devel libaio-devel.i686 libgcc.i686 libgcc libstdc++.i686 libstdc++ libstdc++-devel.i686 libstdc++-devel make sysstat xorg-x11-utils xorg-x11-xauth unixODBC unixODBC-devel
Linux6
rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n' bc binutils compat-libcap1 compat-libstdc++ compat-libstdc++.i686 elfutils-libelf-devel gcc gcc-c++ glibc.i686 glibc glibc-devel.i686 glibc-devel ksh libaio.i686 libaio libaio-devel libaio-devel.i686 libgcc.i686 libgcc libstdc++.i686 libstdc++ libstdc++-devel.i686 libstdc++-devel make sysstat xorg-x11-utils \xorg-x11-xauth
yum install bc binutils compat-libcap1 compat-libstdc++ compat-libstdc++.i686 elfutils-libelf-devel gcc gcc-c++ glibc.i686 glibc glibc-devel.i686 glibc-devel ksh libaio.i686 libaio libaio-devel libaio-devel.i686 libgcc.i686 libgcc libstdc++.i686 libstdc++ libstdc++-devel.i686 libstdc++-devel make sysstat xorg-x11-utils \xorg-x11-xauth
#################################
## 오라클 유저 bash_profile 설정(oracle) ##
#################################
su - oracle
vi ~/.bash_profile
export PS1="[\u@\h \W]$ "
umask 022
export EDITOR=vi
export ORACLE_SID=orcl
export ORACLE_TERM=xterm
export ORACLE_BASE=/oracle/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/19c/db_home
export TNS_ADMIN=$ORACLE_HOME/network/admin
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/network/lib:/usr/lib
export PATH=$PATH:$ORACLE_HOME/bin:/bin:/usr/bin:/sbin:/usr/ccs/bin:/usr/openwin/bin:/usr/ucb:
export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
export LANG=C
alias ss='sqlplus "/as sysdba"'
. ~/.bash_profile
############
## 엔진 설치 ##
############
###설치 파일 및 패치 파일 업로드 후 소유자 변경
root> cd /oracd
chown -R oracle:dba LINUX.X64_193000_db_home.zip
chown -R oracle:dba p36582781_190000_Linux-x86-64.zip
chown -R oracle:dba p6880880_190000_Linux-x86-64.zip
----- su - oracle
cd /oracd
unzip LINUX.X64_193000_db_home.zip -d $ORACLE_HOME
export DISPLAY=192.168.2.75:0.0 ##설치 GUI로 (화면에 보이기 위한 설정)
./runInstaller ##설치 실행
2. PATCH
############Patch#####################
패치 688 -> RU 순으로 패치 한다.
###opatch version 확인
[oracle@test database]$ cd $ORACLE_HOME/OPatch
[oracle@test OPatch]$ opatch version
OPatch Version: 12.2.0.1.17
OPatch succeeded.
###opatch 백업
mv $ORACLE_HOME/OPatch $ORACLE_HOME/OPatch_OLD
unzip /oracd/p6880880_190000_Linux-x86-64.zip -d $ORACLE_HOME
###경로 이동
[oracle@test db_home]$ cd /oracd
unzip p36582781_190000_Linux-x86-64.zip
###압축 해제 후 디렉토리로 이동
cd 36582781
실행조건 검사
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oracd/36582781
passed.
#####opatch apply
$ORACLE_HOME/OPatch/opatch apply
########패치 완료 후 검사
$ORACLE_HOME/OPatch/opatch lspatches
$ORACLE_HOME/OPatch/opatch lsinventory
##############
리스너 구성
##############
netca
##############
DBCA
##############
˗ˋˏ O R A C L E ˎˊ˗