ORA-01157: cannot identify/lock data file 202 - see DBWR trace file ORA-01110: data file 202: '+DG_DATA/aup/tempfile/temp.307.773359701'

[Former Member]

Hi

I´m trying to update the portal to SP 08, I ran SUM and in the requierement checks I obtain this error

Could not execute DMT command runhandler. See previous messages. Could not check the DB free space in the temporary tablespace due to problems with the database connectivity. com.sap.sql.exception.OpenSQLException: ORA-01157: cannot identify/lock data file 202 - see DBWR trace file ORA-01110: data file 202: '+DG_DATA/aup/tempfile/temp.307.773359701' OpenSQLExceptionCategories: [] java.sql.SQLException: ORA-01157: cannot identify/lock data file 202 - see DBWR trace file ORA-01110: data file 202: '+DG_DATA/aup/tempfile/temp.307.773359701'

I check the SUM log CHECK-JDBC-DRIVER_01.LOG and see this

<!--LOGHEADER[START]/-->

<!--HELP[Manual modification of the header may cause parsing problem!]/-->

<!--LOGGINGVERSION[2.0.7.1006]/-->

<!--NAME[/usr/sap/trans/SUM4/SUM/sdt/log/SUM/CHECK-JDBC-DRIVER_01.LOG]/-->

<!--PATTERN[CHECK-JDBC-DRIVER_01.LOG]/-->

<!--FORMATTER[com.sap.tc.logging.TraceFormatter(%d [%6s]: %m)]/-->

<!--ENCODING[UTF8]/-->

<!--LOGHEADER[END]/-->

Jun 27, 2013 3:40:21 PM [Info  ]: Checking version of jdbc driver /oracle/client/10x_64/instantclient/ojdbc6.jar.

and no more info, could you please help me with this issue???

Best Regards

[former_member188883 · Accepted solution]

Hi Adriana,

Could you update th brtools as described in SAP note

Note 1763972 - Corrections in BR*Tools 7.20 patch 26

Additionally refer link as a similar issue with its resolution is explained

http://samadhandba.wordpress.com/2011/06/01/ora-01157-cannot-identifylock-data-file-ora-01110-data-f...

Hope this helps.

Regards,

Deepak Kori

[former_member206552]

Hi Adriana,

What is the status of file 202?

execute the command below and paste the output :-

SELECT * FROM V$recover_file;

SELECT * FROM DBA_DATA_FILES WHERE FILE_ID=202;

As it seems your tempfile has been lost... try to re-create it ..

ALTER TABLESPACE PSAPTEMP ADD TEMPFILE '%' SIZE 10G REUSE AUTOEXTEND OFF;

Best Regards

Marius

[Former Member]

Hi all,

I have got the same problem and I corrected that via the command below :

1 - create temporary tablespace temp2 tempfile 'NAME OF DISK GROUP ASM';

2 - alter database default temporary tablespace temp2;

3 - drop tablespace psaptemp including contents and datafiles;

After that the SUM was finished successufully.

Regards,

Philippe.