This discussion is archived
14 Replies Latest reply: Jan 1, 2008 11:31 PM by 615581 RSS

ORA-1157 signalled during: alter database open...

577678 Newbie
Currently Being Moderated
hi,

when i connect to oracle, i get message:
ORA-01031: ORACLE initialization or shutdown in progress

and i looking for the log file, i get some error like this:
Errors in file E:\oracle\admin\EVO\bdump\evoDBW0.TRC:
ORA-01157: cannot identify/lock data file 17 - see DBWR trace file
ORA-01110: data file 17: 'E:\ORACLE\ORADATA\EVO\REPORT01.DBF'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch (OS 4294967295)
ORA-1157 signalled during: alter database open...

so... i try each command, but i cannot connect to the oracle
C:\Documents and Settings\indra>sqlplus /nolog

SQL> connect as sysdba
Enter user-name: system
Enter password:
ERROR:
ORA-01031: insufficient privileges

SQL> connect / as sysdba
ERROR:
ORA-01031: insufficient privileges

SQL> startup
ORA-01031: insufficient privileges