OraFAQ Forum: Server Administration » ORA-01033: ORACLE initialization or shutdown in progress

Home » RDBMS Server » Server Administration » ORA-01033: ORACLE initialization or shutdown in progress (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01033: ORACLE initialization or shutdown in progress [message #400034]

Sat, 25 April 2009 05:25

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

Report message to a moderator

Re: ORA-01033: ORACLE initialization or shutdown in progress [message #400051 is a reply to message #400034]

Sat, 25 April 2009 09:05

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

sqlplus
/ as sysdba
shutdown abort
startup
exit

Report message to a moderator

Re: ORA-01033: ORACLE initialization or shutdown in progress [message #400073 is a reply to message #400034]

Sat, 25 April 2009 13:49

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.

Report message to a moderator

Re: ORA-01033: ORACLE initialization or shutdown in progress [message #400085 is a reply to message #400051]

Sat, 25 April 2009 21:43

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

Report message to a moderator

Re: ORA-01033: ORACLE initialization or shutdown in progress [message #400090 is a reply to message #400034]

Sat, 25 April 2009 22:07

BlackSwan
Messages: 26766
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?

Report message to a moderator

Previous Topic:	Oracle 11G command line create database command (merged)
Next Topic:	DB requires restart once in two days

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 02 23:28:25 CDT 2024