My Oracle Support Banner

STARTUP UPGRADE command hangs while upgrading database from Oracle 11.2.0.4 to 12c (Doc ID 2283231.1)

Last updated on OCTOBER 22, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 to 12.2.0.1 [Release 11.2 to 12.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

When starting the database using 12c binaries, the startup upgrade command hangs and does not return back the SQL prompt.

 

$sqlplus "/as sysdba"

SQL*Plus: Release 12.1.0.2.0 Production on Tue Jun 20 16:01:00 2017

Copyright (c) 1982, 2014, Oracle. All rights reserved.

Connected to an idle instance.

16:01:02 SQL> startup upgrade
ORACLE instance started.

Total System Global Area 1073741824 bytes
Fixed Size 2932632 bytes
Variable Size 348127336 bytes
Database Buffers 717225984 bytes
Redo Buffers 5455872 bytes
Database mounted.

^CORA-00604: error occurred at recursive SQL level 1
ORA-01013: user requested cancel of current operation

 

Where as alert log file shows that the DB is started in upgrade mode:

 Thu Jun 08 15:18:08 2017
ALTER SYSTEM SET resource_manager_plan= SCOPE=MEMORY;
Thu Jun 08 15:18:08 2017
ALTER SYSTEM SET recyclebin='OFF' DEFERRED SCOPE=MEMORY;
Resource Manager disabled during database migration
replication_dependency_tracking turned off (no async multimaster replication found)
AQ Processes can not start in restrict mode
Starting background process CJQ0
Thu Jun 08 15:18:08 2017
CJQ0 started with pid=41, OS id=134073
Completed: ALTER DATABASE OPEN MIGRATE >>>>>>>>>>>>>>>>>>>

 

Changes

While performing the upgrade to 12c from 11.2.0.4

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
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.