Meet Error "ORA-01516: nonexistent log file, data file, or temporary file" When Alter The Datafile Autoextend
(Doc ID 2484336.1)
Last updated on MARCH 07, 2023
Applies to:
Oracle E-Business Suite Technology Stack - Version 12.2.6 and laterInformation 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"
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
-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 |