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

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

 

posted @ 2023-12-01 13:52  雪竹子  阅读(25)  评论(0编辑  收藏  举报