我的oracle数据库是用以下方法建立，现出现ORA-01033: ORACLE initialization or shutdown in progress
查询日志说
Errors in file /export/home/oracle/app/oracle/admin/tbsdb/bdump/tbsdb_dbw0_2070.trc:
ORA-01157: cannot identify/lock data file 3 - see DBWR trace file
ORA-01110: data file 3: '/dev/rdsk/c2t0d3s0'
ORA-27041: unable to open file
SVR4 Error: 13: Permission denied
Additional information: 2
Wed Nov 24 19:38:16 2004
Errors in file /export/home/oracle/app/oracle/admin/tbsdb/bdump/tbsdb_dbw0_2070.trc:
ORA-01157: cannot identify/lock data file 4 - see DBWR trace file
ORA-01110: data file 4: '/dev/rdsk/c2t0d0s1'
ORA-27041: unable to open file
SVR4 Error: 13: Permission denied
Additional information: 2
Wed Nov 24 19:38:16 2004
Errors in file /export/home/oracle/app/oracle/admin/tbsdb/bdump/tbsdb_dbw0_2070.trc:
ORA-01157: cannot identify/lock data file 5 - see DBWR trace file
ORA-01110: data file 5: '/dev/rdsk/c2t0d0s3'
ORA-27041: unable to open file
SVR4 Error: 13: Permission denied
Additional information: 2
Wed Nov 24 19:38:16 2004
Errors in file /export/home/oracle/app/oracle/admin/tbsdb/bdump/tbsdb_dbw0_2070.trc:
ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
ORA-01110: data file 6: '/dev/rdsk/c2t0d3s1'
ORA-27041: unable to open file
SVR4 Error: 13: Permission denied
Additional information: 2
Wed Nov 24 19:38:16 2004
Errors in file /export/home/oracle/app/oracle/admin/tbsdb/bdump/tbsdb_dbw0_2070.trc:
ORA-01157: cannot identify/lock data file 7 - see DBWR trace file
ORA-01110: data file 7: '/dev/rdsk/c2t0d3s3'
ORA-27041: unable to open file
SVR4 Error: 13: Permission denied
Additional information: 2
Wed Nov 24 19:38:16 2004
Errors in file /export/home/oracle/app/oracle/admin/tbsdb/bdump/tbsdb_dbw0_2070.trc:
ORA-01157: cannot identify/lock data file 8 - see DBWR trace file
ORA-01110: data file 8: '/dev/rdsk/c2t0d0s4'
ORA-27041: unable to open file
SVR4 Error: 13: Permission denied
Additional information: 2
Wed Nov 24 19:38:16 2004
Errors in file /export/home/oracle/app/oracle/admin/tbsdb/bdump/tbsdb_dbw0_2070.trc:
ORA-01157: cannot identify/lock data file 9 - see DBWR trace file
ORA-01110: data file 9: '/dev/rdsk/c2t0d7s0'
ORA-27041: unable to open file
SVR4 Error: 13: Permission denied
------------------------------------------------------
以下是建 立 数据库脚本
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "TBSDB" NORESETLOGS NOARCHIVELOG
MAXLOGFILES 64
MAXLOGMEMBERS 2
MAXDATAFILES 1000
MAXINSTANCES 8
MAXLOGHISTORY 907
LOGFILE
GROUP 1 (
'/dev/rdsk/c2t0d4s0',
'/dev/rdsk/c2t0d4s1'
) SIZE 50000K,
GROUP 2 (
'/dev/rdsk/c2t0d4s3',
'/dev/rdsk/c2t0d4s4'
) SIZE 50000K,
GROUP 3 (
'/dev/rdsk/c2t0d4s5',
'/dev/rdsk/c2t0d4s6'
) SIZE 50000K
DATAFILE
'/dev/rdsk/c2t0d0s0',
'/dev/rdsk/c2t0d6s0',
'/dev/rdsk/c2t0d3s0',
'/dev/rdsk/c2t0d0s1',
'/dev/rdsk/c2t0d0s3',
'/dev/rdsk/c2t0d3s1',
'/dev/rdsk/c2t0d3s3',
'/dev/rdsk/c2t0d0s4',
'/dev/rdsk/c2t0d7s0',
'/dev/rdsk/c2t0d7s1',
'/dev/rdsk/c2t0d7s3',
'/dev/rdsk/c2t0d0s5',
'/dev/rdsk/c2t0d0s6',
'/dev/rdsk/c2t0d3s4'
CHARACTER SET ZHS16CGB231280
;
|
