安装oracle数据库物理内存不够,AIX操作系统上安装Oracle数据库必不可少的几项检查工作...

最新推荐文章于 2023-09-22 23:45:00 发布

当年流水

最新推荐文章于 2023-09-22 23:45:00 发布

阅读量435

点赞数

文章标签：安装oracle数据库物理内存不够

一直以来在UNIX/Linux like操作系统上安装Oracle数据库软件都是一门精细活，在实际安装软件前有不少操作系统参数或配置需要我们关心。我们以10g release 2为例，尽可能完整地列出所有有必要的预检查工作。

1.确认使用的AIX版本经过认证，AIX 5.2之前的版本包括5.1都没有通过Oracle 10g的认证，换而言之如果你要安装10g的话就要保证AIX的版本>=5.2，我们可以通过以下脚本进行验证:

OS=`/usr/bin/uname -s`

if /usr/bin/test /usr/bin/oslevel

then

OSVER6CHAR=`/usr/bin/oslevel -r | /usr/bin/sed 's/-//''`

OSVER3CHAR=`/usr/bin/oslevel -r | /usr/bin/awk '{print substr($1,1,3)}'`

OSVER=`/usr/bin/oslevel -r`

else

OSVER6CHAR="000000"

OSVER3CHAR="000"

OSVER="000000"

case $OSVER3CHAR in

"414"|"415"|"420"|"421"|"432"|"433"|"510")

/usr/bin/echo "$OS $OSVER is not certified with 10g RDBMS"

;;

"520"|"530")

if test -x /usr/bin/lslpp

then

OSBIT=`/usr/bin/lslpp -L | /usr/bin/grep bos.64bit | /usr/bin/awk '{print $1}' | /usr/bin/sed 's/bos.//' | /usr/bin/sed 's/bit//'`

else

OSBIT="32"

if /usr/bin/test /usr/bin/getconf

then

GETCONFHWBIT=`/usr/bin/getconf HARDWARE_BITMODE 2>>/dev/null`

case $GETCONFHWBIT in

"undefined")

/usr/bin/echo "HARDWARE_BITMODE is undefined or invalid, AIX OS is not 5.2 or 5.3"

;;

"64")

HARDWARE_BITMODE=64

;;

"32")

HARDWARE_BITMODE=32

;;

/usr/bin/echo "HARDWARE_BITMODE check is invalid"

;;

esac

else

/usr/bin/echo "getconf command is not found"

if [ $OSBIT = 64 -a $GETCONFHWBIT = 64 ]

then

/usr/bin/echo "Certified with 10g RDBMS"

else

/usr/bin/echo "$OS $OSVER is not certified with 10g RDBMS"

;;

/usr/bin/echo "$OS OS Version not determinable"

;;

esac

若以上脚本输出结果为Certified with 10g RDBMS，则说明当前的操作系统版本通过了10g的认证。

2.系统软件包是否完整安装，其中包括"bos.adt.base" "bos.adt.lib" "bos.adt.libm" "bos.perf.perfstat" "bos.perf.libperfstat" "bos.perf.proctools"等基础包:

OSpackagesOK=true

if /usr/bin/test -x /usr/bin/lslpp

then

for PACKAGE in "bos.adt.base" "bos.adt.lib" "bos.adt.libm" "bos.perf.perfstat" "bos.perf.libperfstat" "bos.perf.proctools"

if [ `/usr/bin/lslpp -l | /usr/bin/grep -c $PACKAGE` != 0 ]

then

STATE=`/usr/bin/lslpp -l | /usr/bin/grep $PACKAGE | /usr/bin/awk '{print $3}' | /usr/bin/sed '2,$d'`

if [ $STATE != "COMMITTED" ]

then

if [ $STATE != "APPLIED" ]

then

/usr/bin/echo "$PACKAGE"NotApplied

OSpackagesOK=false

else

/usr/bin/echo "$PACKAGE"NotInstalled

OSpackagesOK=false

done

else

/usr/bin/echo "NoAccess"

OSpackagesOK=false

if [ $OSpackagesOK = true ]

then

/usr/bin/echo "All required OS packages are installed"

若以上脚本未返回"All required OS packages are installed"，则说明系统包安装不完整，各种返回结果的相关解释:

ReturnValue Action

---------------------------------------------------------------------

