Oracle Install - quick notes

Quick notes - will format etc later. This for 12.2 but will amend for 19c


sudo su -

yum install oracle-database-server-12cR2-preinstall

yum install oracle-database-preinstall-19c

https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/index_src.html

https://www.oracle.com/database/technologies/oracle19c-linux-downloads.html

https://oracle-base.com/articles/12c/oracle-db-12cr1-installation-on-oracle-linux-7

yum install xorg-x11-xauth xorg-x11-fonts-* xorg-x11-font-utils xorg-x11-fonts-Type1

yum install xclock


groupadd -g 54327 asmdba

groupadd -g 54328 asmoper

groupadd -g 54329 asmadmin

useradd -u 54322 -g oinstall -G asmadmin,asmdba,asmoper,racdba,dba grid

mkdir --parents /u01/app/12.2.0/gridhome

chown --recursive grid:oinstall /u01

usermod -a -G asmdba oracle

mkdir --parents /u01/app/oracle/product/12.2.0/dbhome_1

passwd oracle

mkdir --parents /u99/media/software/cubic

chown --recursive oracle:oinstall /u99/media

cd /u99/media/software

mkdir database

chown oracle:oinstall database

cd /backup

mkdir --parents /oracle/archlogs

cd /oracle

mkdir database_backups

cd archlogs

mkdir ngtapp

mkdir ngtods

cd ../database_backups

mkdir ngtapp

mkdir ngtods

cd ngtapp

mkdir logs

chown --recursive oracle:oinstall /backup

COPY THE SOURCE FILES ACROSS

INSTALL ASM

cd /u01/app/12.2.0/gridhome
cp /u99/media/software/database/linuxx64_12201_grid_home.zip .

unzip linuxx64_12201_grid_home.zip

chown -R grid:oinstall /u01/app/12.2.0/gridhome

df -h | grep tmp

/dev/mapper/VGroot-LVtmp 9.8G 37M 9.2G 1% /tmp

cat /proc/meminfo check for 16GB of swap space

/etc/hostname
This will return the hostname of the server

cat /etc/sysconfig/selinux need to grep for SELINUX=enforcing and SELINUXTYPE=targeted and stop of not correct

vi /etc/security/limits.conf

append to bottom of file

grid soft nproc 2047
grid hard nproc 16384
grid soft nofile 1024
grid hard nofile 65536
grid soft stack 10240
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack 10240

systemctl disable firewalld

cat /sys/kernel/mm/transparent_hugepage/enabled should be always madvise [never]
cat /etc/default/grub look for transparent_hugepage=never

su - root
cd /u01/app/12.2.0/gridhome/cv/rpm/
rpm -qi cvuqdisk

export CVUQDISK_GRP=oinstall
rpm -iv cvuqdisk-1.0.10-1.rpm


Prior to installing grid software

exit
sudo su - grid

cd /u01/app/12.2.0/gridhome
./runcluvfy.sh stage -pre crsinst -n auzaetngtods01

INSTALL GRID

as root
passwd grid

Create Mobaxterm session logging in directly as grid
export LC_ALL=C
xclock

sudo su - grid
cd /u01/app/12.2.0/gridhome/
./gridSetup.sh

'Configure Oracle grid infrastructure for standalone server (Oracle restart)'

Install Oracle software

su - oracle
mkdir /u99/media/software/database/DATABASE
cp /u99/media/software/database/linuxx64_12201_database.zip /u99/media/software/database/DATABASE
cd /u99/media/software/database/DATABASE
unzip linuxx64_12201_database.zip

export LC_ALL=C
cd database
./runInstaller

'install database software only'

'single instance database installation'

Enterprise edition

Change software location back to '/u01/app/oracle/product/12.2.0/dbhome_1'