Problem in Unicode Upgrade on HP-Unix and Oracle SAP System

[Former Member]

Hi all,

While doing an unicode upgrade, during the export phase the r3szchk is running for a long time when I checked the log files I found the errors as given below,

BR0801I BRCONNECT 6.40 (42)

BR0805I Start of BRCONNECT processing: cdxbxreu.chk 2008-01-21 10.33.36

BR0484I BRCONNECT log file: /oracle/PRD/sapcheck/cdxbxreu.chk

BR0280I BRCONNECT time stamp: 2008-01-21 10.33.39

BR0301E SQL error -1157 at location BrTspListGet-21

ORA-01157: cannot identify/lock data file 255 - see DBWR trace file

ORA-01110: data file 255: '/oracle/PRD/sapdata5/temp'

BR0806I End of BRCONNECT processing: cdxbxreu.chk 2008-01-21 10.33.39

BR0280I BRCONNECT time stamp: 2008-01-21 10.33.39

BR0804I BRCONNECT terminated with errors

Further debugging I found the error in one of the Oracle alert files such as,

ORA-01157: cannot identify/lock data file 255 - see DBWR trace file

ORA-01110: data file 255: '/oracle/PRD/sapdata5/temp'

ORA-27037: unable to obtain file status

HPUX-ia64 Error: 2: No such file or directory

Additional information: 3

Please share your ideas regarding the issue. I am not able to run any of the BRTOOLS process since I get the same error displayed and the BRPROCESS get terminated.

Thank you

Regards,

Vineeth

[stefan_koehler]

Hello Vineeth,

i think your datafile #255 is gone.

Please check, if there is a datafile with the name "/oracle/PRD/sapdata5/temp".

If it is missed please restore it out of a backup and recover it - if it is a temporary file just recreate it.

Btw. its recommonded to use temporary files for temp tablespaces ... it has "only" advantages.

Regards

Stefan

[Former Member]

Has this been solved already? If not, please check if the tempfile at '/oracle/PRD/sapdata5/temp' exists.

If not, then you might have to recreate the tempfiles. Logon as user oraprd and do:

oraprd > sqlplus "/ as sysdba"
SQL> alter database backup controlfile to trace;

oraprd > cd /oracle/PRD/saptrace/usertrace
oraprd > ls -ltr (check for the last actual file)

You should find the SQL statements to recreate the temp file in there:

ALTER TABLESPACE PSAPTEMP ADD TEMPFILE '/oracle/PRD/sapdata1/temp_1/temp.data1' SIZE 1048576000  REUSE AUTOEXTEND OFF;

Execute them in SQLplus and resume.

Regards, Michael