"$PACKAGE"NotInstalled Please install OS $package or its latest

version. Please refer to the following list of

required OS packages:

bos.adt.base, bos.adt.lib, bos.adt.libm,

bos.perf.perfstat, bos.perf.proctools

"$PACKAGE"NotApplied The $package was found but is not applied or

commited, please make sure that it is applied.

NoAccess OS packages could not be verified because the

user has no execute permission to /bin/lslpp.

Please provide user with execute permission.

3.是否安装了合适的操作系统补丁，如果是5.3的话要求在ML02的基础上安装有IY58143 IY59386 IY60930 IY66513 IY70159 apar fix。

OSpatchesOK=true

if /usr/bin/test oslevel

then

OSVER4CHAR=`/usr/bin/oslevel -r | /usr/bin/awk -F- '{print $1}'`

else

OSVER4CHAR="0000"

if test -x /usr/sbin/instfix

then

if [ $OSVER4CHAR -eq "5200" ]

then

for PATCH in IY63133 IY64978 IY63366 IY64691 IY64737 IY65001

if [ `/usr/sbin/instfix -ik $PATCH 2>&1 | /usr/bin/grep -ic "no"` != 0 ]

then

/usr/bin/echo "$PATCH"_NotInstalled

OSpatchesOK=false

done

if [ `/usr/sbin/instfix -ik 5200-04_AIX_ML 2>&1 | /usr/bin/grep -ic "no"` != 0 ]

then

/usr/bin/echo "5200-04_AIX_ML_NotInstalled"

OSpatchesOK=false

elif [ $OSVER4CHAR -eq "5300" ]

then

for PATCH in IY58143 IY59386 IY60930 IY66513 IY70159

if [ `/usr/sbin/instfix -ik $PATCH 2>&1 | /usr/bin/grep -ic "no"` != 0 ]

then

/usr/bin/echo "$PATCH"_NotInstalled

OSpatchesOK=false

done

if [ `/usr/sbin/instfix -ik 5300-02_AIX_ML 2>&1 | /usr/bin/grep -ic "no"` != 0 ]

then

/usr/bin/echo "5300-02_AIX_ML_NotInstalled"

OSpatchesOK=false

else

/usr/bin/echo "NoAccess"

OSpatchesOK=false

if [ $OSpatchesOK = true ]

then

/usr/bin/echo "PatchesFound"

若返回的结果不为PatchesFound，则可能是系统补丁安装不到位，各种可能的返回结果:

ReturnValue Action

---------------------------------------------------------------------

$PATCH# Please install OS $PATCH or its latest

version.

5.2: IY63133, IY64978, IY63366, IY64691,

IY64737, IY65001 and

5200-04_AIX_ML maintenance level.

5.3: IY58142, IY59386, IY60930, IY66513,

IY70159 and

5300-02_AIX_ML maintenance level

NoAccess OS patches could not be verified because the

user has no execute permission to

/usr/sbin/instfix. Please provide user with

execute permission.

4.正确配置了操作系统用户，当前登录的用户名应出现在/etc/passwd文件中:

USER=`/usr/bin/id -nu`

if /usr/bin/test -r /etc/passwd

then

if [ "x${USER}x" = `/usr/bin/cat /etc/passwd | /usr/bin/awk -F: '{print "x"$1"x"}' | /usr/bin/grep -e "x${USER}x"` ]

then

/usr/bin/echo userOK

else

/usr/bin/echo "$USER not in /etc/passwd."

else

/usr/bin/echo "Can not read /etc/passwd"

5.正确配置了用户组，当前用户的主用户组应出现在/etc/group文件中:

GROUP=`/usr/bin/id -ng`

if /usr/bin/test -r /etc/group

then

if [ "x${GROUP}x" = "`/usr/bin/cat /etc/group | /usr/bin/awk -F: '{print "x"$1"x"}' | /usr/bin/grep "x${GROUP}x"`" ]

then

/usr/bin/echo "GroupOK"

else

/usr/bin/echo "Group not in /etc/group"

else

/usr/bin/echo "Can not read /etc/group"

6.验证ORACLE_HOME环境变量指定的目录是否有效:

if /usr/bin/test %40%

then

if /usr/bin/test -d %40%

then

if /usr/bin/test -h %40%

then

/usr/bin/echo OHsymlink

else

