SAP Knowledge Base Article - Preview

3322903 - SWPM / EHP ORA-00604 ORA-06512 . . . ORA-01653: unable to extend table SYS.* tablespace SYSTEM . . . ORA-01654: unable extend index SYS.*tablespace SYSTEM

Symptom

  ORA-01653: unable to extend table SYS.SOURCE$ by ## in tablespace SYSTEM
  
  instdir_sapinst_dev.log
   line ##### {errorMessage: 'ORA-00604: error occurred at recursive SQL level 1
     {errorMessage: 'ORA-00604: error occurred at recursive SQL level 1
       ORA-06512:
        . . .
         at SYS.UTL_RECOMP, line ### ORA-06512:
          . . .
           ORA-00604: error occurred at recursive SQL level 1
           ORA-01653: unable to extend table SYS.SOURCE$ by ##
            tablespace SYSTEM

also

SWPM complains about tables not existing with below error:
instdir_sapinst.log
...
A2 ETSK 000 Starting import for object "SVERS" of type "table" #YYYYMMDD24MMss
A1 EDMP 003 Export data appears to be unsorted.
A1 EFLL 000 Loading fast loader library '/usr/sap/SID/ci_install/sapinst_instdir/BS2013SR2/ERP607SR2/ORA/INSTALL/STD/ABAP/R3ldfldorash.so'.
A1EEIMP 008 Task failed with error: (DBS) 'DBInitFastload' failed
A1EEIMP 008 cannot prepare direct path
A1EEIMP 008 Oracle error (-1): ORA-00604: error occurred at recursive SQL level 1
A1EEIMP 008 ORA-00942: table or view does not exist

also

instdir_sapinst.log
   ERROR YYYY-MM-DD 24:MM:ss.msms (root/sapinst) id=nw.programError errno=CJS-30022

also

sapinst_dev.log
. . .
{errorMessage: 'ORA-00604: error occurred at recursive SQL level 1\n
                ORA-06512: at \"SYS.UTL_RECOMP\", line 927\n
                ORA-06512: at \"SYS.DBMS_STATS\", line 40856\n
                ORA-06512: at \"SYS.DBMS_STATS\", line 40140\n
                ORA-06512: at \"SYS.DBMS_STATS\", line 39017\n
                ORA-06512: at \"SYS.DBMS_STATS\", line 16243\n
                ORA-01654: unable to extend index SYS.I_HH_OBJ#_COL# by 8 in tablespace SYSTEM\n

ERROR      YYYY-MM-DD HH:MM:ss.### (root/sapinst) (startInstallation) [CInstallerCallBackImpl.cpp:260]
 id=ind-rel.ind-os.ora.sqlStatementFailed errno=CJS-00084 CInstallerCallBackImpl::abortInstallation()
SQL statement or script failed. DETAILS: Error message:
ORA-00604: error occurred at recursive SQL level 1
ORA-06512: at "SYS.UTL_RECOMP", line 927
ORA-06512: at "SYS.DBMS_STATS", line 40856
ORA-06512: at "SYS.DBMS_STATS", line 40140
ORA-06512: at "SYS.DBMS_STATS", line 39017
ORA-06512: at "SYS.DBMS_STATS", line 16243
ORA-01654: unable to extend index SYS.I_HH_OBJ#_COL# by 8 in tablespace SYSTEM
. . . 


Read more...

Environment

SWPM
EHP installation
Oracle DB

Product

ABAP platform 2023

Keywords

KBA , BC-DB-ORA , Oracle , BC-UPG-TLS-TLA , Upgrade tools for ABAP , 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.