[oracle@as1 scripts]$ more /home/oracle/product/9.2.0/assistants/dbca/logs/CreateDB.log
SQL> startup nomount pfile="/home/oracle/admin/eccbak/scripts/init.ora";
ORACLE instance started.Total System Global Area 504436132 bytes
Fixed Size 452004 bytes
Variable Size 184549376 bytes
Database Buffers 318767104 bytes
Redo Buffers 667648 bytes
SQL> CREATE DATABASE eccbak
2 MAXINSTANCES 1
3 MAXLOGHISTORY 1
4 MAXLOGFILES 5
5 MAXLOGMEMBERS 3
6 MAXDATAFILES 100
7 DATAFILE '/home/oracle/oradata/eccbak/system01.dbf' SIZE 250M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
8 EXTENT MANAGEMENT LOCAL
9 DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/home/oracle/oradata/eccbak/temp01.dbf' SIZE 40M REUSE AUTOEXTEND ON NEXT 640K MAX
SIZE UNLIMITED
10 UNDO TABLESPACE "UNDOTBS1" DATAFILE '/home/oracle/oradata/eccbak/undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSI
ZE UNLIMITED
11 CHARACTER SET ZHS16GBK
12 NATIONAL CHARACTER SET UTF8
13 LOGFILE GROUP 1 ('/home/oracle/oradata/eccbak/redo01.log') SIZE 102400K,
14 GROUP 2 ('/home/oracle/oradata/eccbak/redo02.log') SIZE 102400K,
15 GROUP 3 ('/home/oracle/oradata/eccbak/redo03.log') SIZE 102400K;
CREATE DATABASE eccbak
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
SQL> startup nomount pfile="/home/oracle/admin/eccbak/scripts/init.ora";
ORACLE instance started.Total System Global Area 504436132 bytes
Fixed Size 452004 bytes
Variable Size 184549376 bytes
Database Buffers 318767104 bytes
Redo Buffers 667648 bytes
SQL> CREATE DATABASE eccbak
2 MAXINSTANCES 1
3 MAXLOGHISTORY 1
4 MAXLOGFILES 5
5 MAXLOGMEMBERS 3
6 MAXDATAFILES 100
7 DATAFILE '/home/oracle/oradata/eccbak/system01.dbf' SIZE 250M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
8 EXTENT MANAGEMENT LOCAL
9 DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/home/oracle/oradata/eccbak/temp01.dbf' SIZE 40M REUSE AUTOEXTEND ON NEXT 640K MAX
SIZE UNLIMITED
10 UNDO TABLESPACE "UNDOTBS1" DATAFILE '/home/oracle/oradata/eccbak/undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSI
ZE UNLIMITED
11 CHARACTER SET ZHS16GBK
12 NATIONAL CHARACTER SET UTF8
13 LOGFILE GROUP 1 ('/home/oracle/oradata/eccbak/redo01.log') SIZE 102400K,
14 GROUP 2 ('/home/oracle/oradata/eccbak/redo02.log') SIZE 102400K,
15 GROUP 3 ('/home/oracle/oradata/eccbak/redo03.log') SIZE 102400K;
CREATE DATABASE eccbak
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
___________________________________________________________突然中断!查看一下日志 alert.log!
Completed: CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE '/home/o
Fri Sep 5 09:42:24 2008
CREATE TEMPORARY TABLESPACE TEMP TEMPFILE '/home/oracle/oradata/eccbak/temp01.dbf' SIZE 40M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE
UNLIMITED
Completed: CREATE TEMPORARY TABLESPACE TEMP TEMPFILE '/home/
Fri Sep 5 09:42:24 2008
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP
Completed: ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP
Fri Sep 5 09:42:25 2008
SMON: enabling tx recovery
Fri Sep 5 09:42:25 2008
Errors in file /home/oracle/admin/eccbak/udump/ecc_ora_373.trc:
ORA-01501: CREATE DATABASE failed
ORA-01990: error opening password file '/home/oracle/product/9.2.0/dbs/orapw'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Fri Sep 5 09:42:25 2008
Error 1990 happened during db open, shutting down database
USER: terminating instance due to error 1990
Instance terminated by USER, pid = 373
ORA-1092 signalled during: CREATE DATABASE eccbak
MAXINSTANCES 1
MAXLOGHISTOR...
ORA-27037: unable to obtain file status
创建新的pwdsid.ora文件,再重新调用脚本看看
==========================================
权限问题?