Home » RDBMS Server » Networking and Gateways » ora-01033: Oracle initialization or shutdown in progress (Oracle 10g)
ora-01033: Oracle initialization or shutdown in progress [message #444781] Wed, 24 February 2010 03:10 Go to next message
monasingh
Messages: 229
Registered: May 2006
Location: Mumbai
Senior Member

Hi,
I am getting the error 'ora-01033: Oracle initialization or shutdown in progress' when I try to login into oracle. It was working fine some days ago.

I tried the below steps :-
C:\Documents and Settings\sk32740>sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Feb 24 14:31:08 2010

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> connect / as sysdba
Connected.
SQL> shutdown abort
ORACLE instance shut down.
SQL> startup nomount
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

Total System Global Area  285212672 bytes
Fixed Size                  1248552 bytes
Variable Size             100664024 bytes
Database Buffers          176160768 bytes
Redo Buffers                7139328 bytes
SQL>    alter database mount;

Database altered.

SQL>
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-16038: log 2 sequence# 324 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 2 thread 1:
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG'


SQL>


I even tried increasing the value of db_recovery_file_dest_size

SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE=2048576000 SCOPE=BOTH;

System altered.

SQL> shutdown abort
ORACLE instance shut down.
SQL> startup
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

Total System Global Area  285212672 bytes
Fixed Size                  1248552 bytes
Variable Size             100664024 bytes
Database Buffers          176160768 bytes
Redo Buffers                7139328 bytes
Database mounted.
ORA-16038: log 2 sequence# 324 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 2 thread 1:
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG'


Please advice.

Regards,
Mona
Re: ora-01033: Oracle initialization or shutdown in progress [message #444784 is a reply to message #444781] Wed, 24 February 2010 03:33 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-19809: limit exceeded for recovery files
*Cause: The limit for recovery files specified by the
        DB_RECOVERY_FILE_DEST_SIZE was exceeded.
*Action:The error is accompanied by 19804. See message 19804 for further
        details.

You didn't post error 19804.

Regards
Michel
Re: ora-01033: Oracle initialization or shutdown in progress [message #444787 is a reply to message #444784] Wed, 24 February 2010 03:48 Go to previous message
monasingh
Messages: 229
Registered: May 2006
Location: Mumbai
Senior Member

Hi Michel,
I have pasted everything from my screen. I didn't got the error message for 19804.
Previous Topic: ORA-12560 Protocol Adapter error
Next Topic: how to set orale Gateways 11g for mssql
Goto Forum:
  


Current Time: Thu Mar 28 03:53:16 CDT 2024