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

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

  1. #11
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Originally posted by yls177
    mine output is "/oracle/sid/sapdata1/facti_2/facti.data2"

    so what could be wrong?
    omg

  2. #12
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    links + dbf's=bad big no no.

    Oracle won't support it.when it comes to critical database files
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  3. #13
    Join Date
    Oct 2002
    Posts
    391
    Originally posted by pando
    omg
    pardon me.. but i dont get what u are trying to get at

  4. #14
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    I dont get your question neither! Do you use character/block device....?! I was confused if your question is relevant here

  5. #15
    Join Date
    Oct 2002
    Posts
    391

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

    Originally posted by oraclekb
    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.
    hi, i got this error, and when i follow the postings, i do a ls -lg
    /oracle/sid/sapdata1/facti_2/facti.data2 and got "/oracle/sid/sapdata1/facti_2/facti.data2" as well.

    i didnt get any links to any device files.

  6. #16
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by OracleDoc
    links + dbf's=bad big no no.

    Oracle won't support it.when it comes to critical database files
    I don't know about that. There are several instances in metalink of how to setup soft links to critical files for Oracle to use. In fact, I was instructed by an Oracle Support analyst to create a soft link to a datafile during a recovery.

    http://metalink.oracle.com/metalink/...T&p_id=45967.1
    http://metalink.oracle.com/metalink/...T&p_id=73595.1
    etc.

    In addition 99% of system administrators will use soft links for the top of a filesystem's mount point. If that's your convention, great. However, I think saying Oracle won't support it is misleading.
    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."

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