| | |
| | |
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
| |
|
|
| |
| |
|