1 2 Previous Next 25 Replies Latest reply: Dec 8, 2011 3:53 AM by 904243 RSS

    db_file_name_convert & log_file_name_convert - Please help me

    508936
      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.
        1 2 Previous Next