AI 助理
备案控制台
开发者社区 数据库 文章 正文

AIX操作系统上安装Oracle数据库必不可少的几项检查工作

2017-11-12 1112
版权
版权声明：
本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《 阿里云开发者社区用户服务协议》和 《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写 侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
简介：
一直以来在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"
fi
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"
          fi
          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"
          fi
          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"
          fi
          ;;
       *)
        /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"
  do
    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
         fi
      fi
    else
      /usr/bin/echo "$PACKAGE"NotInstalled
      OSpackagesOK=false
    fi
  done
else
  /usr/bin/echo "NoAccess"

  OSpackagesOK=false
fi
if [ $OSpackagesOK = true ]
then
   /usr/bin/echo "All required OS packages are installed"
fi

若以上脚本未返回"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"
fi
if test -x /usr/sbin/instfix
then
  if [ $OSVER4CHAR -eq "5200" ]
  then
    for PATCH in IY63133 IY64978 IY63366 IY64691 IY64737 IY65001
    do
      if [ `/usr/sbin/instfix -ik $PATCH 2>&1 | /usr/bin/grep -ic "no"` != 0 ]
      then
        /usr/bin/echo "$PATCH"_NotInstalled
        OSpatchesOK=false
      fi
    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
    fi
  elif [ $OSVER4CHAR -eq "5300" ]
    then
    for PATCH in IY58143 IY59386 IY60930 IY66513 IY70159
    do
      if [ `/usr/sbin/instfix -ik $PATCH 2>&1 | /usr/bin/grep -ic "no"` != 0 ]
      then
        /usr/bin/echo "$PATCH"_NotInstalled
        OSpatchesOK=false
      fi
    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
    fi
  fi
else
  /usr/bin/echo "NoAccess"

  OSpatchesOK=false
fi
if [ $OSpatchesOK = true ]
then
   /usr/bin/echo "PatchesFound"
fi

若返回的结果不为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."

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

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"

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

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"
      fi
   else
      /usr/bin/echo OHnotvalid
   fi
else
  /usr/bin/echo "OHNotSpecified"
fi

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

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
    fi
    if /usr/bin/test -w %40%
    then
      WRITEPERMISSION=true
    else
      /usr/bin/echo NoWritePerm
    fi
    if /usr/bin/test -x %40%
    then
      EXECUTEPERMISSION=true
    else
      /usr/bin/echo NoExecutePerm
    fi
  else
    /usr/bin/echo OHNotExist
  fi
else
  /usr/bin/echo OHNotSpecified
fi
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
  fi
fi

若未设置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
fi

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

if /usr/bin/test $LD_LIBRARY_PATH
then
  /usr/bin/echo IsSet
else
  /usr/bin/echo UnSet
fi

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

if /usr/bin/test $LIBPATH
then
  /usr/bin/echo IsSet
else
  /usr/bin/echo UnSet
fi

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

NoneFound=true
if /usr/bin/test -f /etc/oratab
then
  for FILE in /etc/oratab
  do
    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`
    do
      for ENVPATHS in PATH
      do
        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
          fi
        fi
      done
    done
  done
fi
if [ $NoneFound = true ]
then
  /usr/bin/echo NoneFound
fi

一般结果都为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
    fi
  else
    /usr/bin/echo oraInventoryNotOK
  fi
else
  /usr/bin/echo oraInventoryNotFound
fi

可能返回的各类结果:

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
   fi
fi
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
      fi
   fi
else
  /usr/bin/echo invalidDIR
fi
if /usr/bin/test $TMPDIR
then
   TMPDIRLOC=$TMPDIR
else
   TMPDIRLOC=/var/tmp
fi
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
      fi
   fi
else
   /usr/bin/echo invalidDIR
fi
if [ $tmpOK = true -a $vartmpOK = true ]
then
  /usr/bin/echo TempSpaceOK
fi

/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
  fi
else
  /usr/bin/echo "ALERT- SWAP space cannot be determined"
fi

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
fi

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
    fi
  else
    /usr/bin/echo OHNotValid
  fi
else
  /usr/bin/echo OHNotSpecified
fi

可能返回的各类结果:

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
  fi
else
  /usr/bin/echo AIXTHREADNotSet
fi
若结果为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
fi

若设置了该操作可能导致程序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
        fi
      elif [ %140% -gt 2049 -a %140% -lt 8192 ]
      then
        if [ %130% -lt %140% ]
        then
          /usr/bin/echo SwapLessThanRAM
        else
          /usr/bin/echo SwapToRAMOK
        fi
      else [ %140% -gt 8192 ]
        if [ %130% -lt `/usr/bin/expr %140% \* 3 / 4` ]
        then
          /usr/bin/echo SwapLessThanRAM
        else
          /usr/bin/echo SwapToRAMOK
        fi
      fi
    else
      /usr/bin/echo MemNotDetermined
    fi
  fi
else
  /usr/bin/echo SwapNotDetermined
fi

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}'`
fi
if [ "$arvalue" != "/usr/ccs/bin/ar" ]
then
  /usr/bin/echo ArFoundInPath
