My Oracle Support Banner

Database upgrade fails with Error: "ORA-01110: data file N: '<location/temp.dbf>', as tempfile is corrupted/non-existing. (Doc ID 2381382.1)

Last updated on OCTOBER 21, 2022

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.


Symptom 1:

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


Symptom 2:

catupgrd0.log shows


ERROR at line 1:
ORA-01157: cannot identify/lock data file 1009 - see DBWR trace file
ORA-01110: data file 1009: '/u01/oracle/oradata//TEMPFILE/temp01.db'




 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
 Symptom 1:
 Symptom 2:
 Cause 1:
  Cause 2:
  Solution 1:
Solution 2:

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