Ora-01157

[nilay]

Tanks for reply Tuma.

The process I have followed as :

shutdown database

Shifted oradata folder to desired location

Edited INITtceng.ORA file

created spfile accordingly.

shutdown database

startup mount

alter database backup controlfile to trace;

copied the trace file and paste it at the new oradata location

Edited the trace file and saved it as .sql as:
-----------------------------------------------------------
Before Edit:

LOGFILE
GROUP 1 'P:\ORACLE\PRODUCT\10.1.0\ORADATA\TCENG\REDO01.LOG' SIZE 10M,
GROUP 2 'P:\ORACLE\PRODUCT\10.1.0\ORADATA\TCENG\REDO02.LOG' SIZE 10M,
GROUP 3 'P:\ORACLE\PRODUCT\10.1.0\ORADATA\TCENG\REDO03.LOG' SIZE 10M
-- STANDBY LOGFILE
DATAFILE
'P:\ORACLE\PRODUCT\10.1.0\ORADATA\TCENG\SYSTEM01.DBF',
'P:\ORACLE\PRODUCT\10.1.0\ORADATA\TCENG\UNDOTBS01.DBF',
'P:\ORACLE\PRODUCT\10.1.0\ORADATA\TCENG\SYSAUX01.DBF',
'P:\ORACLE\PRODUCT\10.1.0\ORADATA\TCENG\IDATA01.DBF',
'P:\ORACLE\PRODUCT\10.1.0\ORADATA\TCENG\ILOG01.DBF',
'P:\ORACLE\PRODUCT\10.1.0\ORADATA\TCENG\INDX01.DBF'

ALTER DATABASE REGISTER LOGFILE 'P:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\TCENG\ARCHIVELOG\2008_06_26\O1_MF_1_1_%U_.ARC';

ALTER TABLESPACE TEMP ADD TEMPFILE 'P:\ORACLE\PRODUCT\10.1.0\ORADATA\TCENG\TEMP01.DBF' REUSE;

..........................................
After Edit:

LOGFILE
GROUP 1 'C:\ORADATA\TCENG\REDO01.LOG' SIZE 10M,
GROUP 2 'C:\ORADATA\TCENG\REDO02.LOG' SIZE 10M,
GROUP 3 'C:\ORADATA\TCENG\REDO03.LOG' SIZE 10M
-- STANDBY LOGFILE
DATAFILE
'C:\ORADATA\TCENG\SYSTEM01.DBF',
'C:\ORADATA\TCENG\UNDOTBS01.DBF',
'C:\ORADATA\TCENG\SYSAUX01.DBF',
'C:\ORADATA\TCENG\IDATA01.DBF',
'C:\ORADATA\TCENG\ILOG01.DBF',
'C:\ORADATA\TCENG\INDX01.DBF'

ALTER DATABASE REGISTER LOGFILE 'P:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\TCENG\ARCHIVELOG\2008_06_26\O1_MF_1_1_%U_.ARC';

ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\ORADATA\TCENG\TEMP01.DBF' REUSE;
------------------------------------------------------
then

Shutdown database

then
..........................................................................


SQL> startup nomount;
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
SQL> CREATE CONTROLFILE REUSE DATABASE "tceng" NORESETLOGS;
CREATE CONTROLFILE REUSE DATABASE "tceng" NORESETLOGS
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file
'%ORACLE_HOME%\DATABASE\DBS1%ORACLE_SID%.ORA'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.


SQL> CREATE CONTROLFILE REUSE DATABASE "tceng" RESETLOGS;
CREATE CONTROLFILE REUSE DATABASE "tceng" RESETLOGS
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file
'%ORACLE_HOME%\DATABASE\DBS1%ORACLE_SID%.ORA'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

SQL>
......................................................

I have not edited trace file.

Please advice.