Quote Originally Posted by nilay
Only thing I have done is in pfile I have changed the path of control files(Database was shutdown). Then created spfile.
But is this enough for 'renaming the datafiles within Oracle pointing to the new location, tablespace being offline, and MOST important shifting the Control Files'?
If any other command I have to run, Please advice.
I see it complaining about the system tablespace? You may have to recreate your control file from scratch.

alter database backup controfile to trace;
pick it up at your udump
NB edit the text file putting in the locations of the files shifted. save it with .sql
shutdown database;
startup nomount;
create controfile reuse database "database name''
recover DATABASE;
alter databse OPEN;

NB...cross check these steps...