solution manager 4.0 SR2 installation error at Step 17 data load.

[Former Member]

hi,

I am seeing following errors - any help ?

DbSl Trace: OCI-call 'OCILobWrite' failed: rc = 4031

DbSl Trace: ORA-4031 occurred when writing to a LOB

(IMP) ERROR: DbSlExeModify/DbSlLobPutPiece failed

rc = 99, table "REPOSRC"

(SQL error 4031)

error message returned by DbSl:

ORA-04031: unable to allocate 4120 bytes of shared memory ("shared pool","select con# from con$ where ...","Typecheck","seg:k

ggfaAllocSeg")

(DB) INFO: disconnected from DB

/usr/sap/S01/SYS/exe/run/R3load: job finished with 1 error(s)

/usr/sap/S01/SYS/exe/run/R3load: END OF LOG: 20070522165654

/usr/sap/S01/SYS/exe/run/R3load: START OF LOG: 20070522170756

/usr/sap/S01/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#8 $ SAP

/usr/sap/S01/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]

Compiled Aug 29 2006 01:46:12

/usr/sap/S01/SYS/exe/run/R3load -i SAPSSEXC.cmd -dbcodepage 4102 -l SAPSSEXC.log -stop_on_error

DbSl Trace: ORA-1403 when accessing table SAPUSER

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8

(DB) INFO: REPOSRC deleted/truncated #20070522170802

DbSl Trace: ORA-4031 occurred when executing SQL statement (parse error offset=12)

(IMP) ERROR: DbSlExeModify/DbSlLobPutPiece failed

rc = 99, table "REPOSRC"

(SQL error 4031)

[Former Member]

Basically it's an overflow of shared memory.Either you have to reduce your use of shared memory, or you have to increase the amount of available shared memory by increasing the value of the initialization parameters SHARED_POOL_RESERVED_SIZE and SHARED_POOL_SIZE. Later If you find thatyour large pool is out of memory, increase the initialization parameter LARGE_POOL_SIZE. Hope this will work.

Need to increase the shared shared_pool_size by adding the sga_max_size parameter accordingly.