oracle, database, 10, ORACLE ORA-01033 initialization or shutdown in progress


I have a oracle instance that doesnt run giving me an ORA-01033  error

ORA-01033: ORACLE initialization or shutdown in progress

Building Oracle HOMES List  
HOME Name ORACLE8_HOME added to list.  
Found multiple homes, searching each HOMEx for valid PATH  
searching in SOFTWARE\ORACLE\HOME0  
Oracle_Home found in SOFTWARE\ORACLE\HOME0 IS in system path!  
oci.dll found  

could anybody advise on the issue or comment how to solve it?


Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

I assume you are running under Windows...

Try looking for more information in your alert log.  If you cannot find it, try this:

C:\> SET ORACLE_SID=<your_sid>
C:\> sqlplus /nolog
SQL> conn sys as sysdba
SQL> startup

You will hopefully get more information about what is causing the problems... then post
Fekrat El WehediInfrastructure Architect / Oracle DBACommented:
Try the following steps:
1. Shutdown database.
2. Connect Internal.
3. run STARTUP MOUNT; This steps mounts the database but it is still not open;
4. If step 3 works, run ALTER DATABASE OPEN;
5. EXIT;
6. Try to connect using SQL Studio or SQL*PLus.
7. Try TNSPING80 <database>; (if may also be called TNSPING.EXE).

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.