School Assignment? Project Due Tomorrow? Chat LIVE With A Programming Expert!

Welcome to Dream.In.Code
Become an Expert!

Join 300,421 Programmers for FREE! Get instant access to thousands of experts, tutorials, code snippets, and more! There are 1,524 people online right now. Registration is fast and FREE... Join Now!




ERROR: ORA-01033:

 

ERROR: ORA-01033:, ORACLE initialization or shutdown in progress

OliveOyl3471

30 Jun, 2009 - 10:10 AM
Post #1

Quick and Dirty
Group Icon

Joined: 11 Jul, 2007
Posts: 5,465



Thanked: 105 times
Dream Kudos: 775
Expert In: Basketball

My Contributions
I tried to connect to a database and got this error.

QUOTE
ERROR: ORA-01033: ORACLE initialization or shutdown in progress


I tried exiting and restarting Oracle, but it still gives the error. How do I fix this?

Should I uninstall and reinstall Oracle?

User is offlineProfile CardPM
+Quote Post


kmangold

RE: ERROR: ORA-01033:

30 Jun, 2009 - 10:17 AM
Post #2

D.I.C Head
Group Icon

Joined: 24 Jun, 2009
Posts: 166



Thanked: 7 times
Dream Kudos: 75
My Contributions
http://www.dba-oracle.com/t_ora_01033_init...wn_progress.htm

The above site suggests that the database is not open and you need to issue this command, "alter database open".

I hope this helps.
User is offlineProfile CardPM
+Quote Post

OliveOyl3471

RE: ERROR: ORA-01033:

30 Jun, 2009 - 10:26 AM
Post #3

Quick and Dirty
Group Icon

Joined: 11 Jul, 2007
Posts: 5,465



Thanked: 105 times
Dream Kudos: 775
Expert In: Basketball

My Contributions
Thanks, Kevin. I tried that, but it said "Not connected"

As if I didn't know that, lol.

I think I'll try reinstalling Oracle and see if that fixes it.

Reinstalling and choosing the option to repair did not fix the error. Uninstalling and reinstalling Oracle did fix it. There may be other ways of doing it, but this is one way that will work. biggrin.gif
//in case anyone who may read this thread needs to know

This post has been edited by OliveOyl3471: 30 Jun, 2009 - 11:10 AM
User is offlineProfile CardPM
+Quote Post

Fast ReplyReply to this topicStart new topic

Time is now: 11/8/09 12:10AM

Live Help!

Be Social

Dream.In.Code RSS Feed Dream.In.Code LinkedIn Group Follow Us On Twitter Fan Us On Facebook

Tutorials

Programming

Web Development

Reference Sheets

Code Snippets

DIC Chatroom

Bye Bye Ads

Monthly Drawing

Thumb Drive

Top Contributors

Top 10 Kudos This Month