1

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.

3 Answers 3

2

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.

2
  • 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, 2010 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, 2010 at 18:23
3

Try This

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

1
0

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

1
  • 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, 2013 at 14:37

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .