BR0886E and error -2515

[former_member182034]

Dear all,

I just applied Oracle Patch 10205 and when i am trying to run brtools or system export then i m getting below errors.

BR0886E Checking/collecting statistics failed for table SAPSR3./1CN/CTXSAPD0004
BR0280I BRCONNECT thread 2: time stamp: 2012-01-31 10.39.34
BR0301E SQL error -25153 in thread 2 at location stats_tab_collect-20, SQL statement:
'BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => '"SAPSR3"', TABNAME
 => '"/1CN/CTXSAPR0140"', ESTIMATE_PERCENT => NULL, METHOD_OPT => 'FOR ALL COLUMNS SIZE 1', DEGREE
 => NULL, CASCADE => TRUE, NO_INVALIDATE => FALSE); END;'
ORA-25153: Temporary Tablespace is Empty

how can i rectify this error.

Regards,

[Former Member · Accepted solution]

Hi,

>> ORA-25153: Temporary Tablespace is Empty

Did you created a temporary tablespace? You can check it on DB02

Best regards,

Orkun Gedik

[Former Member · Accepted solution]

DB02 -> Space -> Tablespaces -> Overview

Check the sizeof (PSAPTEMP). It shouldn't be "0" length

Best regards,

Orkun Gedik

[former_member182034 · Accepted solution]

hi Orkun,

the status of PSAPTEMP is:

PSAPTEMP 	0.00 	0.00 	0 	NO 	0.00 	0.00 	0 	0 	0 	0 	ONLINE 	TEMPORARY 	DISABLED

now i have to extend this PSAPTEMP but tell me value?

Regards,

[Former Member · Accepted solution]

Hi Jamil,

Modify the statements below regarding your needs and apply;

CREATE TEMPORARY TABLESPACE "PSAPTEMP1" TEMPFILE '/oracle/<SID>/sapdata<x>/temp_2/TEMP.DATA2' SIZE <Size of temporary tablespace> reuse autoextend off;

ALTER DATABASE DEFAULT TEMPORARY TABLESPACE PSAPTEMP1;

DROP TABLESPACE PSAPTEMP INCLUDING CONTENTS;

CREATE TEMPORARY TABLESPACE "PSAPTEMP" TEMPFILE '/oracle/<SID>/sapdata<x>/temp_1/TEMP.DATA1' SIZE <Size of temporary tablespace> reuse autoextend off;

ALTER DATABASE DEFAULT TEMPORARY TABLESPACE PSAPTEMP;

DROP TABLESPACE PSAPTEMP1 INCLUDING CONTENTS;

Best regards,

Orkun Gedik

[former_member182034 · Accepted solution]

hi Orkun,

thx respected Orkun for your reply.

dear. that error resolved but now getting following error.

3 + Delete harmful statistics

BR0292I Execution of BRCONNECT finished with return code 1
BR0668I Warnings or errors occurred - you can continue to ignore them or go back
 to repeat the last action
BR0280I BRTOOLS time stamp: 2012-01-31 16.29.32
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

please explain why Return Code 1 is occurring.

and

there are 4 temp files (TEMP.DATA1,TEMP.DATA2,TEMP.DATA3.TEMP.DATA4) in sapdata1/. may i delete these file or not.

please send me delete/drop commands for TEMP.DATA2,3,4 files and how can i check the active TEMP file?

Regards,

[Former Member · Accepted solution]

Hi my friend,

"Return Code 1" means that the execution with warning(s). You can check the error details on "c<encoded timestamp>.dst" and "conn<SID>.log", under "/oracle/<SID>/sapcheck"

Best regards,

Orkun Gedik

[former_member204080]

Hi ,

See this notes

Note 164925 - Storage parameter of tablespace PSAPTEMP

[Former Member]

>> there are 4 temp files (TEMP.DATA1,TEMP.DATA2,TEMP.DATA3.TEMP.DATA4) in sapdata1/. may i delete these file or not.

>> please send me delete/drop commands for TEMP.DATA2,3,4 files and how can i check the active TEMP file?

First you need to identify what datafile(s) are belong to the PSAPTEMP;

select file_name from dba_temp_files;

Then you can rename first, the unused files. Then, delete the files on the operating system

Best regards,

Orkun Gedik

[former_member182034]

Dear,

you check the result of mentioned commands

SQL> select file_name from dba_temp_files;

FILE_NAME
----------------------------------------------

G:\ORACLE\PRD\SAPDATA1\TEMP_2\TEMP.DATA1

while these files(TEMP.DATA2, TEMP.DATA3,TEMP.DATA4) are exist in G:\oracle\PRD\sapdata1\temp_1,temp_2,temp_3?

how can i remove above file?

Regards,

[Former Member]

Hi my friend,

Rename TEMP.DATA2, TEMP.DATA3,TEMP.DATA4 to the TEMP.DATA2.old, TEMP.DATA3.old,TEMP.DATA4.old, for example.

If you are able to rename the files without stopping the database, to be at the safe side, keep them until tomorrow. Then, you can delete them safely.

Best regards,

Orkun Gedik