Database Installation in IBM AIX 7.1

Oracle Database (RDBMS) on Unix AIX,HP-UX,Linux,Mac OS X,Solaris,Tru64 Unix Operating Systems Installation and Configuration Requirements Quick Reference (8.0.5 to 11.2) (Doc ID 169706.1)

Oracle Version	11.2
AIX OS (32- and 64-bit stands for Oracle not OS)	AIX 7.1 TL 00 SP1 ("7100-00-01") or higher, 64-bit kernel
AIX Disk Space	6.40G Database 1.55G Software
AIX RAM	Database: minimum 1GB, recommended 2GB Grid Infrastructure for standalone server: minimum 1.5GB (plus another 1GB if installing Database too), recommended 4GB
AIX swap	Between 1GB and 2GB then 1.5 times RAM Between 2GB and 16 GB then match RAM More than 16 GB then 16GB RAM
AIX tmp	1GB
AIX JDK & JRE	IBM JDK 1.6.0.00 (64 BIT)
AIX Patches/ Packages versions in parens mean if OS is later than the listed version, the APAR is built into the later OS version and need not be applied. IMPORTANT: Review Note 390656.1 & apply AIX & Oracle Patch	AIX 5.3 required packages: bos.adt.base bos.adt.lib bos.adt.libm bos.perf.libperfstat 5.3.9.0 or later bos.perf.perfstat bos.perf.proctools rsct.basic.rte (For RAC configurations only) rsct.compat.clients.rte (For RAC configurations only) xlC.aix50.rte:10.1.0.0 or later gpfs.base 3.2.1.8 or later (Only for RAC systems that will use GPFS cluster filesystems) AIX 6.1 required packages: bos.adt.base bos.adt.lib bos.adt.libm bos.perf.libperfstat 6.1.2.1 or later bos.perf.perfstat bos.perf.proctools rsct.basic.rte (For RAC configurations only) rsct.compat.clients.rte (For RAC configurations only) xlC.aix61.rte:10.1.0.0 or later gpfs.base 3.2.1.8 or later (Only for RAC systems that will use GPFS cluster filesystems) AIX 7.1 required packages: bos.adt.base bos.adt.lib bos.adt.libm bos.perf.libperfstat bos.perf.perfstat bos.perf.proctools xlC.aix61.rte.10.1.0.0 or later xlC.rte.10.1.0.0 or later gpfs.base 3.3.0.11 or later (Only for RAC systems that will use GPFS cluster filesystems) APARs for AIX 7.1: IZ87216 IZ87564 IZ89165 IZ97035 See Note:1264074.1 and Note:1379753.1 for other AIX 7.1 patches that may be required Refer to the 11.2 AIX Install Guide. Part Number E24332-01
AIX Kernel Settings	set AIXTHREAD_SCOPE=S in the environment: export AIXTHREAD_SCOPE=S NOTE: This is only necessary on AIX5L. A change was introduced in AIX 6.1 which means that the variable does not need to be set. See section 5.5 (page 217) of the IBM AIX Version 6.1 Differences Guide From Section 2.5 of the 11.2 Install Guide for AIX: 2.5 Verifying UDP and TCP Kernel Parameters Use NDD to ensure that the kernel TCP/IP ephemeral port range is broad enough to provide enough ephemeral ports for the anticipated server workload. Ensure that the lower range is set to at least 9000 or higher, to avoid Well Known ports, and to avoid ports in the Registered Ports range commonly used by Oracle and other server ports. Set the port range high enough to avoid reserved ports for any applications you may intend to use. If the lower value of the range you have is greater than 9000, and the range is large enough for your anticipated workload, then you can ignore OUI warnings regarding the ephemeral port range. Use the following command to check your current range for ephemeral ports: # /usr/sbin/no -a | fgrep ephemeral tcp_ephemeral_low = 32768 tcp_ephemeral_high = 65535 udp_ephemeral_low = 32768 udp_ephemeral_high = 65535 In the preceding example, the TCP and UDP ephemeral ports are set to the default range (32768-65536). If you expect your workload to require a high number of ephemeral ports, such as high node counts or heavy use of Parallel Query, then update the UDP and TCP ephemeral port range to a broader range. For example: # /usr/sbin/no -p -o tcp_ephemeral_low=9000 -o tcp_ephemeral_high=65500 # /usr/sbin/no -p -o udp_ephemeral_low=9000 -o udp_ephemeral_high=65500 From Section 2.8.2 of the 11.2 Install Guide for AIX: 2.8.2 Configure System Configuration Parameters Parameter Recommended Value maxuprocs 16384 ncargs 128 Also see Note:1307804.1