My Oracle Support Banner

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

Last updated on OCTOBER 22, 2019

Applies to:

Oracle Database - Enterprise Edition - Version to [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.


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 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
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 >>>>>>>>>>>>>>>>>>>



While performing the upgrade to 12c from


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

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