Home
Trouble shooting
 

Cry about...
Oracle Troubleshooting

Database Instance Failure

Symptom:

The database instance is no longer running.

Possible Causes:

  1. The DBA has taken the instance down.

  2. The server has been shut down.

  3. The server has rebooted and the instance has not been set to auto-start.

  • Check the NT System Event Log to see if the server has been rebooted.

  1. Some other hardware related problem.

  • Check the NT System Event Log

  1. Other sources of information to check for additional clues as to the probable cause are:

  • {ORACLE_HOME}\RDBMS80\TRACE\<sid>ALRT.LOG

  • {ORACLE_HOME}\RDBMS80\TRACE\<sid>LMON.TRC

Note: From Oracle 8.1.5 onwards, these files are instead located in the directory {ORACLE_HOME}\Admin\{DB-Name>\bdump

  • Check that the normal Oracle services are running.

  1. If running OPS then also check the ‘errlog’ and ‘pgms.log’ files, both of which are located in the ‘WinNT\System32’ directory.

Remedy:

The remedy will depend on the reason for the instance failure.