Resolving Tempfile is failing verification test or the error message ORA-01187: cannot read from file because it failed verification tests + ORA-01110 on tempfiles

Following are the commands and steps to resolve  ORA-01187: cannot read from file because it failed verification tests + ORA-01110 on tempfiles

-----Tempfile drop and recreate----

 

--Enable restricted session 

ALTER SYSTEM ENABLE RESTRICTED SESSION;

--Create another Temporary Tablespace TEMP1

CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE  'D:\app\oracle\oradata\......\TEMP02.DBF' SIZE 2G;

 

--Move Default Database temp tablespace

ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP1;

--shutdown database

shutdown immediate;

--startup database

startup;

--Drop the original temp tablespace.

DROP TABLESPACE TEMP INCLUDING CONTENTS AND DATAFILES;

--Create TEMP tablespace

 

CREATE TEMPORARY TABLESPACE TEMP TEMPFILE 'D:\app\oracle\oradata\.......\TEMP01.DBF' SIZE 2G;

--Make TEMP as default tablespace

ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP;

--shutdown database

shutdown immediate;

--startup database

startup;

--Drop temporary for tablespace temp1

 

DROP TABLESPACE TEMP1 INCLUDING CONTENTS AND DATAFILES;

ALTER SYSTEM DISABLE RESTRICTED SESSION;