Remote Client Copy, errors

[former_member226585]

Hello.

during a client copy, there are errors in the source sm21

Database error 1157 at SEL access to table MOFF
> ORA-01157: cannot identify / lock data file 385 - see DBWR
> Trace file # ORA-01110: data file 385:
> '+ DGEXA1/a03/tempfile/temp.327.802031219'
Runtime error "TIME_OUT" occurred.
> Short dump "130613 162953 mir-sap24_A03_00 SAP *" created.

Can not copy the two tables

CKMLPR CO-PC-ACT RFC Error
MOFF LO-MD-MM RFC Error
MOFF LO-MD-MM Read or Conversion Error

In the systems, no one works .... in CM12 no locks ... What to do?

[former_member206552 · Accepted solution]

Hi Evgeniy

Seems to be a problem with the temp tablespace, try and recreate it and retry

the below link explains how

http://sapbasisguys.blogspot.de/2012/07/re-creating-psaptemp-on-oracle.html

Best Regards

Marius

[former_member226585]

after apply command

ALTER DATABASE DEFAULT TEMPORARY TABLESPACE PSAPTEMP;

in source system, after re processing create new errors

Database error 25153 at SEL access to table MOFF
> ORA-25153: Temporary Tablespace is Empty

what to do?

[former_member206552]

This message means you have a temporary tablespace with NO datafiles. Check the output from

select tablespace_name,file_name from dba_temp_files;

1. select property_value from database_properties where property_name like '%DEFAULT_TEMP_TABLESPACE%';

Say the default tablespace name is TEMP

2. Select name from v$tempfile;

If output is "no row selected" then ;

3. Alter tablespace TEMP add tempfile 'LOCATION\NAME.DBF' size 1024m autoextend on;

[former_member226585]

This message was moderated.

[Former Member]

Hi Evgeniy,

>> ORA-01157: cannot identify / lock data file 385 - see DBWR

This error occurs when the Oracle cannot open the file.

Firstly, execute the statement, below;

SQL> ALTER SYSTEM CHECK DATAFILES;

If not works, please check the document;

http://learnwithme11g.wordpress.com/2011/01/07/ora-01157-cannot-identifylock-data-file/

Best regards,

Orkun Gedik