Home » RDBMS Server » Server Administration » ORA-01033 Oracle Initialization or shutdown in progress
ORA-01033 Oracle Initialization or shutdown in progress [message #269880] Tue, 25 September 2007 00:09 Go to next message
kamran.it
Messages: 265
Registered: September 2005
Location: Karachi
Senior Member
Our Oracle Server database 9i and 6i form was working fine last one year but yesterday due to power failure server was down directly from switch and after that when we start again server and run our application it gives us error .

ORA-01033 Oracle Initialization or shutdown in progress

Please help what should I do?
Re: ORA-01033 Oracle Initialization or shutdown in progress [message #269883 is a reply to message #269880] Tue, 25 September 2007 00:19 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
>Please help what should I do?
Have who ever is in charge to hire somebody who is a competent Oracle DBA.

You could try the following from a terminal/command prompt while logged into/onto the OS (which name & version?) as the Oracle user:
sqlplus
/ as sysdba
shutdown abort
startup
exit


Use CUT & PASTE to provide whole session above & use <code tags>
as explained in the #1 STICKY post found at the very TOP of this forum.
Re: ORA-01033 Oracle Initialization or shutdown in progress [message #269887 is a reply to message #269880] Tue, 25 September 2007 00:39 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

While working with database the DBA performed shutdown operation on database.
Re: ORA-01033 Oracle Initialization or shutdown in progress [message #270205 is a reply to message #269883] Wed, 26 September 2007 02:23 Go to previous messageGo to next message
kamran.it
Messages: 265
Registered: September 2005
Location: Karachi
Senior Member
I do this but give this error
ORA-00333 Redo log read error block 8194 count 8192
Re: ORA-01033 Oracle Initialization or shutdown in progress [message #270230 is a reply to message #269880] Wed, 26 September 2007 03:53 Go to previous messageGo to next message
naveenmelbourne
Messages: 15
Registered: August 2007
Junior Member
Hello Friend,

Shudown proccess is not killed. I think its on loop.
Can't you reboot the system.
I think it should be okay after rebooting

Thank you

Naveen
Re: ORA-01033 Oracle Initialization or shutdown in progress [message #270234 is a reply to message #270230] Wed, 26 September 2007 04:16 Go to previous messageGo to next message
kamran.it
Messages: 265
Registered: September 2005
Location: Karachi
Senior Member
I have restarted and shutdown also

since three days i am facing this problem please suggest any solution.
Re: ORA-01033 Oracle Initialization or shutdown in progress [message #270332 is a reply to message #269880] Wed, 26 September 2007 10:13 Go to previous messageGo to next message
naveenmelbourne
Messages: 15
Registered: August 2007
Junior Member
Hi,
Check the alert log and find out exactly what happend during shutdown process and how it happend.
May be that will help you in finding a solution.

Naveen
Re: ORA-01033 Oracle Initialization or shutdown in progress [message #271101 is a reply to message #269880] Sat, 29 September 2007 07:38 Go to previous messageGo to next message
naveenmelbourne
Messages: 15
Registered: August 2007
Junior Member
Hi Kamran!
I haven't heard anything from you.. I got a solution for your problem. May be it will help you.
Use this command
ORAKILL <SID> <THREAD ID>
and STARTUP
let me know whether it worked!!!!!!

Naveen
Re: ORA-01033 Oracle Initialization or shutdown in progress [message #271140 is a reply to message #269880] Sat, 29 September 2007 23:21 Go to previous message
ora10g
Messages: 7
Registered: July 2006
Junior Member
hi ,
I thing your redo log file has some issues. You need to fix that issue first.If you have mirror copy of redo, just copy and past it.
Pls reffer below link for more details...

http://ora-01033.err-codes.com/
Previous Topic: Test Environment for oracle
Next Topic: Delete a running job
Goto Forum:
  


Current Time: Sat Dec 03 01:08:00 CST 2016

Total time taken to generate the page: 0.08655 seconds