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 12.2.0.1 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.

Symptoms

Symptom 1:

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

 

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'

  

 

Changes

 Upgrading the database.

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