12c Alert Log Appears To Show Unexpected Instance Restart (Doc ID 2049516.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

The human readable text mode alert log appears to show startup messages, with no preceding shutdown messages or any other messages indicating any kind of error condition. 

It then shows the standard startup information like banner, system parameters with non-default values, and a dump of current patch information, for example:

...
Mon Aug 24 13:55:50 2015
Archived Log entry 591 added for thread 1 sequence 287 ID 0x3ad9706d dest 1:   <-- Normal behaviour without any sign of a fatal condition
Mon Aug 24 13:55:52 2015
Thread 1 cannot allocate new log, sequence 289   <-- This is not the issue here, but note the timestamp
Checkpoint not complete
Creating new log segment:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production   <-- This banner suggests the DB has just started up
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options.
ORACLE_HOME = /opt/oracle/product/12.1.0
System name:    Linux
Node name:    xxxxxxxxx.xxxxx.xxx
Release:    2.6.32-504.12.2.el6.x86_64
Version:    #1 SMP Sun Feb 1 12:14:02 EST 2015
Machine:    x86_64
Using parameter settings in client-side pfile
System parameters with non-default values:
  processes                = 2000
  sessions                 = 3024
...
===========================================================
Dumping current patch information
===========================================================
Patch Id: 19769480
Patch Description: Database Patch Set Update : 12.1.0.2.2 (19769480)
Patch Apply Time: 2015-03-05 11:08:50 GMT+01:00
...
Mon Aug 24 13:55:53 2015
Thread 1 advanced to log sequence 289 (LGWR switch)   <-- Normal behaviour continues.  Note the timestamp however!
...

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms