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

Last updated on JULY 09, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 to 12.1.0.2 [Release 11.2 to 12.1]
Information in this document applies to any platform.

Symptoms

When starting the database using 12.1.0.2 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 12.1.0.2 from 11.2.0.4

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