Former Member

Nov 17, 2008 at 02:51 AM

Solman 4.0 Installation fails

25 Views

Dear Guru's,

Im trying to install Solman 4.0 with Oracle 10g on Win2k3 OS and the hardware sizing is given below

RAM 1 GB

Disk Space 58 GB

Virtual Memory 2048 -4096 MB

When the installation is at the Import ABAP phase it gets cancelled due to the following error's which I

have observed from log files as given below.

***********************************************************************************************************************

ERROR: 2008-11-16 16:16:50 com.sap.inst.migmon.LoadTask run

Loading of 'SAPSSEXC' import package is interrupted with R3load error.

Process 'C:\usr\sap\SM0\SYS\exe\uc\NTI386\R3load.exe -i SAPSSEXC.cmd -dbcodepage 4103 -l SAPSSEXC.log -stop_on_error' exited with return code 2.

For mode details see 'SAPSSEXC.log' file.

IMP) ERROR: DbSlExeModify/DbSlLobPutPiece failed

rc = 99, table "DOKIL"

(SQL error 4031)

error message returned by DbSl:

ORA-04031: unable to allocate 16 bytes of shared memory ("shared pool","INSERT INTO "DOKIL" ( "ID", ...","sql area","tmp")

(DB) INFO: disconnected from DB

C:\usr\sap\SM0\SYS\exe\uc\NTI386\R3load.exe: job finished with 1 error(s)

C:\usr\sap\SM0\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20081116185731

Standard error output:

sapparam: sapargv( argc, argv) has not been called.

sapparam(1c): No Profile used.

sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

-

ERROR: 2008-11-16 16:24:09 com.sap.inst.migmon.LoadTask run

Loading of 'SAPAPPL2' import package is interrupted with R3load error.

Process 'C:\usr\sap\SM0\SYS\exe\uc\NTI386\R3load.exe -i SAPAPPL2.cmd -dbcodepage 4103 -l SAPAPPL2.log -stop_on_error' exited with return code 2.

For mode details see 'SAPAPPL2.log' file.

(DB) ERROR: DDL statement failed

(CREATE UNIQUE INDEX "LXE_PC_TTX_V~0" ON "LXE_PC_TTX_V" ( "CUSTMNR", "OBJTYPE", "OBJNAME", "S_LANG", "T_LANG", "TEXTKEY", "XLNECNT" ) TABLESPACE PSAPSR3 STORAGE (INITIAL 16384 NEXT 0000081920K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) )

DbSlExecute: rc = 99

(SQL error 604)

error message returned by DbSl:

(DB) ERROR: DDL statement failed

