Oracle - Error

F

Fuma

Executive Member
Joined
Jul 9, 2007
Messages
5,365
Reaction score
346
Location
Pretoria
I hope someone can help me with this coz I've been to all the websites.

When I use PL/SQL developer, this other system we have, simple vb code, etc..but still can't seem to connect
This is the error:

ORA-01033: ORACLE initialization or shutdown in progress

I restarted the machine, services and did the sql command:

SQL> connect username/password as sysdba;
SQL> shutdown immediate;
SQL> startup
....etc with all success but can't help with my project

The server has been working fine for years, but since yesterday morning it started misbehaving. I'm not a DBA, but I can do the basics. I have a feeling someone messed around with the server.
 
Did you try this site?

Because the first hit is this and some guy there is suggesting you do this:

OK here is the solution I found with the help of a DBA here :

Actually, the database was not shutted down properly the last time (it hung), so the solution is to shutdown explicitely by using SQL Plus.

- I was not able to log in so I used :
> sqlplus /nolog

And after that, I used these commands :

SQL> connect / as sysdba
ConnectÚ.
SQL> shutdown abort
Instance ORACLE arrÛtÚe.
SQL> startup nomount
Instance ORACLE lancÚe.
SQL> alter database mount;
SQL> alter database open;

And all works !!
Click to expand...
 
From the oracle tech support:

ORA-01033: Oracle startup or shutdown in progress

Cause: An attempt was made to log on while Oracle is being started up or shut down.

Action: Wait a few minutes. Then retry the operation.
Click to expand...

check in the services that they have started properly (DB, log writers, listner and monitors). Also check in the event viewre to see if there are any errors.

What version of oracle and what OS
 
rabbiddog said:
From the oracle tech support:



check in the services that they have started properly (DB, log writers, listner and monitors). Also check in the event viewre to see if there are any errors.

What version of oracle and what OS
Click to expand...

Win2003 - Oracle 9i
 
Oracle 9i gave me startup errors on my one server so I loaded 11g which also runs on Vista otherwise still run 8.

Is there nothing comming up in the logs?
 
rabbiddog said:
Oracle 9i gave me startup errors on my one server so I loaded 11g which also runs on Vista otherwise still run 8.

Is there nothing comming up in the logs?
Click to expand...

The log file is about 200MB, I can't seem to open it.
 
You must log in or register to reply here.
Back
Top
Sign up to the MyBroadband newsletter
X