Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

SAP R3 Enterprise Installation Failure

Dear all, need your help on this. I am having some problems with DB instance installation.

Installation: SAP R3 4.7 IDES

Operating System: Windows Server 2003 SP2

Database: Oracle 10.2.0.4.0

Procedures: Finished CI, Installing DB instance in single machine

As I am about to finish the Database Load process (Phase 22), I am shown an error message box. Upon inspection of the message box, I find two logs which contain errors.

ERROR 2012-11-30 23:20:59

MSC-01015 Process finished with error(s), check log file C:\Program Files\sapinst_instdir\R3E47X2\SYSTEM\ABAP\ORA\NUC\DB/SAPSSEXC.log

ERROR 2012-11-30 23:20:59

MSC-01015 Process finished with error(s), check log file C:\Program Files\sapinst_instdir\R3E47X2\SYSTEM\ABAP\ORA\NUC\DB/SAPAPPL2.log

Looking into the logs, this is what was found:-

SAPSSEXC.log

(DB) ERROR: DDL statement failed

(CREATE TABLE "REPOSRC" ( "PROGNAME" VARCHAR2(40) DEFAULT ' ' NOT NULL , "R3STATE" VARCHAR2(1) DEFAULT ' ' NOT NULL , "SQLX" VARCHAR2(1) DEFAULT ' ' NOT NULL , "EDTX" VARCHAR2(1) DEFAULT ' ' NOT NULL , "DBNA" VARCHAR2(2) DEFAULT ' ' NOT NULL , "CLAS" VARCHAR2(4) DEFAULT ' ' NOT NULL , "TYPE" VARCHAR2(3) DEFAULT ' ' NOT NULL , "OCCURS" VARCHAR2(1) DEFAULT ' ' NOT NULL , "SUBC" VARCHAR2(1) DEFAULT ' ' NOT NULL , "APPL" VARCHAR2(1) DEFAULT ' ' NOT NULL , "SECU" VARCHAR2(8) DEFAULT ' ' NOT NULL , "CNAM" VARCHAR2(12) DEFAULT ' ' NOT NULL , "CDAT" VARCHAR2(8) DEFAULT '00000000' NOT NULL , "VERN" VARCHAR2(6) DEFAULT ' ' NOT NULL , "LEVL" VARCHAR2(4) DEFAULT ' ' NOT NULL , "RSTAT" VARCHAR2(1) DEFAULT ' ' NOT NULL , "RMAND" VARCHAR2(3) DEFAULT ' ' NOT NULL , "RLOAD" VARCHAR2(1) DEFAULT ' ' NOT NULL , "UNAM" VARCHAR2(12) DEFAULT ' ' NOT NULL , "UDAT" VARCHAR2(8) DEFAULT '00000000' NOT NULL , "UTIME" VARCHAR2(6) DEFAULT '000000' NOT NULL , "DATALG" NUMBER(10) DEFAULT 0 NOT NULL , "VARCL" VARCHAR2(1) DEFAULT ' ' NOT NULL , "DBAPL" VARCHAR2(1) DEFAULT ' ' NOT NULL , "FIXPT" VARCHAR2(1) DEFAULT ' ' NOT NULL , "SSET" VARCHAR2(1) DEFAULT ' ' NOT NULL , "SDATE" VARCHAR2(8) DEFAULT '00000000' NOT NULL , "STIME" VARCHAR2(6) DEFAULT ' ' NOT NULL , "IDATE" VARCHAR2(8) DEFAULT '00000000' NOT NULL , "ITIME" VARCHAR2(6) DEFAULT ' ' NOT NULL , "LDBNAME" VARCHAR2(20) DEFAULT ' ' NOT NULL , "UCCHECK" VARCHAR2(1) DEFAULT ' ' NOT NULL , "MAXLINELN" NUMBER(5) DEFAULT 0 NOT NULL , "DATA" BLOB ) TABLESPACE PSAPR3E620 STORAGE (INITIAL 1194213376 NEXT 0000040960K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) )

DbSlExecute: rc = 99

(SQL error 604)

error message returned by DbSl:

ORA-00604: error occurred at recursive SQL level 3

ORA-04031: unable to allocate 4108 bytes of shared memory ("shared pool","select i.obj#,i.ts#,i.file#,...","Typecheck","seg:kggfaAllocSeg")

(DB) INFO: disconnected from DB

SAPAPPL2.log

(DB) ERROR: DDL statement failed

(CREATE TABLE "TVCPF" ( "MANDT" VARCHAR2(3) DEFAULT '000' NOT NULL , "FKARN" VARCHAR2(4) DEFAULT ' ' NOT NULL , "AUARV" VARCHAR2(4) DEFAULT ' ' NOT NULL , "LFARV" VARCHAR2(4) DEFAULT ' ' NOT NULL , "FKARV" VARCHAR2(4) DEFAULT ' ' NOT NULL , "PSTYV" VARCHAR2(4) DEFAULT ' ' NOT NULL , "GRBED" VARCHAR2(3) DEFAULT '000' NOT NULL , "GRURK" VARCHAR2(3) DEFAULT '000' NOT NULL , "GRURP" VARCHAR2(3) DEFAULT '000' NOT NULL , "GRUKO" VARCHAR2(3) DEFAULT '000' NOT NULL , "KNPRS" VARCHAR2(1) DEFAULT ' ' NOT NULL , "PLMIN" VARCHAR2(1) DEFAULT ' ' NOT NULL , "FKMGK" VARCHAR2(1) DEFAULT ' ' NOT NULL , "POSVO" VARCHAR2(1) DEFAULT ' ' NOT NULL , "HINEU" VARCHAR2(1) DEFAULT ' ' NOT NULL , "PFKUR" VARCHAR2(1) DEFAULT ' ' NOT NULL , "EXPIM" VARCHAR2(1) DEFAULT ' ' NOT NULL , "ORDNR_FI" VARCHAR2(1) DEFAULT ' ' NOT NULL , "XBLNR_FI" VARCHAR2(1) DEFAULT ' ' NOT NULL , "PRSQU" VARCHAR2(1) DEFAULT ' ' NOT NULL , "KVPRS" VARCHAR2(1) DEFAULT ' ' NOT NULL , "PSTYN" VARCHAR2(4) DEFAULT ' ' NOT NULL ) TABLESPACE PSAPR3E STORAGE (INITIAL 2555904 NEXT 0000000040K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) )

DbSlExecute: rc = 99

(SQL error 604)

error message returned by DbSl:

ORA-00604: error occurred at recursive SQL level 1

ORA-04031: unable to allocate 4108 bytes of shared memory ("shared pool","insert into obj$(owner#,name...","Typecheck","kgghtInit")

(DB) INFO: disconnected from DB

Did anyone encounter this error before? Can someone please tell me how I can fix this error? Much appreciated.

Former Member
Not what you were looking for? View more on this topic or Ask a question