CREATE PLUGGABLE DATABASE pdb ADMIN USER pdbAdm IDENTIFIED BY pwd123 CREATE_FILE_DEST='/app/oracle/oradata/pdb';
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
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
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
sudo yum -y install xorg*
export DISPLAY=localhost:0.0
su - oracle
export DISPLAY=localhost:0.0
echo $DISPLAY
sudo vi /etc/selinux/config
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
echo "Creating dba Group and oracle User. Passwd is roqkftjqj"
groupadd dba
sudo useradd -g dba oracle
sudo passwd roqkftjqj
sudo chown -R oracle:dba /app
sudo chmod -R 775 /app
echo "Making ORACLE_HOME Env Path, setting alias"
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