Ora-01157

[Tuma]

Dear all,

I had space problem in my disc.So I manually shifted oradata folder (containing all control and dbf files) to a different location.

Then I created spfile after necessary changes.

But when I try to open the database , its showing error.

SQL> startup mount;
ORACLE instance started.

Total System Global Area 612368384 bytes
Fixed Size 790096 bytes
Variable Size 170914224 bytes
Database Buffers 440401920 bytes
Redo Buffers 262144 bytes
Database mounted.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: 'P:\ORACLE\PRODUCT\10.1.0\ORADATA\TCENG\SYSTEM01.DBF'

Is there any way to resolve it?
Any way I have to shift the dbf files.
Please help.

You shifted them on the OS level, right? But have you informed Oracle that the locations have changed? You do this by renaming the datafiles within Oracle pointing to the new location, tablespace being offline, and MOST important shifting your Control Files. You would have to rename the location in the Pfile, right?.