SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA 01033: Oracle initialization or shutdown in progress

496474Mar 23 2006 — edited Feb 1 2007

After I got above problem . I tried to solve it by :

C:\>set Oracle_SID=gqtstest

C:\>sqlplus /nolog

SQL*Plus: Release 9.2.0.1.0 - Production on Thu Mar 23 14:42:08 2006

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> connect /as sysdba
Connected.
SQL> shutdown abort
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
Database mounted.
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'C:\ORACLE\ORADATA\GQTSTEST\REDO01.LOG'

unfortunately I have deleted REDO01.LOG file. Am I getting error bcoz of that? What should be solution to this problem. I can not even login

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 1 2007

Added on Mar 23 2006

3 comments

1,307 views