Oracle 11g R2 But sample pre-installation environment preparation (for user, permissions, memory storage and system parameters related adjustments)

This paper is mainly about the requirements of ORACLE11GR2 on system and physical configuration and the appropriate parameter adjustment.

System:

[Email protected] ~]# Cat/etc/system-releasecentos release 6.7 (Final)

Kernel version:

[Email protected] ~]# uname-r2.6.32-573.el6.x86_64

Kernel-related parameters:

[Email protected] ~]# Vi/etc/sysctl.confkernel.shmall = 4294967296FS.AIO-MAX-NR = 1048576fs.file-max = 6815744# Kernel.shmall = 2097152#kernel.shmmax = 2147483648kernel.shmmni = 4096kernel.sem = 32000 T_range = 9000 65500net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048576# auto-enabled by xs-tools:install.shnet.ipv4.conf.all.arp_notify = 1

Number of files opened by the app process:

[Email protected] ~]# vi/etc/security/limits.conforacle soft nproc 2047oracle hard Nproc 1 6384

Number of files that the system allows to open:

[Email protected] ~]# vi/etc/security/limits.conforacle soft nofile 1024oracle hard Nofile 6 5536

Related management accounts and groups:

[[email protected] ~]# cat/etc/passwd|egrep-i "^ (Oracle)" |awk-f ":" ' {print '} ' oracle[[email protected] ~]# groups Orac Leoracle:oinstall dba Oper asmadmin asmdba[[email protected] ~]#

Related toolkits and development kits:

Physical Memory Size:

[Email protected] ~]# cat/proc/meminfo |grep-i memmemtotal:3974196 kbmemfree:2037892 kbshmem: 3920 KB

Swap partition size:

[Email protected] ~]# cat/proc/meminfo |grep-i swapswapcached:0 kbswaptotal:4112380 kbswapfree: 4112380 KB

TMPFS Partition size

[Email protected] ~]# cat/etc/fstab |egrep tmpfstmpfs/dev/shm tmpfs defaults,size=6g 0 0

/tmp temp directory Size:

[Email protected] ~]# df-khfilesystem Size used Avail use% mounted On/dev/mapper/volgroup-lv_root 45G 9.2G 34G 22%/tmpfs 6.0G 80K 6.0G 1%/dev/shm/dev/xvda1 477M 30M 42 2M 7%/boot

Oracle User environment variable settings

[email protected] ~]$ cat! $cat. bash_profile#. bash_profile# Get the aliases and Functionsif [-f ~/.BASHRC]; Then. ~/.bashrcfi# User specific environment and startup Programsumask export oracle_base= /u01/app/oracle export oracle_home= $ORACLE _base/product/11.2.0/dbhome_1export ld_library= $ORACLE _home/l Ibpath= $PATH: $HOME/bin: $ORACLE _home/bin:.export PATH

Oracle 11g R2 But sample pre-installation environment preparation (for user, permissions, memory storage and system parameters related adjustments)