Fail Safe cannot restart the database which hangs on startup (Doc ID 2008385.1)

Last updated on MAY 12, 2015

Applies to:

Oracle Fail Safe - Version 4.1 and later
Microsoft Windows x64 (64-bit)

Symptoms

Trying to restart 12.1.0.2 database managed by OFS hangs the instance and OFS shows the database as pending.
This happens if you use OFS to take the database offline and then online, move the group to another node, or do a failover.
The 12c database is using AQ as part of the application. Applications are ODP and .NET applications.

The database shuts down with no issues and the attempted restart by OFS hangs as seen in the alert log.

OFS always starts the database restricted, checks if standby or primary to see if it should be mounted or opened.  Then remove the restricted session. The database hangs waiting for EMON to start and it cannot. It is not a complete hang since it can be aborted.

Starting up:
Oracle Database 12c Release 12.1.0.1.0 - 64bit Production.
...
Fri Apr 24 19:15:48 2015
alter database mount exclusive
Fri Apr 24 19:15:52 2015
Successful mount of redo thread 1, with mount id 1750945956
Fri Apr 24 19:15:52 2015
Database mounted in Exclusive Mode
Lost write protection disabled
Ping without log force is disabled.
Completed: alter database mount exclusive
alter database open
Starting background process TMON
Fri Apr 24 19:15:52 2015
TMON started with pid=24, OS id=4276
Fri Apr 24 19:15:52 2015
Thread 1 opened at log sequence 12707
 Current log# 3 seq# 12707 mem# 0: R:\ORACLE\ORADATA\ORACLE\REDO03.LOG
Successful open of redo thread 1
Fri Apr 24 19:15:52 2015
SMON: enabling cache recovery
...
AQ Processes can not start in restrict mode
Fri Apr 24 19:18:03 2015
ERROR: Emon failed to start.
Fri Apr 24 19:20:03 2015
ERROR: Emon failed to start.

Changes

 This worked in previous version of OFS 3.4.2 and database version 11.2.0.x with the same application using AQ.

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