ORA-01157: cannot identify/lock data file
Environment:
OS: IBM AIX 5.1
DB: Oracle9i R9.2
I am getting this error when selecting from the tables in this tablespace:
ORA-01157: cannot identify/lock data file 18 - see DBWR trace file
ORA-01110: data file 18: '/oracle/oradata/POL1/NETRMS_UCR.dbf'
I checked the file does exist in the specified location.
Thanks for all the replies.
Re: cannot identify/lock data file
I checked the trace file..not much from there
ORA-01157: cannot identify/lock data file 18 - see DBWR trace file
ORA-01110: data file 18: '/oracle/oradata/POL1/NETRMS_UCR.dbf'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
Repetadily I am getting this in the trace file.
Thanks for the replies.