Windows – oracle crash – not starting

oraclewindows

We have a
Windows Server 2008 R2 Enterprise x64
Oracle 10.2.0.3
Adempiere – ERP

  1. We had a power breakdown at 03.00 AM.
  2. At 07.30 AM we started the server
  3. At 08.00 our colleagues observed that the ERP is not functioning
  4. We started Adempiere
  5. ERP was not able to connect to Oracle DB
  6. We entered EM Console and we checked the DB status
  7. The listener was functional – up and running
  8. DB was shotdown in progress
  9. We tried to abort shot down via SQL Plus using command :
    shutdown abort
  10. Nothing happen
  11. We tried shutdown – no result
  12. We tried shutdown immediate – no result
  13. Then we made Windows Shutdown from start menu
  14. After restart of the server we checked in Windows Services.MSC the Oracle running services
  15. Oracle JoobscheduleORCL was disabled, the rest were running. We set this one on automatic
  16. The listener was functional – up and running
  17. DB was shotdown in progress
  18. We tried to abort shot down via SQL Plus using command :
    shutdown abort
  19. Nothing happen
  20. We tried shutdown – no result
  21. We tried shutdown immediate – no result
  22. We tried to restart the Oracle Services with no result
  23. We searched on the forum.oracle.com and we found out that the problem could be that the undotablespace is corrupted.
  24. We tried to fix the table
  25. We used the following command line :

alter database datafile 'xxxxx\undotbs01.dbf' offline drop;

http://www.dbas-oracle.com/2011/06/recovery-from-undo-tablespace-block.html

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:5669213349582

  1. The current situation is :

    SQL> startup
    ORA-01081: cannot start already-running ORACLE - shut it down first
    
    SQL> shutdown immediate
    ORA-24324: service handle not initialized
    ORA-24323: value not allowed
    ORA-01092: ORACLE instance terminated. Disconnection forced
    
    SQL> startup
    ORA-01031: insufficient privileges
    

Best Answer

Be sure the ORACLE_HOME and ORACLE_SID environment variables are correctly set. Then run sqlplus / AS SYSDBA as a user who is a member of the oradba group on the computer.

Get the machine down forcibly:

SHUTDOWN ABORT

Start it up, but try not to let stuff run wild:

STARTUP RESTRICT

Shut it down more gracefully. Don't stop until recovery is complete.

SHUTDOWN IMMEDIATE

Start it up.

STARTUP