cancel
Showing results for 
Search instead for 
Did you mean: 

SAP R3 Enterprise Installation Failure

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Increase shared pool size in Oracle settings.

Former Member
0 Kudos

With which user you are trying to connect?

Is the user has permissions on ORACLE_HOME directory?

Regards,

Nick Loy

Former Member
0 Kudos

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.

Former Member
0 Kudos

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?

sunny_pahuja2
Active Contributor
0 Kudos

Hi,

Check SAP note 869006.

Thanks

Sunny