/usr/bin/echo "OHexists"

else

/usr/bin/echo OHnotvalid

else

/usr/bin/echo "OHNotSpecified"

该项其实可以不做硬性要求，可能返回的各种结果:

Return value Action required

---------------------------------------------------------------------

OHnotvalid Please ensure that the correct location is provided

or ensure that this directory has been created and

re-run this script

OHsymlink ORACLE_HOME is a symbolic link

OHNotSpecified No ORACLE_HOME value was provided for verification

7.ORACLE_HOME环境变量指定目录的权限设置是否合理:

READPERMISSION=false

WRITEPERMISSION=false

EXECUTEPERMISSION=false

if /usr/bin/test %40%

then

if /usr/bin/test -d %40%

then

if /usr/bin/test -r %40%

then

READPERMISSION=true

else

/usr/bin/echo NoReadPerm

if /usr/bin/test -w %40%

then

WRITEPERMISSION=true

else

/usr/bin/echo NoWritePerm

if /usr/bin/test -x %40%

then

EXECUTEPERMISSION=true

else

/usr/bin/echo NoExecutePerm

else

/usr/bin/echo OHNotExist

else

/usr/bin/echo OHNotSpecified

if [ $WRITEPERMISSION = true -a $READPERMISSION = true -a $EXECUTEPERMISSION = true ]

then

/usr/bin/echo CorrectPerms

else

if /usr/bin/test %40%

then

/usr/bin/echo WrongPerms

若未设置ORACLE_HOME环境变量则无需关心，可能返回的各种结果:

Return value Action required

---------------------------------------------------------------------

NoReadPerm Make sure the install user has read permission

on ORACLE_HOME

NoWritePerm Make sure the install user has write permission

on ORACLE_HOME

NoExecutePerm Make sure the install user has execute permission

on ORACLE_HOME

OHNotExist ORACLE_HOME does not exist, please create the

ORACLE_HOME mount point and ensure the permissions

are correctly set (chmod 755)

OHNotSpecified ORACLE_HOME can not be verified as the ORACLE_HOME

is not specified

WrongPerms The specified ORACLE_HOME does not have correct

permissions. Please have your System

Administrator correct the permissions to "rwx" for

the ORACLE_HOME mount point"

8.当前用户的umask掩码是否设置为022，若不是则需要修改为022:

MASK=`/usr/bin/umask`

if [ $MASK -eq 022 ]

then

/usr/bin/echo UmaskOK

else

/usr/bin/echo UmaskNotOK

9.是否设置了LD_LIBRARY_PATH环境变量，若设置了则需要unset该变量以保证安装顺利:

if /usr/bin/test $LD_LIBRARY_PATH

then

/usr/bin/echo IsSet

else

/usr/bin/echo UnSet

10.如上若设置了LIBPATH环境变量，则需要unset该变量:

if /usr/bin/test $LIBPATH

then

/usr/bin/echo IsSet

else

/usr/bin/echo UnSet

11.进一步验证当前PATH变量中不存在引用/etc/oratab文件中列出的其他ORACLE_HOME的条目,若存在则需要在安装前移除:

NoneFound=true

if /usr/bin/test -f /etc/oratab

then

for FILE in /etc/oratab

for LINE in `/usr/bin/cat $FILE | /usr/bin/grep -v '#' | /usr/bin/grep -v '^$' | /usr/bin/awk -F: '{print $2}' | /usr/bin/sort -u`

for ENVPATHS in PATH

if [ `/usr/bin/env | /usr/bin/grep -wc $ENVPATHS | /usr/bin/grep :$ENVPATHS= | /usr/bin/wc -l` -ge 1 ]

then

if [ `/usr/bin/env | /usr/bin/grep -w $ENVPATHS | /usr/bin/grep :$ENVPATHS= | /usr/bin/grep -c $LINE` -ge 1 ]

then

/usr/bin/echo OratabEntryInPath

NoneFound=false

done

if [ $NoneFound = true ]

then

/usr/bin/echo NoneFound

一般结果都为NoneFound，除非你的系统中确实使用到了多个ORACLE_HOME。

12.oraInventory目录的权限设置是否合理，若不合理会导致安装程序无法写入软件安装信息:

if /usr/bin/test -f /etc/oraInst.loc

then

