My Oracle Support Banner

Database Upgrade From 10.2.0.5 TO 12.1 Fails With Error “ORA-01000: Maximum Open Cursors Exceeded” (Doc ID 2392727.1)

Last updated on AUGUST 04, 2018

Applies to:

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

Symptoms

When upgrading 10.2.0.5 database to 12.1 (either by DBUA or Manual), the database startup from 12.1 home fails with below error.

 

===From Oracle_Server.log===

ORACLE instance started.
Total System Global Area 4294967296 bytes
Fixed Size 2922264 bytes
Variable Size 3254782184 bytes
Database Buffers 1006632960 bytes
Redo Buffers 30629888 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded

 

==From DBUA trace.log======

[Thread-81] [ 2018-04-01 12:19:56.621 SGT ] [Database.databaseStartup:1879] Start db with clause: [UPGRADE] and pfile = /u01/app/oracle/12cR1/dbs/initTESTDB.ora
[Thread-81] [ 2018-04-01 12:19:56.621 SGT ] [SQLEngine.reInitialize:785] Reinitializing SQLEngine...
[Thread-81] [ 2018-04-01 12:19:56.622 SGT ] [OracleHome.getVersion:1059] Current Version From Inventory: 12.1.0.2.0
[Thread-81] [ 2018-04-01 12:19:56.622 SGT ] [OracleHome.getVersion:991] OracleHome.getVersion called. Current Version: 12.1.0.2.0
[Thread-81] [ 2018-04-01 12:19:56.622 SGT ] [OracleHome.getVersion:1059] Current Version From Inventory: 12.1.0.2.0
[Thread-81] [ 2018-04-01 12:19:56.622 SGT ] [SQLPlusEngine.getCmmdParams:225] m_home 12.1.0.2.0
[Thread-81] [ 2018-04-01 12:19:56.622 SGT ] [SQLPlusEngine.getCmmdParams:226] version > 112 true
[Thread-81] [ 2018-04-01 12:19:56.623 SGT ] [SQLEngine.getEnvParams:602] Default NLS_LANG: AMERICAN_AMERICA.AL32UTF8
[Thread-81] [ 2018-04-01 12:19:56.623 SGT ] [SQLEngine.getEnvParams:612] NLS_LANG: AMERICAN_AMERICA.AL32UTF8
[Thread-81] [ 2018-04-01 12:19:56.624 SGT ] [SQLEngine.initialize:358] Execing SQLPLUS/SVRMGR process...

[Thread-81] [ 2018-04-01 14:25:51.768 SGT ] [SQLEngine.done:2278] Done called
[Thread-81] [ 2018-04-01 14:25:51.779 SGT ] [SQLEngine.spoolOff:2124] Setting spool off = /u01/app/oracle/cfgtoollogs/dbua/TESTDB/upgrade1/Oracle_Server.log
[Thread-81] [ 2018-04-01 14:25:51.787 SGT ] [RDBMSUpgradeStep.executeStepImpl:554] ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded

oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1739)
oracle.sysman.assistants.util.sqlEngine.SQLEngine.startup(SQLEngine.java:2173)
oracle.sysman.assistants.dbma.backend.Database.databaseStartup(Database.java:1880)

 

 

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!


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