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

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

ORA-01033 Oracle Initialization or shutdown in progress [message #269880]

Tue, 25 September 2007 00:09

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?

Attachment: New Picture (1).png
(Size: 68.54KB, Downloaded 794 times)

Report message to a moderator

Re: ORA-01033 Oracle Initialization or shutdown in progress [message #269883 is a reply to message #269880]

Tue, 25 September 2007 00:19

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

Report message to a moderator

Re: ORA-01033 Oracle Initialization or shutdown in progress [message #269887 is a reply to message #269880]

Tue, 25 September 2007 00:39

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

While working with database the DBA performed shutdown operation on database.

Report message to a moderator

Re: ORA-01033 Oracle Initialization or shutdown in progress [message #270205 is a reply to message #269883]

Wed, 26 September 2007 02:23

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

Report message to a moderator

Re: ORA-01033 Oracle Initialization or shutdown in progress [message #270230 is a reply to message #269880]

Wed, 26 September 2007 03:53

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

Report message to a moderator

Re: ORA-01033 Oracle Initialization or shutdown in progress [message #270234 is a reply to message #270230]

Wed, 26 September 2007 04:16

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.

Report message to a moderator

Re: ORA-01033 Oracle Initialization or shutdown in progress [message #270332 is a reply to message #269880]

Wed, 26 September 2007 10:13

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

Report message to a moderator

Re: ORA-01033 Oracle Initialization or shutdown in progress [message #271101 is a reply to message #269880]

Sat, 29 September 2007 07:38

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

Report message to a moderator

Re: ORA-01033 Oracle Initialization or shutdown in progress [message #271140 is a reply to message #269880]

Sat, 29 September 2007 23:21

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/

Report message to a moderator

Previous Topic:	Test Environment for oracle
Next Topic:	Delete a running job

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 10:45:42 CDT 2024