ORAINVENTORYLOC=`/usr/bin/cat /etc/oraInst.loc | /usr/bin/grep 'inventory_loc' | /usr/bin/grep -v "#" | /usr/bin/awk -F= '{print $2}'`

if /usr/bin/test -w "$ORAINVENTORYLOC"

then

if /usr/bin/test -r "$ORAINVENTORYLOC"

then

/usr/bin/echo oraInventoryOK

else

/usr/bin/echo oraInventoryNotOK

else

/usr/bin/echo oraInventoryNotOK

else

/usr/bin/echo oraInventoryNotFound

可能返回的各类结果:

Return value Action required

---------------------------------------------------------------------

oraInventoryNotOK Make sure the install user has write permission

to $ORAINVLOC

oraInventoryNotFound The file /etc/oraInst.loc was not found. This

is not a problem if this is the first install of

oracle on the server.

13./tmp临时目录是否可写，并Free空间足够:

tmpOK=false

vartmpOK=false

if /usr/bin/test $TEMP

then

TEMPLOC=$TEMP

else

if /usr/bin/test $TMP

then

TEMPLOC=$TMP

else

TEMPLOC=/tmp

if /usr/bin/test -d $TEMPLOC

then

TMPFREE=`/usr/bin/df -k $TEMPLOC | /usr/bin/awk '{print $3}' | /usr/bin/sed '1d'`

TMPFREE=`/usr/bin/expr $TMPFREE / 1024`

if [ $TMPFREE -lt 400 ]

then

/usr/bin/echo TempFreeIsLow

else

if /usr/bin/test -w "$TEMPLOC"

then

tmpOK=true

else

/usr/bin/echo TempNoWrite

else

/usr/bin/echo invalidDIR

if /usr/bin/test $TMPDIR

then

TMPDIRLOC=$TMPDIR

else

TMPDIRLOC=/var/tmp

if /usr/bin/test -d $TMPDIRLOC

then

TMPDIRSIZE=`/usr/bin/df -k "$TMPDIRLOC" | /usr/bin/awk '{print $3}' | /usr/bin/sed '1d'`

TMPDIRSIZE=`/usr/bin/expr $TMPDIRSIZE / 1024`

if [ $TMPDIRSIZE -lt 200 ]

then

/usr/bin/echo TMPDIRTooSmall

else

if /usr/bin/test -w "$TMPDIRLOC"

then

vartmpOK=true

else

/usr/bin/echo TMPDIRNoWrite

else

/usr/bin/echo invalidDIR

if [ $tmpOK = true -a $vartmpOK = true ]

then

/usr/bin/echo TempSpaceOK

/tmp目录不可写或空间不足均会引起安装失败，可能返回的各类结果:

ReturnValue Action

----------------------------------------------------------------------

TempFreeIsLow ALERT- Your temp space ($TEMP or $TMP or /tmp) has

less than the required 400 Mb free space. Please

make sure your temp space has at least 400 Mb of

free space

TempNoWrite ALERT- your temp space ($TEMP or $TMP or /tmp) does

not have write permissions for this user

TMPDIRTooSmall ALERT- $TMPDIR or /tmp has less than the

required 200 Mb. Please point the TMPDIR

environmental variable to a mount point with at

least 200 Mb of free space

TMPDIRNoWrite ALERT- $TMPDIR is set in the environment;

however, $TMPDIRLOC does not have write permissions

for this user

invalidDIR ALERT- $TEMP or $TMPDIR are set in the environment

with invalid directory

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.

14.空闲SWAP是否充足，SWAP过少可能导致安装失败:

if test -x /usr/sbin/lsps

then

SWAP=`/usr/sbin/lsps -s | /usr/bin/awk '{print $1}' | /usr/bin/sed '1d' | /usr/bin/sed 's/MB/ /'`

if /usr/bin/test -z "$SWAP"

then

/usr/bin/echo SWAPNotSet

else

/usr/bin/echo $SWAP

else

/usr/bin/echo "ALERT- SWAP space cannot be determined"

15.是否有已启动的Oracle Universal Installer，若有则需要先停止OU的java安装界面进程:

if [ `/usr/bin/ps -ef | /usr/bin/grep -i runInstaller | /usr/bin/grep -v grep | /usr/bin/wc -l` -ge 1 ]

then

/usr/bin/echo AnotherOUIup

else

/usr/bin/echo NoOtherOUI

