My Oracle Support Banner

Meet Error "ORA-01516: nonexistent log file, data file, or temporary file" When Alter The Datafile Autoextend (Doc ID 2484336.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle E-Business Suite Technology Stack - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.6 version, Database for Application Technology

When attempting to alter the data file autoextend,
the following error occurs.

ERROR
-----------------------

SQL> conn / as sysdba
Connected.
SQL> alter database datafile'/data/undotbs004.dbf' autoextend on next 100m maxsize 1000m;
alter database datafile'/undotbs004.dbf' autoextend on next 100m maxsize 1000m
*
ERROR at line 1:
ORA-01516: nonexistent log file, data file, or temporary file
"/data/undotbs004.dbf"

 

File "/data/undotbs004.dbf" also exists in this server. But ll undotbs004.dbf shows: No such file or directory

-rw-r----- 1 oravis oinstall 2147491840 Nov 1 10:42 undotbs002.dbf
-rw-r----- 1 oravis oinstall 1073750016 Nov 1 10:41 undotbs003.dbf
-rw-r----- 1 oravis oinstall 1073750016 Nov 1 10:39 undotbs004.dbf
-rw-r----- 1 oravis oinstall 2105344 Nov 1 01:02 xdb01.dbf
[root@ebsapex data]# ll tx_idx3.dbf
-rw-r----- 1 oravis oinstall 2097160192 Nov 1 10:31 tx_idx3.dbf
[root@ebsapex data]# ll undotbs003.dbf
-rw-r----- 1 oravis oinstall 1073750016 Nov 1 10:41 undotbs003.dbf
[root@ebsapex data]# ll undotbs004.dbf
ls: cannot access undotbs004.dbf: No such file or directory

 



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. alter database datafile'/data/undotbs004.dbf' autoextend on next 100m maxsize 1000m;

Changes

 New created one datafile undotbs004.dbf.

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


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