设为首页
加入收藏夹

在AIX上安装ORACLE 8.1.6
浏览选项:

  1.将异步I/O设为Available ( #smit aio )
  2.建文件系统/oracle,挂在rootvg下,大小为1GB即2000000 byte(512BYTE/BLOCK)
  3.建/cdrom文件系统
  4.建/oradata文件系统,大小约6.5GB(必须为大文件系统) 挂到datavg下。
  5.#mount /oracle8
  #mount /cdrom
  #mount /oradata
  6.建组及用户,组名必须为“dba”,id=280;
  用户名起为“oracle”
  uid=280,gid=280
  HOME-Directory=/oracle
  SHELL=/usr/bin/ksh
  7. #chown oracle:dba /oracle8
  #login oracle
  $vi .profile
  ORACLE_HOME=/oracle/app/oracle/product/8.0.6;export ORACLE_HOME
  ORAWEB_HOME=/oracle/app/oracle/product/8.0.6/ows/4.0;export ORAWEB_HOME
  ORACLE_OWNER=oracle;export ORACLE_OWNER
  ORACLE_SID=ora8;export ORACLE_SID
  ORA_NLS32=$ORACLE_HOME/ocommon/nls/admin/data;export ORA_NLS32
  LD_LIBRARY_PATH=$ORACLE_HOME/lib;export LD_LIBRARY_PATH
  ORACLE_TERM=3151;export ORACLE_TERM
  TMPDIR=/oracle/tmp;export TMPDIR
  NLS_LANG=AMERICAN_AMERICA.US7ASCII;export NLS_LANG
  EPC_DISBLED=TRUE; export EPC_DISBLED
  TERM=ibm3151;export TERM
  PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sb
  注:所有的安装完毕后,将NLS_LANG前的#号去掉,并使其有效
  8. 运行.profile文件,使oracle用户的环境变量有效
   $. ./.profile
  9. 用env命令查看环境变量是否生效
  10. $su root
   # ./cdrom/orainst/rootpre.sh
   # export ORACLE_OWNER=oracle
   # ./cdrom/orainst/oratab.sh
   #exit
   $ mkdir /oracle/tmp
   $ ./cdrom/orainst/orainst
  11. 进入安装界面后:
  n选择“DEFAULT INSTALL”
  nwellcom 菜单-------OK
  nwellcom 菜单(续)-------OK
  n选择Install,upgrade,or De-Install Software

  nInstall New product-Do not Creat DB
  n安装路径----------------OK
  nRootpre.sh----------------Yes
  nRelink---------------------Yes
  n选项确认菜单----------------OK
  n选择安装产品:
  Net8
  Tcp/ip protocol adapter
  Oracle on-line text viewer
  Oracle objects option
  Oracle partitioning
  Oracle unix install
  Oracle enterprise
  PL/SQL
  Pro*c/c++
  SQL*PLUS
  nLegato---------------------No
  nroot.sh--------------------OK
  n安装完成后退出
  n在$ORACLE_HOME/orainst目录下运行
  ./orainst
  n选择 CUSTUM INSTALL
  nwellcom 菜单-------OK
  nwellcom 菜单(续)-------OK
  nCreate/upgrade Database Objects
  nCreate Database Objects
  n/oracle
  n8.0.6
  n安装路径----------------OK
  nlog and status-------------OK
  nrootpre.sh-------------------Yes
  nora8
  nDuplicate SID--------------------------------------Yes
  n选择安装产品时---------------全选
  nMTS--------------------------No
  nCreate product Objects
  nFilesystem-base Database
  nThree mount point------------No
  nMount point------------------/hitdata
  n语言-------------------------US7ASCII
  n(SYS、SYSTEM)password---------------------oracle
  ninternal users---------------No
  nTNS password-----------------oracle
  nControl file-----------------Yes
  nDB default-------------------OK
  nDefault Database-------------No
  n设置系统表空间大小
  system tablespace 80M
  redo1 500K
  redo2 500K
  redo3 500K
  rollback 200M
  temp 200M
  user 1M
  tools 25M
  nDB default-------------------OK
  nDefault Database-------------Yes
  nSQL*PLUS---------------------Yes
  nSQL*PLUS Demo----------------Yes
  nFree space-------------------------------Yes
  n安装完成后退出
  n在$ORACLE_HOME/orainst目录下以root身份运行
  ./root.sh
  Are these setting(Y/N)Y
  Enter the full path(usr/bin)回车
  Okay to continue?(N)Y
  n编辑 /etc/oratab文件
  将ora8:/oracle8/app/oracle/product/8.0.6:N这行中的N改为Y
  启动与关闭数据库:
  使用批命令:
   启动:dbstart
   关闭:dbshut
  手工启动:
   启动:$svrmgrl    SVRMGR>connect internal
   >startup
   >exit
   关闭:$svrmgrl    SVRMGR>connect internal
   >shutdown
   >exit
  验证:$svrmgrl    SVRMGR>connect internal
   >show sga (有内容)
  配置SQL*NET
  1. 编辑文件:/etc/services
   vi /etc/services
   加入一行:listener 1521/tcp
  2.以ORACLE帐号登录进入系统,在 $ORACLE_HOME/network/admin目录下编辑文件
  启动/停止服务器端listener,运行命令:
  $ lsnrctl start
  $ lsnrctl stop
  3.编辑文件:/etc/inittab,加入:    ora8:2:once:su - oracle -c dbstart > /dev/console 2>&1
  lsnr:2:once:su - oracle -c lsnrctl start > /dev/console 2>&1





Copyright © 2004 wanxu.com All Rights Reserved