Home » RDBMS Server » Server Administration » ORA-01033: ORACLE initialization or shutdown in progress (Windows2003 Server, Oracle Database Server 10g)
ORA-01033: ORACLE initialization or shutdown in progress [message #324522] Mon, 02 June 2008 23:35 Go to next message
dbhossain
Messages: 155
Registered: August 2007
Location: Dhaka
Senior Member

Dear experts,

i have encounterd the following error:

For the long time power Failure my database server got improper shutdown . when i open ( restart) the database server i got the above message "ORA-01033: ORACLE initialization or shutdown in progress"

i waited long time to get initializing even 1 full day.....but
still get the same message. it has been 5 days no improvement.

My database is in "Archieved Mode"

why it happens and whats the solution?



please help me.


--dbhossain
Re: ORA-01033: ORACLE initialization or shutdown in progress [message #324524 is a reply to message #324522] Mon, 02 June 2008 23:42 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
type exactly as exists below:
sqlplus
/ as sysdba
shutdown abort
startup
exit

Use CUT & PASTE to post the whole session
Re: ORA-01033: ORACLE initialization or shutdown in progress [message #324532 is a reply to message #324524] Mon, 02 June 2008 23:53 Go to previous message
dbhossain
Messages: 155
Registered: August 2007
Location: Dhaka
Senior Member

Dear anacedent,

Thank you for your quick response. Let me try.



Best regards,


--dbhossain
Previous Topic: Index creation statement
Next Topic: Query on sga size
Goto Forum:
  


Current Time: Thu Dec 08 21:56:55 CST 2016

Total time taken to generate the page: 0.08624 seconds