This discussion is archived
5 Replies Latest reply: Nov 12, 2012 6:54 AM by CKPT RSS

System datafile is locked.

902332 Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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 Pro
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    Can you please confirm if the data files are present on both primary and standby?
  • 5. Re: System datafile is locked.
    CKPT Guru
    Currently Being Moderated
    >
    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/

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points