deploy-Oracle-for-production-check-list

plan item list

#

• SGA_MAX_SIZE(GB) = RAM * 50%
• vm.nr_hugepages = (SGA_MAX_SIZE + (SGA_MAX_SIZE * 0.04)) * 1024 * 1024 / kernel.shmmni
• kernel.shmmax = SGA_MAX_SIZE * 1024 * 1024 * 1024
• kernel.shmall = SGA_MAX_SIZE * 1024 * 1024 * 1024 / kernel.shmmni
• DB execute account. need check limits.conf domain content if youre db acount not be named oracle!

check OS setting before install

#

• package had be installed

1

yum install bc binutils compat-libcap1 compat-libstdc++-33 lfutils-libelf elfutils-libelf-devel fontconfig-devel glibc glibc-devel ksh libaio libaio-devel libXrender libXrender-devel libX11 libXau libXi libXtst libgcc libstdc++ libstdc++-devel libxcb make policycoreutils policycoreutils-python smartmontools sysstat

• cvuqdisk installed

1

rpm -qi cvuqdisk

• calculate kernel.shmall value
• calculate kernel.shmmax value
• check limits.conf file

1
2
3
4
5

# oracle-database-preinstall-19c setting for memlock hard limit is maximum of 128GB on x86_64 or 3GB on x86 OR 90 % of RAM
oracle hard memlock unlimited

# oracle-database-preinstall-19c setting for memlock soft limit is maximum of 128GB on x86_64 or 3GB on x86 OR 90% of RAM
oracle soft memlock unlimited

• check sysctl.conf
• Configuring HugePages on Linux
• disable Transparent HugePages