14 Replies Latest reply: Jan 2, 2008 1:31 AM by 615581 RSS

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

    577678
      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