成功安装oracle9i(software only),然后我想建一个数据库,先用dbca建的时候因为默认方式它会分配很大的空间(800M),如果改了参数总是建不成功.所以我在sqlplus中用以下命令来试:
create database "test"
controlfile reuse
logfile group1
('/opt/oracle/product/9.0.1/oradata01/test/redo0101.log',
'/opt/oracle/product/9.0.1/oradata01/test/redo0102.log') size 5M reuse ,
group2
('/opt/oracle/product/9.0.1/oradata01/test/redo0201.log',
'/opt/oracle/product/9.0.1/oradata01/test/redo0201.log') size 5M reuse
maxlogfile 4
maxlogmember 2
maxloghistory 0
maxdatafiles 254
maxinstances 1
noarchivelog
datafile '/opt/oracle/product/9.0.1/oradata01/test/test.dbf' size 80M
autoextend on next 5M maxsize unlimited;
sql语法都对,而且目录都有权限的,因为该命令执行了.但是最后报connect fail
文件都生成了,但是数据苦起不来,请各位帮我分析一把谢谢!