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

Report message to a moderator

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: 26766
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

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 02 00:46:58 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.