ORA-01157: cannot identify/lock data file
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 16

Thread: ORA-01157: cannot identify/lock data file

  1. #1
    Join Date
    Jan 2003
    Posts
    33

    ORA-01157: cannot identify/lock data file

    Environment:
    OS: IBM AIX 5.1
    DB: Oracle9i R9.2


    I am getting this error when selecting from the tables in this tablespace:

    ORA-01157: cannot identify/lock data file 18 - see DBWR trace file
    ORA-01110: data file 18: '/oracle/oradata/POL1/NETRMS_UCR.dbf'

    I checked the file does exist in the specified location.

    Thanks for all the replies.

  2. #2
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Have you looked at dbwr trace file as suggested in the above error?

  3. #3
    Join Date
    Jan 2003
    Posts
    33

    Re: cannot identify/lock data file

    I checked the trace file..not much from there

    ORA-01157: cannot identify/lock data file 18 - see DBWR trace file
    ORA-01110: data file 18: '/oracle/oradata/POL1/NETRMS_UCR.dbf'
    ORA-27037: unable to obtain file status
    IBM AIX RISC System/6000 Error: 2: No such file or directory
    Additional information: 3

    Repetadily I am getting this in the trace file.

    Thanks for the replies.

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Show me the output from :
    Code:
    groups
    ls -lg /oracle/oradata/POL1/NETRMS_UCR.dbf
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Jan 2003
    Posts
    33
    dpdhqha0@/home/oracle=>ls -lg /oracle/oradata/POL1/NETRMS_UCR.dbf

    Output is like:
    lrwxrwxrwx 1 dba 16 Mar 26 08:57 /oracle/oradata/POL1/NETRMS_UCR.dbf -> /dev/rNETRMS_UCR

    Thanks for helping me.

  6. #6
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    OK, it's a link. How about:
    ls -lg /dev/rNETRMS_UCR
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  7. #7
    Join Date
    Jan 2003
    Posts
    33
    Jeff,

    Thanks for your attention and helping me. The output to ls -lg looks like:

    dpdhqha0@/home/oracle=>ls -lg /dev/*NET*
    brw-rw---- 1 dba 103, 13 Mar 25 16:53 /dev/NETRMS
    brw-rw---- 1 dba 103, 14 Mar 25 16:53 /dev/NETRMS_SECURITY
    brw-rw---- 1 dba 103, 15 Mar 25 16:53 /dev/NETRMS_UCR
    crw-rw---- 1 dba 103, 13 Mar 25 16:53 /dev/rNETRMS
    crw-rw---- 1 dba 103, 14 Mar 25 16:53 /dev/rNETRMS_SECURITY
    crw-rw---- 1 dba 103, 15 Mar 25 16:53 /dev/rNETRMS_UCR

  8. #8
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Hmm. What we got here is a link pointing to a block device. /oracle/oradata/POL1/NETRMS_UCR.dbf is a link that points to the raw device /dev/rNETRMS_UCR. Usually in a case like this, /dev/rNETRMS_UCR isn't accessible from the host. You may want to try and dd the data off that device just to verify you can access it.

    Otherwise, the error is telling you Oracle can't read /oracle/oradata/POL1/NETRMS_UCR.dbf and identify it as an oracle file. I would guess it's something to do either with permissions on the device or the device has some error. I would check your system messages file (/var/adm/messages in Solaris, not sure in AIX) to see if there are any system messages with this device.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  9. #9
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Actually, your link is pointing to the character device and not the block device. I would look at my other datafiles in my database to make sure they are looking at the rdev instead of the dev.

    In other words, you may need to point /oracle/oradata/POL1/NETRMS_UCR.dbf to /dev/NETRMS_UCR instead of /dev/rNETRMS_UCR.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  10. #10
    Join Date
    Oct 2002
    Posts
    391
    Originally posted by marist89
    Show me the output from :
    Code:
    groups
    ls -lg /oracle/oradata/POL1/NETRMS_UCR.dbf
    mine output is "/oracle/sid/sapdata1/facti_2/facti.data2"

    so what could be wrong?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width