Database upgrade fails with Error:"ORA-01187","ORA-01110" due to temp file corruption.

(Doc ID 2381382.1)

Last updated on APRIL 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

Upgrade to 12.2.0.1 fails with error:
$ ./dbupgrade

catupgrd0.log shows:

ORA-01187: cannot read from file  because it failed verification tests
ORA-01110: data file 14: '/u01/oracle/oradata/temp01.dbf'

alert log shows:

Rereading datafile 14 header failed with ORA-01210
ORA-01186: file 14 failed verification tests
ORA-01122: database file 14 failed verification check
ORA-01110: data file 14: '/u01/oracle/oradata/temp01.dbf'
ORA-01210: data file header is media corrupt

 

Changes

 Upgrading the database.

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