ORA-01157: Cannot identify/lock data file 203 & ORA-01110:datafile 203:'..../dbs/TS_TEMP'

Posted on 2004-11-12
Last Modified: 2013-12-11

Working Oracle 9 & Linux Red Hat. I cannot access any TEM partitions & the above error are  displayed.

At the same time the SYSTEM ROLLBACK statements display a new extension with a size of 0 bytes & I do not know
how to modify such value as an error ORA-30019 is displayed when I tried to modify it.

I also did a shutdown immediate  & and then a RESTART but the same error still happens.

Can you give me any advise?




Question by:egomeze
    LVL 6

    Expert Comment

    What is the exact version of Oracle 9 that you are using?

    Also what are the exact (and full) error messages?

    Is there any additional information in the alert log?

    This sounds like it might be similar to a bug I ran into earlier this year with a tablespace (TEMP or otherwise) that extends over certain size boundries.



    Author Comment


    Database Version   with LINUX RED HAT         : Oracle9i Enterprise Edition Release

    Detailed Errors Description:
    There are several error messages for instance logging in as system/manager and trying to display the TABLE PARTITIONS
    running the TOAD tool it displays:
    ORA-01157: no se puede identificar/bloquear el archivo de datos 203 - consulte el archivo de rastreo del DBWR
    ORA-01110: archivo de datos 203: '/oracle/app/oracle/product/9.2.0/dbs/TS_tec_temp'.

    Other Table Partitions seems to be OK.

    If i try to see (with TOAD)  the SYSTEM ROLLBACK SEGMENTS

    Status,                                                    ONLINE
    Owner                                                     SYS
    Tablespace,                                             SYSTEM
    Segment Id,                                             0
    Block Number,                                          9
    Initial Extent,                                            114688
     Next Extent,                                             0
     Min Extents,                                             1
     Max Extents,                                            32765
     Pct Increase of Next Extent,                       0
     Parallel Server Instance,                           0
     Datafile name                                          /usr1/system/.......System01.dbf

    So it seems to me that NEXT EXTENSION has a size o 0 bytes and I do not know how to change that.

    Regarding the ALERT.LOG file I am not sure If I Am displaying the right one (sorry) :
    The file /oracle/product/9.2.0/rdbms/log/alert_BBDD01.log  is NOT DISPLAYING any errors.


    LVL 47

    Accepted Solution

    If this is a TEMPORARY tablespace then using OEM
    create anothet TEMP tablespace TEMP1, making it default temporary
    and after that drop the current one.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
    Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
    This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
    This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now