else
  ARFOUND=true
fi
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}'`
fi
if [ "$ldvalue" != "/usr/ccs/bin/ld" ]
then
  /usr/bin/echo LdFoundInPath
else
  LDFOUND=true
fi
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}'`
fi
if [ "$nmvalue" != "/usr/ccs/bin/nm" ]
then
  /usr/bin/echo NmFoundInPath
else
  NMFOUND=true
fi
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}'`
fi
if [ "$makevalue" != "/usr/ccs/bin/make" ]
then
  /usr/bin/echo MakeFoundInPath
else
  MAKEFOUND=true
fi
if [ $ARFOUND = true -a $LDFOUND = true -a $NMFOUND=true -a $MAKEFOUND = true ]
then
  /usr/bin/echo ld_nm_ar_make_found
fi

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

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
fi
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
fi
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
fi
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
fi
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
fi
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
fi
if [ $TIMEOK = true -a $FILEOK = true -a $DATAOK = true -a $STACKOK = true -a $NOFILESOK = true -a $MEMORYOK = true ]
then
/usr/bin/echo ulimitOK
fi

若未返回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.......



本文转自maclean_007 51CTO博客，原文链接:http://blog.51cto.com/maclean/1277576

文章标签：
关系型数据库
Perl
Unix
Oracle
数据库
关键词：
安装数据库
数据库安装
oracle数据库
数据库oracle
Oracle数据库一键上云数据库
科技小能手
目录
相关文章
Apache_Tomcat_Nignx
|
24天前
|
关系型数据库 MySQL Linux
MySQL数据库下载安装教程（Windows&Linux）
本文档详细介绍了MySQL的安装步骤，包括安装前的准备工作、下载安装包、Windows和Linux系统下的具体安装流程，以及如何配置MySQL服务、设置环境变量、启动服务和连接数据库等关键操作。
Apache_Tomcat_Nignx
381 4
三三是该溜子
|
3天前
|
SQL Java 数据库连接
JDBC编程安装———通过代码操控数据库
本文，教你从0开始学习JBCD，包括驱动包的下载安装调试设置，以及java是如何通过JBDC实现对数据库的操作，以及代码的分析，超级详细
三三是该溜子
11 0
小王老师呀
|
1月前
|
SQL 存储 Linux
从配置源到数据库初始化一步步教你在CentOS 7.9上安装SQL Server 2019
【11月更文挑战第16天】本文介绍了在 CentOS 7.9 上安装 SQL Server 2019 的详细步骤，包括配置系统源、安装 SQL Server 2019 软件包以及数据库初始化，确保 SQL Server 正常运行。
小王老师呀
62 4
龙大吉
|
1月前
|
NoSQL Linux PHP
如何在不同操作系统上安装 Redis 服务器，包括 Linux 和 Windows 的具体步骤
本文介绍了如何在不同操作系统上安装 Redis 服务器，包括 Linux 和 Windows 的具体步骤。接着，对比了两种常用的 PHP Redis 客户端扩展：PhpRedis 和 Predis，详细说明了它们的安装方法及优缺点。最后，提供了使用 PhpRedis 和 Predis 在 PHP 中连接 Redis 服务器及进行字符串、列表、集合和哈希等数据类型的基本操作示例。
龙大吉
67 4
小王老师呀
|
1月前
|
SQL 存储 Linux
从配置源到数据库初始化一步步教你在CentOS 7.9上安装SQL Server 2019
【11月更文挑战第8天】本文介绍了在 CentOS 7.9 上安装 SQL Server 2019 的详细步骤，包括系统准备、配置安装源、安装 SQL Server 软件包、运行安装程序、初始化数据库以及配置远程连接。通过这些步骤，您可以顺利地在 CentOS 系统上部署和使用 SQL Server 2019。
小王老师呀
88 1
小王老师呀
|
1月前
|
SQL 存储 Linux
从配置源到数据库初始化一步步教你在CentOS 7.9上安装SQL Server 2019
【11月更文挑战第7天】本文介绍了在 CentOS 7.9 上安装 SQL Server 2019 的详细步骤，包括系统要求检查与准备、配置安装源、安装 SQL Server 2019、配置 SQL Server 以及数据库初始化（可选）。通过这些步骤，你可以成功安装并初步配置 SQL Server 2019，进行简单的数据库操作。
小王老师呀
58 1
游客54bz4h3flp7ai
|
1月前
|
网络安全 数据库
gbase 8a 数据库 安装8ampp 常见ssh报错问题
gbase 8a 数据库 安装8ampp 常见ssh报错问题
游客54bz4h3flp7ai
28 0
小陈运维
|
1月前
|
运维 关系型数据库 MySQL
安装MySQL8数据库
本文介绍了MySQL的不同版本及其特点，并详细描述了如何通过Yum源安装MySQL 8.4社区版，包括配置Yum源、安装MySQL、启动服务、设置开机自启动、修改root用户密码以及设置远程登录等步骤。最后还提供了测试连接的方法。适用于初学者和运维人员。
小陈运维
190 0
土木林森
|
4月前
|
监控 Oracle 关系型数据库
"深度剖析：Oracle SGA大小调整策略——从组件解析到动态优化，打造高效数据库性能"
【8月更文挑战第9天】在Oracle数据库性能优化中，系统全局区（SGA）的大小调整至关重要。SGA作为一组共享内存区域，直接影响数据库处理能力和响应速度。本文通过问答形式介绍SGA调整策略：包括SGA的组成（如数据缓冲区、共享池等），如何根据负载与物理内存确定初始大小，手动调整SGA的方法（如使用`ALTER SYSTEM`命令），以及利用自动内存管理（AMM）特性实现智能调整。调整过程中需注意监控与测试，确保稳定性和性能。
土木林森
397 2
以山向海
|
5月前
|
存储 缓存 Oracle
Oracle数据库可扩展性和性能
【7月更文挑战第6天】
以山向海
98 7

