Ora-01187
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Ora-01187

  1. #1
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857

    Ora-01187

    oracle 817 solaris 8

    hello again,
    I have this problem with one of my tablespace(USRTMP), though this is a temporary tablespace(LOCALly managed), I can't seem to bring it down or up. I already reassigned the temporary tablespace of users used to be assigned in the USRTMP to ther TEMP TBS, so nothing to worry when it comes to availability of the DB.

    What I did as far as I can remember, one of our mount drive /c1t05 was full. And the only possible tbs that I can alter to free-up some space is the that is being used by either RBS or TEMP TBS. I have made changes to both, RBS was alright but USRTMP temp tbs was not.
    I made my changes through OEM, but the equivalent SQL is:
    ALTER DATABASE TEMPFILE '/c1t05/....../USRTMP.dbf' offline;

    It didn't prompt me of error, but today when I query the tablespace in OEM, it prompt me this error(ORA-01187/ORA01110).

    here's what oracle docs says regarding this error:
    ---------------------------------
    ORA-01187 cannot read from file string because it failed verification tests

    Cause: The datafile did not pass the checks to insure it is part of the database. Reads are not allowed until it is verified.

    Action: Make the correct file available to the database. Then, either open the database, or execute ALTER SYSTEM CHECK DATAFILES.
    --------------------------
    ORA-01110 data file string: 'string'

    Cause: This message reports the file name involved with other messages.

    Action: See the associated messages for a description of the problem.
    ---------------------------------------------------------

    I already do the ALTER SYSTEM CHECK DATAFILES command, but still the same error occured.
    Where did I miss guys?

    Thanks in Advance,
    rey

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    If no trnasactions are using that temp tbs, you cna drop and recreate it.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  3. #3
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    sanjay just beat me to it

    Since it's temporary why don't you just try droping it and recreate it?
    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

  4. #4
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    Originally posted by SANJAY_G
    If no trnasactions are using that temp tbs, you cna drop and recreate it.
    thanks SANJAY,
    I just did drop the tempfile and do the alter system check datafiles
    and it worked.

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