Chinaunix

标题: 手工建库 [打印本页]

作者: RomanHeart 时间: 2007-09-29 16:01
标题: 手工建库
oracle 10g 手工建的时候,会有这样的情况:
指定log 位置会报错,为什么呢?

作者: numenhuang 时间: 2007-09-29 16:10
文件目录Oracle是否有读写权限

贴出脚本

作者: RomanHeart 时间: 2007-09-29 16:37
标题: 是这样的
ORA-01092: ORACLE 实例终止。强制断开连接
ORA-00447: fatal error in background process
ORA-01519: error while processing file '' near line
ORA-01501: CREATE DATABASE ??
ORA-01519: ????? '%ORACLE_HOME%\RDBMS\ADMIN\SQL.BSQ' ???? 5253 ???
ORA-00604: ?? SQL ?? 2 ????
ORA-00942: ???????

建立数据库时用如下语句 :
create database base
maxlogfiles 30
maxlogmembers 3
maxinstances 8
maxdatafiles 60
maxloghistory 100
logfile
'f:\log1base.dbf' size 10m,
'f:\log2base.dbf' size 10m,
'f:\log3base.dbf' size 10m
datafile 'f:\sysbase.dbf' size 10m
sysaux datafile 'f:\auxbase.dbf' size 10m
undo tablespace UNDOTBS1 datafile 'f:\undobase.dbf' size 10m
/

作者: numenhuang 时间: 2007-09-29 17:11
datafile 'f:\sysbase.dbf' size 10m
改成
DATAFILE 'f:\system01.dbf' SIZE 30M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED

作者: RomanHeart 时间: 2007-09-29 21:22
datafile 没问题
当有这段logfile
'f:\log1base.dbf' size 10m,
'f:\log2base.dbf' size 10m,
'f:\log3base.dbf' size 10m
时会有错,拿掉就没有错

作者: numenhuang 时间: 2007-09-30 09:21
logfile group 1
'f:\log1base.dbf' size 10m,
'f:\log2base.dbf' size 10m,
'f:\log3base.dbf' size 10m
------------->
LOGFILE GROUP 1 ('f:\log1_1.log') SIZE 5M,
GROUP 2 ('f:\log2_1.log') SIZE 5M,
GROUP 3 ('f:\log2_1.log') SIZE 5M

作者: tinysnow 时间: 2007-09-30 17:14
标题: 回复 #1 RomanHeart 的帖子
Hi, numenhuang :

you are right !,

>>
logfile group 1
'f:\log1base.dbf' size 10m,
'f:\log2base.dbf' size 10m,
'f:\log3base.dbf' size 10m
------------->
LOGFILE GROUP 1 ('f:\log1_1.log') SIZE 5M,
GROUP 2 ('f:\log2_1.log') SIZE 5M,
GROUP 3 ('f:\log2_1.log') SIZE 5M

<<

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)