(CREATE UNIQUE INDEX "LXE_PC_TTX_V~0" ON "LXE_PC_TTX_V" ( "CUSTMNR", "OBJTYPE", "OBJNAME", "S_LANG", "T_LANG", "TEXTKEY", "XLNECNT" ) TABLESPACE PSAPSR3 STORAGE (INITIAL 16384 NEXT 0000081920K 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 2

ORA-04031: unable to allocate 4108 bytes of shared memory ("shared pool","select col#, grantee#, privi...","Typecheck","seg:kggfaAllocSeg")

(DB) INFO: disconnected from DB

C:\usr\sap\SM0\SYS\exe\uc\NTI386\R3load.exe: job finished with 1 error(s)

C:\usr\sap\SM0\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20081116190216

Standard error output:

sapparam: sapargv( argc, argv) has not been called.

sapparam(1c): No Profile used.

sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

-

ERROR: 2008-11-16 16:28:33 com.sap.inst.migmon.LoadTask run

Loading of 'SAPAPPL1' import package is interrupted with R3load error.

Process 'C:\usr\sap\SM0\SYS\exe\uc\NTI386\R3load.exe -i SAPAPPL1.cmd -dbcodepage 4103 -l SAPAPPL1.log -stop_on_error' exited with return code 2.

For mode details see 'SAPAPPL1.log' file.

(DB) ERROR: DDL statement failed

(CREATE TABLE "SMODATAOFFH" ( "MANDT" VARCHAR2(9) DEFAULT '000' NOT NULL , "SFADATAOFFH" VARCHAR2(96) DEFAULT ' ' NOT NULL , "SFAOBJEKT" VARCHAR2(96) DEFAULT ' ' NOT NULL , "SEMROW" VARCHAR2(12) DEFAULT '0000' NOT NULL , "SEMCOL" VARCHAR2(12) DEFAULT '0000' NOT NULL , "SEMVALUE" VARCHAR2(210) DEFAULT ' ' NOT NULL , "TR_USER" VARCHAR2(96) DEFAULT ' ' NOT NULL , "TR_ID" VARCHAR2(96) DEFAULT ' ' NOT NULL , "TR_STATUS" VARCHAR2(12) DEFAULT ' ' NOT NULL , "TIMESTAMP" NUMBER(15,0) DEFAULT 0 NOT NULL , "DELETED" VARCHAR2(3) DEFAULT ' ' NOT NULL , "TR_ROOTID" VARCHAR2(96) DEFAULT ' ' NOT NULL , "SEMINPUT" VARCHAR2(3) DEFAULT ' ' NOT NULL ) TABLESPACE PSAPSR3 STORAGE (INITIAL 16384 NEXT 0000002560K 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 name,intcol#,segcol#,...","Typecheck","seg:kggfaAllocSeg")

(DB) INFO: disconnected from DB

C:\usr\sap\SM0\SYS\exe\uc\NTI386\R3load.exe: job finished with 1 error(s)

C:\usr\sap\SM0\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20081116185802

Standard error output:

sapparam: sapargv( argc, argv) has not been called.

sapparam(1c): No Profile used.

sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

-

ERROR: 2008-11-16 16:30:55 com.sap.inst.migmon.LoadTask run

Loading of 'SAPAPPL0' import package is interrupted with R3load error.

Process 'C:\usr\sap\SM0\SYS\exe\uc\NTI386\R3load.exe -i SAPAPPL0.cmd -dbcodepage 4103 -l SAPAPPL0.log -stop_on_error' exited with return code 2.

For mode details see 'SAPAPPL0.log' file.

(DB) ERROR: DDL statement failed

(CREATE UNIQUE INDEX "OBJSUBT~0" ON "OBJSUBT" ( "LANGUAGE", "OBJECTNAME", "OBJECTTYPE", "SUBOBJNAME" ) TABLESPACE PSAPSR3 STORAGE (INITIAL 324104 NEXT 0000000160K 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 2

ORA-04031: unable to allocate 4108 bytes of shared memory ("shared pool","select name,intcol#,segcol#,...","Typecheck","kgghtInit")

(DB) INFO: disconnected from DB

C:\usr\sap\SM0\SYS\exe\uc\NTI386\R3load.exe: job finished with 1 error(s)

C:\usr\sap\SM0\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20081116185802

Standard error output:

sapparam: sapargv( argc, argv) has not been called.

sapparam(1c): No Profile used.

sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

WARNING: 2008-11-16 16:31:22

Cannot start import of packages with views because not all import packages with tables are loaded successfully.

WARNING: 2008-11-16 16:31:22

4 error(s) during processing of packages.

INFO: 2008-11-16 16:31:22

Import Monitor is stopped.

-

Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_09-b05)

Java HotSpot(TM) Client VM (build 1.4.2_09-b05, mixed mode)

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

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

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

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

Loading of 'SAPAPPL2' import package: ERROR

Loading of 'SAPSSEXC' import package: ERROR

Loading of 'SAPAPPL0' import package: ERROR

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

Loading of 'SAPAPPL1' import package: ERROR

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

ERROR 2008-11-16 21:18:37

CJSlibModule::writeError_impl()

CJS-30022 Program 'Migration Monitor' exits with error code 103. For details see log file(s) import_monitor.java.log, import_monitor.log.

ERROR 2008-11-16 21:18:37

FCO-00011 The step runMigrationMonitor with step key |NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|9|0|NW_ABAP_Import_Dialog|ind|ind|ind|ind|5|0|NW_ABAP_Import|ind|ind|ind|ind|0|0|runMigrationMonitor was executed with status ERROR .

***********************************************************************************************************************

Up to my level of understanding all the imports of packages failed due to "unavailablity to allocate the

required shared memory". But, can anyone please suggest me how to allocate the sufficient SM for avoiding this problem and also is this related to increasing the RAM size.

I would appreciate if somebody suggest me the optimal H/W requirements for smooth installation also

whether I need to restart the installation freshly if I add more RAM size.

Awating your response at the earliest.

Best Regards,

S. Viswanathan