16.ORACLE_HOME指向文件夹所在文件系统是否有足够的磁盘空间，若空间不足则建议改变软件安装的文件系统或扩充文件系统:

if /usr/bin/test %40%

then

if /usr/bin/test -d %40%

then

OHDISKSPACEKB=`/usr/bin/df -k %40% | /usr/bin/awk '{print $3}' | /usr/bin/sed '1d'`

OHDISKSPACE=`/usr/bin/expr $OHDISKSPACEKB / 1024`

DBANDSW=4200

DBORSW=3000

CLIENTONLY=1500

if [ $OHDISKSPACE -ge $DBANDSW ]

then

/usr/bin/echo DiskSpaceOK

elif [ $OHDISKSPACE -ge $DBORSW ]

then

/usr/bin/echo OnlySpaceForOne

elif [ $OHDISKSPACE -ge $CLIENTONLY ]

then

/usr/bin/echo ClientOnly

else

/usr/bin/echo NoSpace

else

/usr/bin/echo OHNotValid

else

/usr/bin/echo OHNotSpecified

可能返回的各类结果:

ReturnValue Action

----------------------------------------------------------------------

OnlySpaceForOne %40% has sufficient free disk space to

install the 10g software but not enough to create

a database.

ClientOnly %40% only has sufficient free disk space to

do a client installation.

NoSpace %40% has insufficient free disk space

to do a 10g install.

OHNotFound Disk space calculations cannot be performed

since $ORACLE_HOME is not a valid directory

17. 环境变量AIXTHREAD_SCOPE是否设置为S，Oracle推荐设置AIX操作系统上特有的参数，以获取更佳的性能:

if /usr/bin/test $AIXTHREAD_SCOPE

then

if [ $AIXTHREAD_SCOPE = "S" ]

then

/usr/bin/echo AIXTHREAD_SCOPEOK

else

/usr/bin/echo AIXTHREAD_SCOPEBad

else

/usr/bin/echo AIXTHREADNotSet

若结果为AIXTHREADNotSet则可以在该用户的profile中指定"export AIXTHREAD_SCOPE=S"。

18.保证未设置LINK_CNTRL环境参数:

if /usr/bin/test $LINK_CNTRL

then

/usr/bin/echo LINK_CNTRLBad

else

/usr/bin/echo LINK_CNTRLunset

若设置了该操作可能导致程序link阶段出错，通过unset LINK_CNTRL命令重置该变量。

19.验证是否有足够的物理内存，若物理内存小于1023MB则不通过:

MEM=`/usr/sbin/lsattr -HE -l sys0 -a realmem | /usr/bin/sed '1d' | /usr/bin/awk '{print $2}'`

MEM=`/usr/bin/expr $MEM / 1024`

/usr/bin/echo $MEM

20.配置的交换空间是对比物理内存是否合理:

if /usr/bin/test %130%

then

if [ %130% -lt 1610 ]

then

/usr/bin/echo InsufficientSwap

else

if [ %140% -gt 0 ]

then

if [ %140% -gt 1024 -a %140% -lt 2048 ]

then

if [ %130% -lt `/usr/bin/expr %140% \* 3 / 2` ]

then

/usr/bin/echo SwapLessThanRAM

else

/usr/bin/echo SwapToRAMOK

elif [ %140% -gt 2049 -a %140% -lt 8192 ]

then

if [ %130% -lt %140% ]

then

/usr/bin/echo SwapLessThanRAM

else

/usr/bin/echo SwapToRAMOK

else [ %140% -gt 8192 ]

if [ %130% -lt `/usr/bin/expr %140% \* 3 / 4` ]

then

/usr/bin/echo SwapLessThanRAM

else

/usr/bin/echo SwapToRAMOK

else

/usr/bin/echo MemNotDetermined

else

/usr/bin/echo SwapNotDetermined

Oracle推荐Swap空间至少同主机上的物理内存大小一致，若小于则建议扩展该交换空间，可能返回的各类结果:

ReturnValue Action

--------------------------------------------------------------------

SwapNotDetermined ALERT- A Swap to Memory ratio cannot be

determined because swap has not been setup or

you do not have execute permission to

determine swap

SwapLessThanRAM ALERT- Swap space is less than the physical

memory. Set swap space at least the same

size as the physical memory

