Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have an Oracle 9.2 database. The server has crashed. After rebooting any attempt to connect to the Oracle server returns error ORA-01033 (as in title).

I've tried stopping and starting the Oracle services (from Control Panel -> Administrative Tools -> Services).

Also, I have waited half an hour, so I don't think the Oracle server is legitimately still starting up. My feeling is that more likely something is corrupted.

share|improve this question

3 Answers 3

up vote 2 down vote accepted

Not necessarily corrupted (that's actually pretty hard to do). Try these steps:

  1. Log onto the database server
  2. Set ORACLE_SID=yourSID
  3. at a command prompt, type sqlplus /nolog
  4. in sql*plus, enter: SHUTDOWN ABORT, then STARTUP
  5. If the database starts up normally, issue a SHUTDOWN IMMEDIATE and another STARTUP.

If that starts the database, you're good to go. If not, you should then get some sort of error message that will get you started down the path of getting a solution. Check the alert log for your instance for additional information. Update this question if you still need help.

Assuming the manual startup fixes the issue, then to make your database startup automatically when the service starts, edit the registry. Look for the key HKLM\Software\Oracle\HOMEx\ORA_sid_AUTOSTART. You want the value of this key to be TRUE. Note: HOMEx will be of the form HOME0, HOME1, etc.

share|improve this answer
    
Thanks for the reply, unfortunately have uninstalled Oracle 9.2 and installed Oracle 10 in an attempt to work around the problem. I'll mark your answer as accepted since it was the only answer. –  Rick Jan 6 '10 at 9:54
    
The steps 1-4 are pretty generic across Oracle versions. The registry key is slightly different in 10g, but concept applies. Finally, become familiar with the alert log - it can often solve issues like this one. If there's something seriously wrong with the database, it will likely be reported there. Typically it's named ORACLE_HOME/admin/bdump/alertSID.log –  DCookie Jan 9 '10 at 18:23

Try This

sqlplus /nolog
SQL> connect / as sysdba
SQL> shutdown abort
SQL> startup nomount
SQL> alter database mount;
SQL> alter database open;

share|improve this answer
    
This did not work for me but a very similar set of instructions did: ora00600.com/wordpress/scripts/ora600/… –  sequoia mcdowell Apr 30 '13 at 17:30

sqlplus /nolog "se conecta SQL> connect / as sysdba

share|improve this answer
1  
Welcome to Server Fault! It would be helpful to others if you could add some explanation of what this does to solve the problem. –  squillman Nov 19 '13 at 14:37

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.