No Applications Can Run (‘Frozen’ System) (SAP Library

No Applications Can Run (‘Frozen’ System)

At times you may find that your system has completely frozen. No application can proceed, unlike a slow running system. If this happens, it will usually happen abruptly. It is often the result of a resource being completely depleted, and the Oracle database system can no longer continue.

The most common reasons for a frozen system are:

The archiving of offline redo log files (that is, the copying of online redo log files to the archiving directory by the Oracle background process ARCH) has frozen. SAP databases in production run in ARCHIVELOG mode. This means that an online redo log file can only be overwritten with information from the redo log buffer by the log writer (LGWR) when its contents have been archived. If archiving is not possible, the database system cannot continue.

Check whether the ARCH process is running ( LOG_ARCHIVE_START (Oracle)). Check whether the archiving directory is full (Archive Stuck). To do this, you can use the SAP utility program SAPDBA.

You should monitor the archiving process on a regular basis to avoid the freezing of the system due to errors in this area. You can use the options provided by the CCMS ( Displaying Redo Log Backups: Oracle).

See also: SAP Database Management: Oracle and the SAP notes database (for example, note number 391)

All SAP processes are locked.

See also:

Database Message Log (Oracle)

Checkpoint Monitoring (Oracle)

Exclusive Lockwaits (Oracle)