AIX作業系統上安裝Oracle資料庫必不可少的幾項檢查工作

一直以來在UNIX/Linux like作業系統上安裝Oracle資料庫軟體都是一門精細活，在實際安裝軟體前有不少作業系統參數或配置需要我們關心。我們以10g release 2為例，盡可能完整地列出所有有必要的預檢查工作。

FYI: The runInstaller (OUI) uses/checks for temporary space by checking first for the TEMP environmental variable, then the TMP environmental variable and lastly the actual '/tmp' mount point FYI: The operating system also needs additional space by creating files under /tmp or if it finds TMPDIR environmental variable it will use that.

若結果為AIXTHREADNotSet則可以在該使用者的profile中指定"export AIXTHREAD_SCOPE=S"。

可以通過以下指令完成配置:

This VMM tuning tip is applicable for AIX 5.2 ML4+ or AIX 5.3 ML1+ lru_file_repage : This new parametter prevents the computational pages to be paged out. By setting lru_file_repage=0 (1 is the default value) you’re telling the VMM that your preference is to steal pages from FS Cache only. minfree = 120 x # lcpus Increase if page stealing activity, vmstat “po” column maxfree = minfree +(maxpaghead x # lcpus) minperm% = from 3 to 10 maxperm% = maxclient% = from 70 to 90 strict_maxclient = 1 On AIX part vmo –p –o v_pinshm = 1 Leave maxpin% at the default of 80% unless the SGA exceeds 77% of real memory : vmo –p –o maxpin%=[(total mem-SGA size)*100/total mem] + 3 On Oracle part (9i/10g) LOCK_SGA = TRUE Large Page Support – improves performance of prefetching On AIX part vmo –r –o lgpg_size = 16777216 –o lgpg_regions=(SGA size / 16 MB) chuser capabilities=CAP_BYPASS_RAC_VMM,CAP_PROPAGATE oracle (allow Oracle user ID to use Large Pages) ldedit –b lpdata oracle (to allow oracle binary to use large page data) export LDR_CNTRL=LARGE_PAGE_TEXT=Y@LARGE_PAGE_DATA=M (prior Oracle user ID to starting Oracle instance and listener to allow both large page text and large page data)

Users of AIX occasionally encounter long interactive-application response times when other applications in the system are running large writes to disk. Configuring I/O pacing limits the number of outstanding I/O requests against a file. AIX 6.1 enables I/O pacing by default and the default value: "minpout=4096 and maxpout=8193" is good for AIX6.1. However, in AIX 5.3, you need to explicitly enable this feature. Oracle's testing has shown that starting values of 8 for minpout and 12 for maxpout are a good baseline for most Oracle customers. However, every environment is different, and therefore different values may very well be acceptable, if the system has been properly tuned and shown to perform with differing values. To configure I/O pacing on the system via SMIT, using Oracle's recommended baseline values, enter the following at the command line as root

to be continued.......

本文轉自maclean_007 51CTO部落格，原文連結:http://blog.51cto.com/maclean/1277576