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
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.