deploy-Oracle-for-production-check-list

2025-12-26 Oracle

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
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
rpm -qi cvuqdisk
  • calculate kernel.shmall value
  • calculate kernel.shmmax value
  • check limits.conf file
# 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

Recent Posts