My Oracle Support Banner

Database upgrade fails with Error:"ORA-01187","ORA-01110" due to temp file corruption. (Doc ID 2381382.1)

Last updated on AUGUST 04, 2018

Applies to:

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


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



 Upgrading the database.


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.