5 Replies Latest reply: Nov 12, 2012 8:54 AM by CKPT RSS

    System datafile is locked.

    902332
      hi all,

      i am configuring high performance mode datagurad in oracle 11g on linux 5.5. this configuration is with the same server.

      so i used extra parameters db_file_name_convert and log_file_name_convert parameter. even though, after putting standby on recover mode and opening primary it is giving following error.

      Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_dbw0_11087.trc:
      ORA-01157: cannot identify/lock data file 5 - see DBWR trace file
      ORA-01110: data file 5: '/u01/app/oracle/orcl/example01.dbf'
      ORA-27086: unable to lock file - already in use
      Linux Error: 11: Resource temporarily unavailable
      Additional information: 8
      Additional information: 10950
      Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_11152.trc:
      ORA-01157: cannot identify/lock data file 2 - see DBWR trace file
      ORA-01110: data file 2: '/u01/app/oracle/orcl/sysaux01.dbf'
      ORA-1157 signalled during: ALTER DATABASE OPEN...
      Sun Nov 11 10:11:58 2012
      Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_m000_11154.trc:
      ORA-00314: log 1 of thread 1, expected sequence# 4 doesn't match 0
      ORA-00312: online log 1 thread 1: '/u01/app/oracle/orcl/redo01.log'
      Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_m000_11154.trc:
      ORA-00314: log 2 of thread 1, expected sequence# 5 doesn't match 0
      ORA-00312: online log 2 thread 1: '/u01/app/oracle/orcl/redo02.log'
      Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_m000_11154.trc:
      ORA-00314: log 3 of thread 1, expected sequence# 3 doesn't match 0
      ORA-00312: online log 3 thread 1: '/u01/app/oracle/orcl/redo03.log'


      Could you please tell me how we can fix this.

      thanks.
        • 1. Re: System datafile is locked.
          user12215372
          Hi, can you give the open mode of your database: select open_mode from v$database;

          Edited by: user12215372 on 10/11/2012 11:37 PM
          • 2. Re: System datafile is locked.
            teits
            can you perform the on standby and paste the result:
            1. select name from v$datafile
            2. show parameter file_name_convert
            3. show parameter db_unique_name

            Tobi
            • 3. Re: System datafile is locked.
              mseberg
              Hello;

              If locks on data files were not released follow these steps :

              Shutdown database
              Reboot the Server


              If you are using NFS you should do this before the reboot :

              clear_locks -s <nfs_server_host>

              And then restart the NFS client

              Best Regards

              mseberg
              • 4. Re: System datafile is locked.
                973636
                Can you please confirm if the data files are present on both primary and standby?
                • 5. Re: System datafile is locked.
                  CKPT
                  >
                  Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_dbw0_11087.trc:
                  ORA-01157: cannot identify/lock data file 5 - see DBWR trace file
                  ORA-01110: data file 5: '/u01/app/oracle/orcl/example01.dbf'
                  ORA-27086: unable to lock file - already in use
                  Linux Error: 11: Resource temporarily unavailable
                  Additional information: 8
                  Additional information: 10950
                  Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_11152.trc:
                  ORA-01157: cannot identify/lock data file 2 - see DBWR trace file
                  ORA-01110: data file 2: '/u01/app/oracle/orcl/sysaux01.dbf'
                  ORA-1157 signalled during: ALTER DATABASE OPEN...
                  >

                  I think you have already lot of questions. Besides update output of the below query also

                  Shutdown completely, again startup in "MOUNT" status and then
                  SQL> select file#, name,status,error,fuzzy from v$datafile_header;
                  and
                  $ls -ltr /u01/app/oracle/orcl/