当前位置导航:炫浪网>>网络学院>>编程开发>>Oracle教程

Oracle10G R2(10.2.0.1)在AIX5.2.0.4(64bit)上的安装


  主机环境
  
  # lsdev -Cc processor
  proc0 Available 00-00 Processor
  proc1 Available 00-01 Processor
  proc2 Available 00-02 Processor
  proc3 Available 00-03 Processor
  proc4 Available 00-04 Processor
  proc5 Available 00-05 Processor
  proc6 Available 00-06 Processor
  proc7 Available 00-07 Processor
  proc8 Available 00-08 Processor
  proc9 Available 00-09 Processor
  proc10 Available 00-10 Processor
  proc11 Available 00-11 Processor
  
  # lsdev -Cc memory
  L2cache0 Available L2 Cache
  mem0   Available Memory
  # lsattr -El mem0
  goodsize 8192 Amount of usable physical memory in Mbytes False
  size   8192 Total amount of physical memory in Mbytes False
  # lsattr -El L2cache0
  size 16384 Size of L2 cache in Kbytes False
  #
  
  下载完毕3个文件,database,comp , cluster ,准备ftp上传到服务器上,提示超过file size limit,惨啊,穿了好久居然要出错,还要重传
  
  # ulimit -a
  time(seconds)    unlimited
  file(blocks)     2097151
  data(kbytes)     131072
  stack(kbytes)    32768
  memory(kbytes)    32768
  coredump(blocks)   2097151
  nofiles(descriptors) 2000
  
  # ulimit -Ha
  time(seconds)    unlimited
  file(blocks)     2097151
  data(kbytes)     unlimited
  stack(kbytes)    4194304
  memory(kbytes)    unlimited
  coredump(blocks)   unlimited
  nofiles(descriptors) unlimited
  
  修改参数限制,file和stack需要在/etc/security/limits中修改了
  
  # ulimit unlimited
  # ulimit -a
  time(seconds)    unlimited
  file(blocks)     unlimited
  data(kbytes)     131072
  stack(kbytes)    32768
  memory(kbytes)    32768
  coredump(blocks)   2097151
  nofiles(descriptors) 2000
  # ulimit -Ha
  time(seconds)    unlimited
  file(blocks)     unlimited
  data(kbytes)     unlimited
  stack(kbytes)    4194304
  memory(kbytes)    unlimited
  coredump(blocks)   unlimited
  nofiles(descriptors) unlimited
  
  这里有点不明白,为什么说soft limit不能超过hard limit的,为什么我一条命令就把两个的输出都变成unlimited了
  
  # ulimit -s unlimited
  # ulimit -a
  time(seconds)    unlimited
  file(blocks)     unlimited
  data(kbytes)     131072
  stack(kbytes)    unlimited
  memory(kbytes)    32768
  coredump(blocks)   2097151
  nofiles(descriptors) 2000
  # unlimit -d unlimited
  ksh: unlimit: not found.
  # unlimit -d unlimited
  ksh: unlimit: not found.
  # ulimit -d unlimited
  # ulimit -m unlimited
  # ulimit -a
  time(seconds)    unlimited
  file(blocks)     unlimited
  data(kbytes)     unlimited
  stack(kbytes)    unlimited
  memory(kbytes)    unlimited
  coredump(blocks)   2097151
  nofiles(descriptors) 2000
  
  # gunzip 10gr2_aix5l64_database.cpio.gz
  # cpio -idcmv <10gr2_aix5l64_database.cpio
  
  扩大tmp和home的空间
  lslpp -l 检查这些包安装了没有
  bos.adt.base
  bos.adt.lib
  bos.adt.libm
  bos.perf.libperfstat
  bos.perf.perfstat
  bos.perf.proctools
  xlC.aix50.rte:7.0.0.4 or later
  xlC.rte:7.0.0.1 or later
  
  下载aix5.2.0.4需要的补丁
  All installations Authorized Problem Analysis Reports (APARs) for AIX 5L v5.2
  
  ML 04:
  ■ IY63133: large percentage of CPU time spent in ldata_balance
  
  routine
  ■ IY64978: deadlock with concurrent renaming and unlinking
  
  under JFS
  ■ IY63366: dlsym returns null even for valid symbol in AIX520
  
  ML-4
  ■ IY64691: chvg -b can cause corruption and crash
  ■ IY64737: AIO can hang in knotunlock
  ■ IY65001: mklvcopy on a striped lv is failing to update lvcb
  
  这里描述了oracle10g和aix需要的一些软件的信息
  <https://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=282036.1>
  
  建立oinstall dba 组,建立oracle用户,主组为oinstall,group set包含dba
  smitty chuser 改变oracle用户的soft ulimit data stack file cpu 为-l
  smitty chgsys改用户的最大进程数为2048
  
  建立目录结构
  
  # mkdir -p /home/oracle/product/10.2
  # chown -R oracle:oinstall /home/oracle/product/10.2
  # chmod -R 755 /home/oracle/product/10.2
  
  配置文件内容
  
  umask 022
  ORACLE_SID=orcl; export ORACLE_SID
  ORACLE_BASE=/home/oracle; export ORACLE_BASE
  ORACLE_HOME=$ORACLE_BASE/product/10.2; export ORACLE_HOME
  AIXTHREAD_SCOPE=S; export AIXTHREAD_SCOPE
  PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:.
  
  export PATH
  
  if [ -s "$MAIL" ]      # This is at Shell startup. In normal
  then echo "$MAILMSG"    # operation, the Shell checks
  fi             # periodically.
  
  将多个补丁放在一个目录中smitty update_all安装,选择保存旧文件和不提交
  
  $ ./runInstaller
  **************************************************************************
  
  Your platform requires the root user to perform certain pre-installation
  OS preparation. The root user should run the shell script 'rootpre.sh' be
  fore
  you proceed with Oracle installation. rootpre.sh can be found at the top
  level
  of the CD or the stage area.
  
  Answer 'y' if root has run 'rootpre.sh' so you can proceed with Oracle
  installation.
  Answer 'n' to abort installation and then ask root to run 'rootpre.sh'.
  
  **************************************************************************
  
  Has 'rootpre.sh' been run by root? [y/n] (n)
  
  # ./rootpre.sh
  ./rootpre.sh output will be logged in /tmp/rootpre.out_05-11-30.10:25:15
  Saving the original files in /etc/ora_save_05-11-30.10:25:15....
  Copying new kernel extension to /etc....
  Loading the kernel extension from /etc
  
  Oracle Kernel Extension Loader for AIX
  Copyright (c) 1998,1999 Oracle Corporation
  
  Successfully loaded /etc/pw-syscall.64bit_kernel with kmid: 0x75c3900
  Successfully configured /etc/pw-syscall.64bit_kernel with kmid: 0x75c3900
  The kernel extension was successfuly loaded.
  
  Configuring Asynchronous I/O....
  
  Configuring POSIX Asynchronous I/O....
  
  Checking if group services should be configured....
  Nothing to configure.
  
  然后剩下的都是图形界面的选择了,好像10gR2的安装比以前的9i等简单得多了,profile文件中居然没写什么也没有安装错误。
相关内容
赞助商链接