오라클 설치 스크립트

anonymous·2021년 12월 13일
0
### 설치 전

CREATE PLUGGABLE DATABASE pdb ADMIN USER pdbAdm IDENTIFIED BY pwd123 CREATE_FILE_DEST='/app/oracle/oradata/pdb';
# cat /etc/sysctl.conf 
# cat /etc/security/limits.conf

### 설치 ORACLE 12C
mkdir -p /app/oracle
### 설치 파일 
ORACLEINSTALLFILE=/app/oracle/installZip/OracleInstall1.zip
ORACLEINSTALLFILE2=/app/oracle/installZip/OracleInstall2.zip
### /설치 파일 


if [ -f "$ORACLEINSTALLFILE" ]; then
    echo "$ORACLEINSTALLFILE exists. Staring Oralce DB Installation."
else 
    echo "$ORACLEINSTALLFILE does not exist. Please upload Oracle Install File"
    exit 1
fi

### 의존성 설치 파일 
echo "Installing Oracle DB Dependencies....."
sudo yum -y install binutils elfutils-libelf elfutils-libelf-devel
sudo yum -y install glibc glibc-common glibc-devel glibc-headers gcc gcc-c++ libaio-devel
sudo yum -y install libaio libgcc libstdc++ libstdc++ make sysstat unixODBC unixODBC-devel
sudo yum -y install unzip
sudo yum -y install libnsl # libsnl.so.1 error
    # compat-libstdc++-33-3.2.3 
sudo curl -o compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm http://mirror.centos.org/centos/7/os/x86_64/Packages/compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm
sudo rpm -Uvh compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm 
yum install -y http://mirror.centos.org/centos/7/os/x86_64/Packages/compat-libcap1-1.10-7.el7.x86_64.rpm
yum install -y ksh

# JAVA
yum install -y java-1.8.0-openjdk-devel.x86_64
java -version
vi /etc/profile
JAVA_HOME=/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.151-1.b12.el6_9.x86_64

# DeskTop
sudo yum -y install xorg*
# Localhost IP PUT!!! 
# export DISPLAY=IP주소:0.0
export DISPLAY=localhost:0.0
su - oracle
export DISPLAY=localhost:0.0
echo $DISPLAY
sudo vi /etc/selinux/config
### /의존성 설치 파일 

### KERNEL 파라미터 
echo "Setting Kernel Parameters"
echo -e "
fs.aio-max-nr = 1048576
fs.file-max = 6815744 
# Controls the maximum shared segment size, in bytes
kernel.shmmax = 2147483648
# Controls the maximum shared memory size, in pages
kernel.shmall = 2097152
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586
" >> /etc/sysctl.conf 

echo "Setting limits to Oracle User"
echo "
oracle   soft   nproc    2047
oracle   hard   nproc    16384
oracle   soft   nofile   1024
oracle   hard   nofile   65536
oracle   soft   stack    10240
oracle   hard   stack    32768
" >> /etc/security/limits.conf

echo "Reloading Config File"
sysctl -p 
sysctl -a

### /KERNEL 파라미터 

### 사용자 그룹, 계정 생성
echo "Creating dba Group and oracle User. Passwd is roqkftjqj"
groupadd dba
sudo useradd -g dba oracle 
sudo passwd roqkftjqj #roqkftjqj   (개발서버)
# 오라클 설치 dir 생성 및 계정 권한 부여
sudo chown -R oracle:dba /app
sudo chmod -R 775 /app

echo "Making ORACLE_HOME Env Path, setting alias"
# oracle 계정으로 접속해서 환경변수 저장
su - oracle


echo -e "
export ORACLE_BASE=/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/12.1.0/dbhome_1

export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORACLE_SID=orcl

export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
export LD_LIBRARY_PATH=$ORACLE_HOME
export PATH=$ORACLE_HOME/bin
" >> .bash_profile

alias sqls='sqlplus / as sysdba'

echo "Starting Oracle Installation"

### 오라클 설치파일 압축 풀기 
unzip $ORACLEINSTALLFILE -d /app/oracle/stage
unzip $ORACLEINSTALLFILE2 -d /app/oracle/stage

unzip $ORACLEINSTALLFILE -d /app/oracle/stage
unzip $ORACLEINSTALLFILE2 -d /app/oracle/stage

### /오라클 설치파일 압축 풀기 
chown -R oracle:dba /app/oracle/stage

### 오라클 설치 위치 
mkdir -p /app/oracle/u01 /app/oracle/u02
chown -R oracle:dba /app/oracle/u01 /app/oracle/u02
chmod -R 775 /app/oracle/u01 /app/oracle/u02
chmod g+s /app/oracle/u01 /app/oracle/u02

### 오라클 설치 전


### 오라클 설치 
# cd /stage/database
# ./runInstaller

# Install ORACLE
# ssh -X oracle@IP주소
# yum install xorg*
# export DISPLAY=localhost:0.0
profile
기술블로거입니다

0개의 댓글