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:/sbin:$PATH:$ORACLE_HOME/bin:.;export PATH
注:所有的安装完毕后,将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.ora其内容在/hitdata/software/fd下。
启动/停止服务器端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
相关文章 |
|
热门文章 |
|
|
|
--------------------next---------------------
阅读(356) | 评论(0) | 转发(0) |
| |