InsufficientSwap ALERT- 10g RDBMS requires at least 1.5 Gb of swap

space

MemNotDetermined ALERT- A Swap to Memory ratio cannot be

determined because you do not have execute

permission to determine the physical memory

21.ld,nm,ar,make等编译工具是否可用，若不可能则在安装的编译阶段可能出错:

ARFOUND=false

LDFOUND=false

NMFOUND=false

MAKEFOUND=false

arvalue=`/usr/bin/which ar`

if /usr/bin/test -h $arvalue

then

arvalue=`/usr/bin/ls -l $arvalue | /usr/bin/awk '{print $11}' | /usr/bin/awk -F* '{print $1}'`

if [ "$arvalue" != "/usr/ccs/bin/ar" ]

then

/usr/bin/echo ArFoundInPath

else

ARFOUND=true

ldvalue=`/usr/bin/which ld`

if /usr/bin/test -h $ldvalue

then

ldvalue=`/usr/bin/ls -l $ldvalue | /usr/bin/awk '{print $11}' | /usr/bin/awk -F* '{print $1}'`

if [ "$ldvalue" != "/usr/ccs/bin/ld" ]

then

/usr/bin/echo LdFoundInPath

else

LDFOUND=true

nmvalue=`/usr/bin/which nm`

if /usr/bin/test -h $nmvalue

then

nmvalue=`/usr/bin/ls -l $nmvalue | /usr/bin/awk '{print $11}' | /usr/bin/awk -F* '{print $1}'`

if [ "$nmvalue" != "/usr/ccs/bin/nm" ]

then

/usr/bin/echo NmFoundInPath

else

NMFOUND=true

makevalue=`/usr/bin/which make`

if /usr/bin/test -h $makevalue

then

makevalue=`/usr/bin/ls -l $makevalue | /usr/bin/awk '{print $11}' | /usr/bin/awk -F* '{print $1}'`

if [ "$makevalue" != "/usr/ccs/bin/make" ]

then

/usr/bin/echo MakeFoundInPath

else

MAKEFOUND=true

if [ $ARFOUND = true -a $LDFOUND = true -a $NMFOUND=true -a $MAKEFOUND = true ]

then

/usr/bin/echo ld_nm_ar_make_found

一般来说这些编译工具不会丢失，但若在您的系统中它们不见了，则需要联系系统管理人员重新安装上，可能的各类结果:

ReturnValue Action

---------------------------------------------------------------------

ArFoundInPath ar is found in PATH but not in /usr/ccs/bin or symbolically linked to /usr/ccs/bin as

required

LdFoundInPath ld is found in PATH but not in /usr/ccs/bin or symbolically linked to /usr/ccs/bin as

required

NmFoundInPath nm is found in PATH but not in /usr/ccs/bin or symbolically linked to /usr/ccs/bin as

required

MakeFoundInPath make is found in PATH but not in /usr/ccs/bin or symbolically linked to /usr/ccs/bin as

required

22.ulimit相关的参数是否设置合理其中包括stack size,open files等重要参数:

TIMEOK=false

TIME=`/usr/bin/ulimit -t`

if /usr/bin/test -z "$TIME"

then

/usr/bin/echo TimeNotDef

elif [ $TIME != "unlimited" ]

then

/usr/bin/echo TimeTooSmall

else

TIMEOK=true

FILEOK=false

FILE=`/usr/bin/ulimit -f`

if /usr/bin/test -z "$FILE"

then

/usr/bin/echo FileNotDefined

elif [ $FILE != "unlimited" ]

then

/usr/bin/echo FileTooSmall

else

FILEOK=true

DATAOK=false

DATA=`/usr/bin/ulimit -d`

if /usr/bin/test -z "$DATA"

then

/usr/bin/echo DataNotDefined

elif [ $DATA = "unlimited" ]

then

DATAOK=true

elif [ $DATA -ge 1048576 ]

then

DATAOK=true

else

/usr/bin/echo DataTooSmall

STACKOK=false

STACK=`/usr/bin/ulimit -s`

if /usr/bin/test -z "$STACK"

then

/usr/bin/echo StackNotDefined

elif [ $STACK = "unlimited" ]

then

STACKOK=true

elif [ $STACK -ge 32768 ]

then

STACKOK=true

else

/usr/bin/echo StackTooSmall

