My Oracle Support Banner

ORA-704, ORA-604, ORA-2240 and Database doesn't open after Upgrade (Doc ID 2239726.1)

Last updated on MARCH 23, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.5 to 12.1.0.2 [Release 10.2 to 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

Database was upgraded successfully but unable to open the database after the upgrade.

From the alert.log

Mon Feb 27 12:56:24 GMT 2017
Starting background process CTWR
CTWR started with pid=43, OS id=22166
Block change tracking service is active.
Mon Feb 27 12:56:25 GMT 2017
SMON: enabling cache recovery
Mon Feb 27 12:56:25 GMT 2017
Errors in file /app/oracle/admin/test/udump/mhrdev2a_ora_22048.trc:
ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 1
ORA-02240: invalid value for OBJNO or TABNO
Mon Feb 27 12:56:25 GMT 2017
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
Instance terminated by USER, pid = 22048
ORA-1092 signalled during: ALTER DATABASE OPEN MIGRATE…



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


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