Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

db_file_name_convert & log_file_name_convert - Please help me

508936Sep 12 2006 — edited Dec 8 2011
Sir,

I moved a database from one machine to another machine.
In the first machine all file resides at F:\oradata\BOASM

In my new machine F: drive is not available.
So in the new machine I kept all files in E:\oradata\BOASM

I changed controlfile locations, user_dump_dest,core_dump_dest,background_dump_dest in 'initBOASM.ora'

Also I added

db_file_name_convert=('F:\oradata\BOASM' 'E:\oradata\BOASM')
log_file_name_convert=('F:\oradata\BOASM' 'E:\oradata\BOASM')

to initBOASM.ora

But while starting up database it is showing this error..
=========================================
SQL> startup
ORACLE instance started.

Total System Global Area 260643680 bytes
Fixed Size 453472 bytes
Variable Size 150994944 bytes
Database Buffers 109051904 bytes
Redo Buffers 143360 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: 'F:\ORADATA\BOASM\SYSTEM01.DBF'
===================================================

Why this error is commig please help me.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 5 2012
Added on Sep 12 2006
25 comments
14,961 views