NOFILESOK=false

NOFILES=`/usr/bin/ulimit -n`

if /usr/bin/test -z "$NOFILES"

then

/usr/bin/echo NoFilesNotDefined

elif [ $NOFILES = "unlimited" ]

then

NOFILESOK=true

elif [ $NOFILES -ge 4096 ]

then

NOFILESOK=true

else

/usr/bin/echo NoFilesTooSmall

MEMORYOK=false

MEMORY=`/usr/bin/ulimit -m`

if /usr/bin/test -z "$MEMORY"

then

/usr/bin/echo MemoryNotDefined

elif [ $MEMORY = "unlimited" ]

then

MEMORYOK=true

elif [ $MEMORY -ge 2045680 ]

then

MEMORYOK=true

else

/usr/bin/echo MemoryTooSmall

if [ $TIMEOK = true -a $FILEOK = true -a $DATAOK = true -a $STACKOK = true -a $NOFILESOK = true -a $MEMORYOK = true ]

then

/usr/bin/echo ulimitOK

若未返回ulimitOK,则需要针对不同的结果修改/etc/security/limits.conf中当前用户相关的条目，各类不同的返回结果:

Return value Action required

----------------------------------------------------------------------

TimeNotDef ulimit(TIME) has not been defined

TimeTooSmall Increase the ulimit(TIME) to unlimited

FileNotDefined ulimit(FILE) has not been defined"

FileTooSmall Increase the ulimit(FILE) to unlimited

DataNotDefined ulimit(DATA) has not been defined

DataTooSmall Increase the ulimit(DATA) to at least 1048576

StackNotDefined ulimit(STACK) has not been defined

StackTooSmall Increase the ulimit(STACK) to at least 32768

NoFilesNotDefined ulimit(NOFILES) has not been defined

NoFilesTooSmall Increase the ulimit(NOFILES) to at least 4096

MemoryNotDefined ulimit(MEMORY) has not been defined

MemoryTooSmall Increase the ulimit(MEMORY) to at least 2045680

23.此外一般大型的OLTP系统都需要运行成百上千的服务进程，AIX中单个用户同时能运行的进程数受到系统对象sys0的maxuproc属性限制，一般我们需要修改该参数:

/* 列出当前sys0的maxuproc设置 */

$ lsattr -El sys0|grep maxuproc|cut -c 1-20

maxuproc 128

/* root用户可以修改该属性 */

chdev -l sys0 -a maxuproc=4096

24.配置合理的AIX Virtual Memeory参数，这些参数可能包括maxperm,minperm等，以下为IBM给出的推荐设置:

minperm%=3

maxperm%=90

maxclient%=90

lru_file_repage=0

strict_maxperm=0

strict_maxclient=1

page_steal_method=1

可以通过以下命令完成配置:

#!/usr/bin/ksh

vmo -p -o maxperm%=90;

vmo -p -o minperm%=3;

vmo -p -o maxclient%=90;

vmo -p -o strict maxperm=0;

vmo -p -o strict maxclient=1;

vmo -p -o lru_file_repage=0;

vmo -r -o page_steal_method=1; (need to reboot to take into effect)

vmo -p -o strict_maxclient=1

vmo -p -o strict_maxperm=0;

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)

也可以参考VMM Tuning Tip: Protecting Computational Memory at http://www.ibm.com/developerworks/wikis/download/attachments/53871915/VMM+Tuning+Tip+-+Proctecting+Comp+Memory.pdf?version=2

25.配置系统对象中的I/O pacing限制，在AIX 6.1中自动完成，而在5.3上我们需要手动修改sys0：

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

# smitty chgsys

# chdev -l sys0 -a minpout=8 -a maxpout=12

to be continued.......

当年流水

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
安装oracle数据库物理内存不够,AIX操作系统上安装Oracle数据库必不可少的几项检查工作...

一直以来在UNIX/Linux like操作系统上安装Oracle数据库软件都是一门精细活，在实际安装软件前有不少操作系统参数或配置需要我们关心。我们以10g release 2为例，尽可能完整地列出所有有必要的预检查工作。1.确认使用的AIX版本经过认证，AIX 5.2之前的版本包括5.1都没有通过Oracle 10g的认证，换而言之如果你要安装10g的话就要保证AIX的版本>=5.2，我...
复制链接

扫一扫