SAP Knowledge Base Article - Preview

1833169 - ORA-03149 occurs when calculate the space statistic using brconnect

Symptom

ORA-03149 occurs in upgrade phase PREP_SPACECALC/TABSPC_PREP when calculate the space statistic using brconnect. This case is observed during the system upgrade from SAP NETWEAVER 7.0 to SAP NETWEAVER 7.3 or higher.

/usr/sap/<SID>/SUM/abap/log/ORA_COLLSPCSTAT.LOG:

EXECUTING /usr/sap/<SID>/SUM/abap/exe/brconnect (brconnect) -u -p /usr/sap/<SID>/SUM/abap/tmp/SPACESTAT.LST -c -f stats -m +I -f allsel,collect,method,space -p 4 -RDB

BR0801I BRCONNECT 7.20 (8)

:

BR0301E SQL error -3149 in thread 2 at location lob_space_get-12, SQL statement:

'EXECUTE stmt_2a'

'BEGIN DBMS_SPACE.UNUSED_SPACE (SEGMENT_OWNER => 'SAPDBS', SEGMENT_NAME => 'SYS_LOB0000011300C00017$$', SEGMENT_TYPE => 'LOB', TOTAL_BLOCKS => :tblocks, TOTAL_BYTES => :tbytes, UNUSED_BLOCKS => :ublocks, UNUSED_BYTES => :ubytes, LAST_USED_EXTENT_FILE_ID => :lfile_id, LAST_USED_EXTENT_BLOCK_ID => :lext_id, LAST_USED_BLOCK => :lblock_nr); END;'

ORA-03149: Invalid Oracle error code

 :

BR0280I BRCONNECT time stamp: 2012-12-04 12.17.56

BR0804I BRCONNECT terminated with errors

SAPup> Process with PID 29399 terminated with status 3 at 20121204121756!


Read more...

Environment

  • SAP release independent
  • Oracle release 11g
  • Br*tools release 720

Product

SAP NetWeaver 7.3

Keywords

ORA-03149, brconnect, ORA_COLLSPCSTAT, PREP_SPACECALC/TABSPC_PREP, SPACESTAT.LST, collect space statistic, space statistic, ORA 3149 , KBA , BC-DB-ORA , Oracle , BC-UPG-PRP , Upgrade Preparation , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.