unable to allocate 4108 bytes of shared memory installing Solution Mgr

[Former Member]

Hi,

While Installing Solution Manager4.0, getting following error while Impoting ABAP.

currently my oracle ora<sid>.ora has the following size

shared_pool_reserved_size = 9011200

IMMEDIATE SOLUTION IS APPRECIATED.

ERROR:

Loading of 'SAPSSEXC' import package: ERROR

Import Monitor jobs: running 2, waiting 13, completed 2, failed 1, total 18.

Loading of 'SAPAPPL2' import package: ERROR

ORA-00604: error occurred at recursive SQL level 3

ORA-04031: unable to allocate 4108 bytes of shared memory ("shared pool","select obj#,type#,ctime,mtim...","Typecheck","kgghtInit")

(DB) INFO: disconnected from DB

Thanks,

Nagesh

[Former Member]

hi dude

me too getting the same error message,

if u have fixed the issue, kindly let me know the procedure

thank u

[david_malinconici2]

Parameter shared_pool_size must be at least 400000000 (400MB) and shared_pool_reserved_size must be 10% of shared_pool_size.

Cheers

David

[former_member391923]

Hello,

Did you solve this problem? Cause I have the same issue with IDES MySAP 6.0

while Impoting ABAP.

(DB) ERROR: DDL statement failed

(CREATE TABLE "IST_EBS_TOI_SYST" ( "MANDT" VARCHAR2(9) DEFAULT '000' NOT NULL , "EXT_SYSTEM" VARCHAR2(30) DEFAULT ' ' NOT NULL , "MESTYP" VARCHAR2(90) DEFAULT ' ' NOT NULL , "MESCOD" VARCHAR2(9) DEFAULT ' ' NOT NULL , "MESFCT" VARCHAR2(9) DEFAULT ' ' NOT NULL , "BLART" VARCHAR2(6) DEFAULT ' ' NOT NULL , "EXT_NUMKRS" VARCHAR2(3) DEFAULT ' ' NOT NULL , "FLD_VKONT_ID" VARCHAR2(3) DEFAULT ' ' NOT NULL , "XNETT" VARCHAR2(3) DEFAULT ' ' NOT NULL , "CONDENSE_OP" VARCHAR2(3) DEFAULT ' ' NOT NULL , "SEG_NAME" VARCHAR2(81) DEFAULT ' ' NOT NULL ) TABLESPACE PSAPSR3 STORAGE (INITIAL 16384 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","select name,intcol#,segcol#,...","Typecheck","kgghtInit")

(DB) INFO: disconnected from DB

Please tell me if your problem was resolved somehow.

Thx,

Paul