Home » RDBMS Server » Server Administration » ORA-01033: ORACLE initialization or shutdown in progress (Oracle 10g)
ORA-01033: ORACLE initialization or shutdown in progress [message #400034] Sat, 25 April 2009 05:25 Go to next message
pass_ora
Messages: 2
Registered: April 2009
Location: Australia
Junior Member
Greetings,

For the past few months I have been happily developing a series of reports against an Oracle 10g database (which has been working fine for months now). However, about a week ago, I logged my client PC on and all of sudden I'm consistently receiving the error: "ORA-01033: ORACLE initialization or shutdown in progress" when trying to query Oracle.

For the life of me, I can't figure out what has caused this and more importantly how to resolve this issue.

Any pointers or suggestions would be most welcome!

Thanks!

Regards,
pass_ora
Re: ORA-01033: ORACLE initialization or shutdown in progress [message #400051 is a reply to message #400034] Sat, 25 April 2009 09:05 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
sqlplus
/ as sysdba
shutdown abort
startup
exit
Re: ORA-01033: ORACLE initialization or shutdown in progress [message #400073 is a reply to message #400034] Sat, 25 April 2009 13:49 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Do you have SYS privilege for this database? Else check with your DBA.
Re: ORA-01033: ORACLE initialization or shutdown in progress [message #400085 is a reply to message #400051] Sat, 25 April 2009 21:43 Go to previous messageGo to next message
pass_ora
Messages: 2
Registered: April 2009
Location: Australia
Junior Member
Thanks! I took your suggestion and I now feel like I'm getting closer but now I am receiving these messages from Oracle:

ORA-01172: recovery of thread 1 stuck at block 2012 of file 2
ORA-01151: use media recovery to recover block, restore backup if needed

Any suggestions are likewise most appreciated!

Thanks.

Regards,
pass_ora
Re: ORA-01033: ORACLE initialization or shutdown in progress [message #400090 is a reply to message #400034] Sat, 25 April 2009 22:07 Go to previous message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
>Any suggestions are likewise most appreciated!
use media recovery to recover block, restore backup if needed


You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/

You might find additional clues in the alert_SID.log file.

What sequence of events occurred that led to this current state?
Previous Topic: Oracle 11G command line create database command (merged)
Next Topic: DB requires restart once in two days
Goto Forum:
  


Current Time: Mon Dec 05 19:27:54 CST 2016

Total time taken to generate the page: 0.08954 seconds