Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    ORA-01187 cannot read from file 201 because it failed verification tests..temp01

     

    • Product: Aleph
    • Product Version: 20, 21, 22, 23
    • Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care

     

    Description:
    We get this message in running the Upgrade Express 20-21 export (create_customer_data):
    ORA-01187: cannot read from file 201 because it failed verification tests
    ORA-01110: data file 201: '/exlibris/oradata/aleph20/aleph20_temp01.dbf'
    ORA-06512: at "SYS.DBMS_LOB", line 555
    ORA-06512: at "SYS.DBMS_DATAPUMP", line 3487

    util o/14/1 also shows the error message for tablespace TEMP:
    ERROR at line 1:
    ORA-01187: cannot read from file 201 because it failed verification tests
    ORA-01110: data file 201: '/exlibris/oradata/aleph20/aleph20_temp01.dbf'

     

    Resolution:
    If you have a DBA, that person should handle the following dropping/recreating of the TEMP tablespace....

    We used the instructions found at http://dbaspot.com/database-discussi...-tempfile.html
    > s+ aleph_admin
    aleph_admin@ALEPH20> create temporary tablespace temp1
    2 tempfile '/oradata/10g/oracle/temp101.dbf' size 64M;
    tempfile '/exlibris/oradata/aleph20/aleph20_temp101.dbf' size 64M;

    Tablespace created.

    aleph_admin@ALEPH20> alter database default temporary tablespace temp1;

    Database altered.

    aleph_admin@ALEPH20> quit


    > sudo su - root [logon as root to drop the temp01.dbf datafile]
    root...> cd /exlibris/oradata/aleph20/
    root...> rm temp01.dbf
    root...> exit


    > s+ aleph_admin

    aleph_admin@ALEPH20> drop tablespace temp ;

    Tablespace dropped.

    aleph_admin@ALEPH20> create temporary tablespace temp
    2 tempfile '/oradata/10g/oracle/temp01.dbf'
    3 size 128M autoextend on next 64M maxsize 257M
    4 extent management local;

    tempfile '/exlibris/oradata/aleph20/aleph20_temp01.dbf' 
    size 64M;

    Tablespace created.

    aleph_admin@ALEPH20> alter database default temporary tablespace temp;

    Database altered.


    SQL> drop tablespace temp1 including contents and datafiles;

    Tablespace dropped.

    aleph_admin@ALEPH20> create temporary tablespace temp
    tempfile '/exlibris/oradata/aleph20/aleph20_temp01.dbf'
    size 128M autoextend on next 64M maxsize 257M
    extent management local;


    After which, util o/14/1 showed a proper listing for tablespace TEMP:

    Temporary Tablespace Space Usage

    TABLESPACE_NAME SIZE M
    ------------------------------ ----------
    TEMP 115.063206

    Sort Segments Usage (in Temporary Tablespace)

    TABLESPACE_NAME Total M Used M Free M
    ------------------------------- ---------- ---------- ----------
    TEMP 12 5 7

     

     


    • Article last edited: 12-Mar-2016