热门文章

最新文章

  • 1
    MySQL数据库下载安装教程（Windows&Linux）
  • 2
    达梦数据库字段类型 varchar 转 text
  • 3
    Python处理数据库：MySQL与SQLite详解 | python小知识
  • 4
    使用 Spring Boot 执行数据库操作：全面指南
  • 5
    PolarDB 分布式版 V2.0，安全可靠的集中分布式一体化数据库管理软件
  • 6
    在云上轻松部署达梦数据库
  • 7
    活动实践 | 自建数据库迁移到云数据库
  • 8
    MySQL导入.sql文件后数据库乱码问题
  • 9
    数据库数据恢复—MYSQL数据库文件损坏的数据恢复案例
  • 10
    数据库的行级锁与表锁？
  • 1
    在Python中，利用`os模块`的`path.exists()`函数可判断文件是否存
    283
  • 2
    LabVIEW在不同操作系统上使VI、可执行文件或安装程序
    332
  • 3
    深入理解操作系统之进程调度策略
    69
  • 4
    深入理解操作系统的内存管理
    70
  • 5
    操作系统实战（一）（linux+C语言）
    133
  • 6
    LabVIEW什么是实时操作系统(RTOS)
    227
  • 7
    LabVIEW前面板上的字体大小取决于操作系统
    55
  • 8
    利用LangChain构建的智能数据库操作系统
    297
  • 9
    Linux操作系统下查找大文件或目录的技巧
    58
  • 10
    Solaris操作系统使用小技巧
    48

    • 相关课程

    更多
  • 数据库的前世今生
  • 数据库核心概念
  • 从传统数据库到云数据库演进
  • 数据库常见问题排查
  • 数据库及SQL/MySQL基础
  • 高校精品课-西安交通大学 -数据库理论与技术

    • 相关电子书

    更多
  • PostgresChina2018_樊文凯_ORACLE数据库和应用异构迁移最佳实践
  • PostgresChina2018_王帅_从Oracle到PostgreSQL的数据迁移
  • Oracle云上最佳实践

    • 相关实验场景

    更多
  • 使用DAS实现数据库SQL优化
  • 使用操作系统智能助手OS Copilot解锁操作系统运维与编程
  • 自建数据库迁移到云数据库
  • ECS操作系统无法登录诊断能力
  • ECS操作系统故障诊断能力
  • PolarDB for AI：在数据库中通过SQL实现AI能力

    • 推荐镜像

    更多
  • os-copilot
  • oracle
  • postgresql
    • 下一篇
    手把手教你白嫖阿里云服务器(免费领服务器)