Solution Manager 4.0 Installation Problem

[Former Member]

Hi Guru's,

I'm installaing SOLMAN 4.0 with Oacle 10.2 on windows 2003 SP1.

In step no 18 of the 44, "Import abap" here is what happens:

Loading of 'SAPAPPL1' import package: OK

Import Monitor jobs: running 3, waiting 1, completed 14, failed 0, total 18.

Loading of 'SAPAPPL2' import package: ERROR

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

Loading of 'SAPSSEXC' import package: ERROR

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

Loading of 'SAPAPPL0' import package: ERROR

Import Monitor jobs: running 0, waiting 1, completed 14, failed 3, total 18.

then i review the latest import package 'SAPAPPL2.log' file to get more information. i found the following info:

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

(DB) ERROR: DDL statement failed

(CREATE UNIQUE INDEX "SRMSTATUSPROF~0" ON "SRMSTATUSPROF" ( "CLIENT", "ID" ) TABLESPACE PSAPSR3 STORAGE (INITIAL 16384 NEXT 0000000040K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS )

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 obj#,type#,ctime,mtim...","Typecheck","seg:kggfaAllocSeg")

(DB) INFO: disconnected from DB

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

C:\usr\sap\A11\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20080818213504

C:\usr\sap\A11\SYS\exe\uc\NTI386\R3load.exe: START OF LOG: 20080819091416

C:\usr\sap\A11\SYS\exe\uc\NTI386\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#8 $ SAP

C:\usr\sap\A11\SYS\exe\uc\NTI386\R3load.exe: version R7.00/V1.4 [UNICODE]

Compiled Sep 1 2006 00:38:35

C:\usr\sap\A11\SYS\exe\uc\NTI386\R3load.exe -i SAPAPPL2.cmd -dbcodepage 4103 -l SAPAPPL2.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) ERROR: DDL statement failed

(DROP INDEX "SRMSTATUSPROF~0")

DbSlExecute: rc = 103

(SQL error 1418)

error message returned by DbSl:

ORA-01418: specified index does not exist

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) INFO: SRMSTATUSPROF~0 created #20080819091455

After this error, it went successfull to create some of the tables and finally i get the the below error:

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

(DB) ERROR: DDL statement failed

( ALTER INDEX "TBANK_PP_APPLREL~0" LOGGING )

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","kgghtInit")

(DB) INFO: disconnected from DB

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

C:\usr\sap\A11\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20080819092120

C:\usr\sap\A11\SYS\exe\uc\NTI386\R3load.exe: START OF LOG: 20080819092722

C:\usr\sap\A11\SYS\exe\uc\NTI386\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#8 $ SAP

C:\usr\sap\A11\SYS\exe\uc\NTI386\R3load.exe: version R7.00/V1.4 [UNICODE]

Compiled Sep 1 2006 00:38:35

C:\usr\sap\A11\SYS\exe\uc\NTI386\R3load.exe -i SAPAPPL2.cmd -dbcodepage 4103 -l SAPAPPL2.log -stop_on_error

DbSl Trace: Failed to register client info: orc=4031

DbSl Trace: ORA-604 when accessing table SAPUSER

DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 604

DbSl Trace: CONNECT failed with sql error '604'

(DB) ERROR: db_connect rc = 256

DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 604

DbSl Trace: CONNECT failed with sql error '604'

DbSl Trace: Failed to register client info: orc=4031

ORA-04031: unable to allocate 528 bytes of shared memory ("shared pool","STANDARDSYS","PL/SQL DIANA","PAR.C:parapt:Page")

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

C:\usr\sap\A11\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20080819092723

Then I go to the SAPAPPL0.TSK file and observed the following information.

T TBANK_PP_APPLREL C ok

D TBANK_PP_APPLREL I ok

P TBANK_PP_APPLREL~0 C err

T TBANK_PP_APPM C xeq

D TBANK_PP_APPM I xeq

P TBANK_PP_APPM~0 C xeq

T TBANK_PP_APPMC C xeq

D TBANK_PP_APPMC I xeq

P TBANK_PP_APPMC~0 C xeq

T TBANK_PP_APPSAP C xeq

D TBANK_PP_APPSAP I xeq

P TBANK_PP_APPSAP~0 C xeq

Please assist if any one has jumped this error.

Regards,

Niranjan.

[former_member185954]

hello Niranjan,

Looks like your SGA size is too less, check the below link:

http://www.cryer.co.uk/brian/oracle/ORA04031.htm

Regards,

Siddhesh

[Former Member]

Hi Siddhesh,

thanks for your link.

Regards,

Niranjan.