ORA-01092:ORACLE instans treminated.Disconnection forced.

ora_linux

如题：ORA-01092:ORACLE instans treminated.Disconnection forced.
我create database的时候遇见的问题，哪位高手知道如何解答？！

remen

把你的脚本贴出来，还有你的日志文件！

ora_linux

create database test
controlfile reuse
logfile group 1 '/home/oracle/oradata/test/redo01.log' size 10m reuse,
group 2 '/home/oracle/oradata/test/redo02.log' size 10m reuse,
group 3 '/home/oracle/oradata/test/redo03.log' size 10m reuse
datafile '/home/oracle/oradata/test/test01.dbf' size 512m reuse autoextend on next 100m maxsize 1000m,
'/home/oracle/oradata/test/test02.dbf' size 512m reuse autoextend on next 100m maxsize 1000m
maxdatafiles 100
archivelog
character set UTF8
national character set UTF8
sysaux datafile '/home/oracle/oradata/test/sys01.dbf' size 230m autoextend on next 10m maxsize unlimited
undo tablespace undotbs1 datafile '/home/oracle/oradata/test/undo.dbf'
日志文件没有任何警告啊

remen

你的undo tablespace undotbs1 datafile '/home/oracle/oradata/test/undo.dbf'
怎么没有size?

txfy

bdump目录权限对吗？

txfy

Maybe you should use orapwd to create a password file.

ora_linux

那个size忘了贴出来。
bdump目录权限是什么意思，要怎么设置？

remen

日志文件没有任何警告？？
有内容吗？
如果有内容就不是权限的问题！

remen

cd $ORACLE_HOME/admin
ls -l bdump
给出结果

ora_linux

[oracle@jacky bdump]$ tail alert_test.log
group 3 '/home/oracle/oradata/test/redo03.log' size 10m reuse
datafile '/home/oracle/oradata/test/test01.dbf' size 512m reuse autoextend on next 100m maxsize 1000m,
'/home/oracle/oradata/test/test02.dbf' size 512m reuse autoextend on next 100m maxsize 1000m
maxdatafiles 100
archivelog
character set UTF8
national character set UTF8
sysaux datafile '/home/oracle/oradata/test/sys01.dbf' size 230m autoextend on next 10m maxsize unlimited
undo tablespace undotbs1 datafile '/home/oracle/oradata/test/undo.dbf' size 100m autoextend on next 10m maxsize 100m
...
[oracle@jacky bdump]$

[oracle@jacky test]$ ls -l bdump/
-rw-r-----    1 oracle   oinstall   274480  7ÔÂ 29 14:05 alert_test.log