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
- verification because cannot failed 01187verification because cannot failed quot hashcode because cannot filenotfoundexception resource because cannot verification connection jenkins failed resource because cannot opened verification机器failed host configuration installing because failed spring-mvc because spring cannot 01187 verification