Skip to Content
avatar image
Former Member

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Jul 15, 2011 at 05:08 PM

    Hi,

    Check SAP note 869006.

    Thanks

    Sunny

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 16, 2011 at 06:38 AM

    Thanks for your response, Sunny. I did some investigation on the ORA-12560 error as well as the note you mentioned. It seems like the shared memory pool is insufficient. After checking my INIT.ORA file, it looks like there was only 128MB assigned to the shared memory pool.

    So, next step is to amend the setting SHARED_POOL_SIZE in Oracle but I am unable to do so.

    I have done the following:-

    1) Set ORACLE_HOME to "C:\oracle\R3E\10.2.0" in Environment Variables

    2) Set ORACLE_SID to "R3E" in Environment Variables

    3) Tried to use sqlplus / as sysdba but I still receive TNS Protocol Error.

    Any ideas, anyone?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 18, 2011 at 04:16 AM

    With which user you are trying to connect?

    Is the user has permissions on ORACLE_HOME directory?

    Regards,

    Nick Loy

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      Just thought I'd update this thread in case anyone faced the same problem. I resolved the problem by doing the following:-

      1) The error popped up because the SQL statement that the R3 installation was trying to run requires more memory that was assigned to the shared_pool_size. The Oracle SGA (Global Memory Allocation) was insufficient (only 90MB), causing the shared_pool_size to be too small.

      2) I modified the shared_pool_size in initXXX.ora in %ORACLE HOME%/XXX/database to a larger size. Shut down the Oracle DB, restarting it using the PFILE initXXX.ora.

  • avatar image
    Former Member
    Jul 18, 2011 at 06:01 AM

    Increase shared pool size in Oracle settings.

    Add comment
    10|10000 characters needed characters exceeded