12c Alert Log Appears To Show Unexpected Instance Restart
(Doc ID 2049516.1)
Last updated on AUGUST 31, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A 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 behavior 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 behavior continues. Note the timestamp however!
...
Mon Aug 24 13:55:50 2015
Archived Log entry 591 added for thread 1 sequence 287 ID 0x3ad9706d dest 1: <-- Normal behavior 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 behavior continues. Note the timestamp however!
...
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |