手动安装数据库的怪问题,一定要高手
用下列语句创建数据库,报错,查看eventlog,报control1.ora文件打不开或者找不到,但是已经创建拉,明明有的。
下面语句应该没有问题,因为在别的机器上都成功的,
reate database PCDG
controlfile reuse
logfile
group 1
( 'C:\Oradata\PCDG\LOG1A.ORA'
, 'D:\Oradata\PCDG\LOG1B.ORA'
)
size 25M
,
group 2
( 'C:\Oradata\PCDG\LOG2A.ORA'
, 'D:\Oradata\PCDG\LOG2B.ORA'
)
size 25M
,
group 3
( 'C:\Oradata\PCDG\LOG3A.ORA'
, 'D:\Oradata\PCDG\LOG3B.ORA'
)
size 25M
force logging
noarchivelog
maxlogfiles 32
maxlogmembers 5
maxdatafiles 254
maxinstances 8
maxloghistory 1000
character set UTF8
national character set UTF8
datafile 'C:\Oradata\PCDG\SYSTEM1.ORA'
size 200M
extent management local
default temporary
tablespace temp
tempfile 'D:\Oradata\PCDG\TEMP1.ORA'
size 400M
uniform size 1M
undo tablespace undotbs1
datafile 'D:\Oradata\PCDG\UNDOTBS1.ORA'
size 300M
;
alter database
datafile 'C:\Oradata\PCDG\SYSTEM1.ORA'
autoextend on
next 50M
maxsize 500M
;
create tablespace tools
permanent
datafile 'D:\Oradata\PCDG\TOOLS1.ORA'
size 50M
extent management local
segment space management auto
;
alter database
datafile 'D:\Oradata\PCDG\TOOLS1.ORA'
autoextend on
next 50M
maxsize 400M
;
alter user sys
temporary
tablespace temp
;
alter user system
default
tablespace tools
temporary
tablespace temp
;