Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2010
    Posts
    81

    Unanswered: ORA-27041: unable to open file

    Hi,

    I created a tablespace file incorrectly and then removed the file from the O/S before dropping
    the tablespace and removing the contents. Having researched it seems the only way is to shutdown
    and start the database in the mount mode. As this is a production database, I am unable to shutdown
    and wondered whether there was an alternative to removing this error. I thought about touching a
    0 block file in the correct path - would this resolve the issue?

    Error message is

    '/u01/oradata1/wflprd/data04/pega_indx_12.dbf'
    ERROR at line 1:
    ORA-01116: error in opening database file 72
    ORA-01110: data file 72: '/u01/oradata1/wflprd/data04/pega_indx_12.dbf'
    ORA-27041: unable to open file
    SVR4 Error: 2: No such file or directory Additional information: 3

    Many thanks in advance

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >I thought about touching a
    >0 block file in the correct path - would this resolve the issue?
    NO

    Ask Tom "How to drop a datafile ?"
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jun 2010
    Posts
    81
    Other than 'no' do you have any constructive suggestion or a work around to resolve?

    thanks

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    you are free to read or ignore the URL I posted
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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