Re: ORA-01033: Oracle initialization or shutdown in progress

"Robert Wehofer" <thalion77_at_graffiti.net> wrote in message news:<pBgNa.106792$kC4.1749044_at_news.chello.at>...
> Ok!
>
> I have again closed and started the database and following has been written
> to the alert log file:
>
> <snip>

> alter database open
> Fri Jul 04 16:58:07 2003
> Errors in file C:\Oracle\admin\ORCL\bdump\orclLGWR.TRC:
> ORA-00313: open failed for members of log group 3 of thread 1
> ORA-00312: online log 3 thread 1: 'C:\ORACLE\ORADATA\ORCL\REDO03.LOG'
> ORA-27041: unable to open file
> OSD-04002: Datei kann nicht geöffnet werden
> O/S-Error: (OS 2) Das System kann die angegebene Datei nicht finden.
>
> Fri Jul 04 16:58:07 2003
> Errors in file C:\Oracle\admin\ORCL\bdump\orclLGWR.TRC:
> ORA-00313: open failed for members of log group 3 of thread 1
> ORA-00312: online log 3 thread 1: 'C:\ORACLE\ORADATA\ORCL\REDO03.LOG'
> ORA-27041: unable to open file
> OSD-04002: Datei kann nicht geöffnet werden
> O/S-Error: (OS 2) Das System kann die angegebene Datei nicht finden.
>
> ORA-313 signalled during: alter database open ...

Hi,
Looking at your alert log, my first thought is a problem with your redo log files. Investigate this error from your alert log:

ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: 'C:\ORACLE\ORADATA\ORCL\REDO03.LOG'
ORA-27041: unable to open file

I believe this is what stalled your startup (initialization) and caused your error.

Steve Received on Fri Jul 04 2003 - 12:06:18 CDT