ECC-6.0 Installation Problem - Import ABAP Phase

[Former Member]

Hello Gurus

I am installing ECC6.0 om Windows-2003 Server ( 32 Bit ), With Oracle 10g ( 10.2.0.2.0 ), Java version - 1.4.2_12

I am facing problem in Import ABAP Phase

Please guide me the rectification so that I completed my installation successfully.

Thanks & Regards

Shishir

I am attaching import_monitor.java.log for your reference

java version "1.4.2_12"

Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_12-b03)

Java HotSpot(TM) Client VM (build 1.4.2_12-b03, mixed mode)

Import Monitor jobs: running 1, waiting 22, completed 15, failed 0, total 38.

Import Monitor jobs: running 2, waiting 21, completed 15, failed 0, total 38.

Import Monitor jobs: running 3, waiting 20, completed 15, failed 0, total 38.

Loading of 'SAPAPPL0_1' import package: ERROR

Loading of 'SAPAPPL2_3' import package: ERROR

Import Monitor jobs: running 0, waiting 20, completed 15, failed 3, total 38.

Loading of 'SAPSSEXC_3' import package: ERROR

Import Monitor jobs: running 0, waiting 20, completed 15, failed 3, total 38.

Import Monitor jobs: running 0, waiting 20, completed 15, failed 3, total 38.

Import Monitor jobs: running 1, waiting 19, completed 15, failed 3, total 38.

Import Monitor jobs: running 2, waiting 18, completed 15, failed 3, total 38.

Import Monitor jobs: running 3, waiting 17, completed 15, failed 3, total 38.

Loading of 'SAPSSEXC_5' import package: ERROR

Import Monitor jobs: running 2, waiting 17, completed 15, failed 4, total 38.

Loading of 'SCPRSVALS' import package: ERROR

Import Monitor jobs: running 1, waiting 17, completed 15, failed 5, total 38.

Loading of 'SAPAPPL0_2' import package: ERROR

Import Monitor jobs: running 0, waiting 17, completed 15, failed 6, total 38.

Import Monitor jobs: running 1, waiting 16, completed 15, failed 6, total 38.

Import Monitor jobs: running 2, waiting 15, completed 15, failed 6, total 38.

Import Monitor jobs: running 3, waiting 14, completed 15, failed 6, total 38.

Loading of 'FUPARAREF' import package: ERROR

Loading of 'TODIR' import package: ERROR

Loading of 'SAPSDIC' import package: ERROR

Import Monitor jobs: running 0, waiting 14, completed 15, failed 9, total 38.

Import Monitor jobs: running 0, waiting 14, completed 15, failed 9, total 38.

Import Monitor jobs: running 0, waiting 14, completed 15, failed 9, total 38.

Import Monitor jobs: running 1, waiting 13, completed 15, failed 9, total 38.

Import Monitor jobs: running 2, waiting 12, completed 15, failed 9, total 38.

Import Monitor jobs: running 3, waiting 11, completed 15, failed 9, total 38.

Loading of 'SEOSUBCODF' import package: ERROR

Import Monitor jobs: running 2, waiting 11, completed 15, failed 10, total 38.

Loading of 'SAPSSRC' import package: ERROR

Import Monitor jobs: running 1, waiting 11, completed 15, failed 11, total 38.

Loading of 'SAPAPPL0_4' import package: ERROR

Import Monitor jobs: running 0, waiting 11, completed 15, failed 12, total 38.

Import Monitor jobs: running 1, waiting 10, completed 15, failed 12, total 38.

Import Monitor jobs: running 2, waiting 9, completed 15, failed 12, total 38.

Import Monitor jobs: running 3, waiting 8, completed 15, failed 12, total 38.

Loading of 'SCPRVALS' import package: ERROR

Loading of 'E071K' import package: ERROR

Import Monitor jobs: running 1, waiting 8, completed 15, failed 14, total 38.

Import Monitor jobs: running 1, waiting 8, completed 15, failed 14, total 38.

Loading of 'SAPPOOL' import package: ERROR

Import Monitor jobs: running 0, waiting 8, completed 15, failed 15, total 38.

Import Monitor jobs: running 1, waiting 7, completed 15, failed 15, total 38.

Import Monitor jobs: running 2, waiting 6, completed 15, failed 15, total 38.

Import Monitor jobs: running 3, waiting 5, completed 15, failed 15, total 38.

Loading of 'SAPSLEXC' import package: ERROR

Loading of 'SAPSPROT' import package: ERROR

Loading of 'SAPSDOCU' import package: ERROR

Import Monitor jobs: running 0, waiting 5, completed 15, failed 18, total 38.

Import Monitor jobs: running 0, waiting 5, completed 15, failed 18, total 38.

Import Monitor jobs: running 0, waiting 5, completed 15, failed 18, total 38.

Import Monitor jobs: running 1, waiting 4, completed 15, failed 18, total 38.

Import Monitor jobs: running 2, waiting 3, completed 15, failed 18, total 38.

Import Monitor jobs: running 3, waiting 2, completed 15, failed 18, total 38.

Loading of 'SAPUSER' import package: ERROR

Import Monitor jobs: running 1, waiting 2, completed 15, failed 21, total 38.

Loading of 'SAPDDIM' import package: ERROR

Import Monitor jobs: running 0, waiting 2, completed 15, failed 21, total 38.

Loading of 'SAPCLUST' import package: ERROR

Import Monitor jobs: running 0, waiting 2, completed 15, failed 21, total 38.

Import Monitor jobs: running 1, waiting 1, completed 15, failed 21, total 38.

Loading of 'SAPDODS' import package: ERROR

Import Monitor jobs: running 0, waiting 1, completed 15, failed 22, total 38.

[Former Member]

Thanks

[Former Member]

HI

sqlplus "/as sysdba"

sql>show parameter shared_pool_size;

If the value is less than 250M increase the value to 400M with below command

sql>alter system set shared_pool_size=400M;

Restart the database and continue the installation

Regards

Uday

[Former Member]

Hello Uday

Logs is for your reference

(DB) INFO: CKMLKALNR~0 created #20100719002111

DbSl Trace: Error 604 in exec_immediate() from oci_execute_stmt(), orpc=0

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

(DB) ERROR: DDL statement failed

(CREATE TABLE "CKMLKEPH" ( "MANDT" VARCHAR2(9) DEFAULT '000' NOT NULL , "KALNR" VARCHAR2(36) DEFAULT '000000000000' NOT NULL , "BDATJ" VARCHAR2(12) DEFAULT '0000' NOT NULL , "POPER" VARCHAR2(9) DEFAULT '000' NOT NULL , "UNTPER" VARCHAR2(9) DEFAULT '000' NOT NULL , "CATEG" VARCHAR2(6) DEFAULT ' ' NOT NULL , "PTYP" VARCHAR2(12) DEFAULT ' ' NOT NULL , "BVALT" VARCHAR2(36) DEFAULT '000000000000' NOT NULL , "KEART" VARCHAR2(3) DEFAULT ' ' NOT NULL , "MLCCT" VARCHAR2(3) DEFAULT ' ' NOT NULL , "KKZST" VARCHAR2(3) DEFAULT ' ' NOT NULL , "PATNR" VARCHAR2(18) DEFAULT '000000' NOT NULL , "DIPA" VARCHAR2(3) DEFAULT ' ' NOT NULL , "CURTP" VARCHAR2(6) DEFAULT ' ' NOT NULL , "WAERS" VARCHAR2(15) DEFAULT ' ' NOT NULL , "KST001" NUMBER(15,2) DEFAULT 0 NOT NULL , "KST002" NUMBER(15,2) DEFAULT 0 NOT NULL , "KST003" NUMBER(15,2) DEFAULT 0 NOT NULL , "KST004" NUMBER(15,2) DEFAULT 0 NOT NULL , "KST005" NUMBER(15,2) DEFAULT 0 NOT NULL , "KST006" NUMBER(15,2) DEFAULT 0 NOT NULL , "KST007" NUMBER(15,2) DEFAULT 0 NOT NULL , "KST008" NUMBER(15,2) DEFAULT 0 NOT NULL , "KST009" NUMBER(15,2) DEFAULT 0 NOT NULL , "KST010" NUMBER(15,2) DEFAULT 0 NOT NULL , "KST011" NUMBER(15,2) DEFAULT 0 NOT NULL , "KST012" NUMBER(15,2) DEFAULT 0 NOT NULL , "KST013" NUMBER(15,2) DEFAULT 0 NOT NULL , "KST014" NUMBER(15,2) DEFAULT 0 NOT NULL , "KST015" NUMBER(15,2) DEFAULT 0 NOT NULL , "KST016" NUMBER(15,2) DEFAULT 0 NOT NULL , "KST017" NUMBER(15,2) DEFAULT 0 NOT NULL , "KST018" NUMBER(15,2) DEFAULT 0 NOT NULL , "KST019" NUMBER(15,2) DEFAULT 0 NOT NULL , "KST020" NUMBER(15,2) DEFAULT 0 NOT NULL , "KST021" NUMBER(15,2) DEFAULT 0 NOT NULL , "KST022" NUMBER(15,2) DEFAULT 0 NOT NULL , "KST023" NUMBER(15,2) DEFAULT 0 NOT NULL , "KST024" NUMBER(15,2) DEFAULT 0 NOT NULL , "KST025" NUMBER(15,2) DEFAULT 0 NOT NULL , "KST026" NUMBER(15,2) DEFAULT 0 NOT NULL , "KST027" NUMBER(15,2) DEFAULT 0 NOT NULL , "KST028" NUMBER(15,2) DEFAULT 0 NOT NULL , "KST029" NUMBER(15,2) DEFAULT 0 NOT NULL , "KST030" NUMBER(15,2) DEFAULT 0 NOT NULL , "KST031" NUMBER(15,2) DEFAULT 0 NOT NULL , "KST032" NUMBER(15,2) DEFAULT 0 NOT NULL , "KST033" NUMBER(15,2) DEFAULT 0 NOT NULL , "KST034" NUMBER(15,2) DEFAULT 0 NOT NULL , "KST035" NUMBER(15,2) DEFAULT 0 NOT NULL , "KST036" NUMBER(15,2) DEFAULT 0 NOT NULL , "KST037" NUMBER(15,2) DEFAULT 0 NOT NULL , "KST038" NUMBER(15,2) DEFAULT 0 NOT NULL , "KST039" NUMBER(15,2) DEFAULT 0 NOT NULL , "KST040" NUMBER(15,2) DEFAULT 0 NOT NULL ) TABLESPACE PSAPSR3 STORAGE (INITIAL 16384 NEXT 0000010240K 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 i.obj#,i.ts#,i.file#,...","Typecheck","seg:kggfaAllocSeg")

(DB) INFO: disconnected from DB

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

E:\usr\sap\DEV\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20100719002116

E:\usr\sap\DEV\SYS\exe\uc\NTI386\R3load.exe: START OF LOG: 20100719093744

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

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

Compiled Jul 17 2007 01:28:45

E:\usr\sap\DEV\SYS\exe\uc\NTI386\R3load.exe -i SAPAPPL0_1.cmd -dbcodepage 4103 -l SAPAPPL0_1.log -stop_on_error

DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541

DbSl Trace: CONNECT failed with sql error '12541'

DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541

DbSl Trace: CONNECT failed with sql error '12541'

(DB) ERROR: db_connect rc = 256

DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541

DbSl Trace: CONNECT failed with sql error '12541'

DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541

DbSl Trace: CONNECT failed with sql error '12541'

(DB) ERROR: DbSlErrorMsg rc = 99

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

E:\usr\sap\DEV\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20100719093749

E:\usr\sap\DEV\SYS\exe\uc\NTI386\R3load.exe: START OF LOG: 20100720181045

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

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

Compiled Jul 17 2007 01:28:45

E:\usr\sap\DEV\SYS\exe\uc\NTI386\R3load.exe -i SAPAPPL0_1.cmd -dbcodepage 4103 -l SAPAPPL0_1.log -stop_on_error

DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541

DbSl Trace: CONNECT failed with sql error '12541'

DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541

DbSl Trace: CONNECT failed with sql error '12541'

(DB) ERROR: db_connect rc = 256

DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541

DbSl Trace: CONNECT failed with sql error '12541'

DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541

DbSl Trace: CONNECT failed with sql error '12541'

(DB) ERROR: DbSlErrorMsg rc = 99

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

E:\usr\sap\DEV\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20100720181050

[andreas_herzog]

any network issues?

CONNECT failed with sql error '12541'

^^ is the error, meaning that the oracle listener is down or unreachable...what's the status of your listener?

GreetZ, AH

[markus_doehr2]

> ORA-04031: unable to allocate 4108 bytes of shared memory ("shared pool","select i.obj#,i.ts#,i.file#,...","Typecheck","seg:kggfaAllocSeg")

this is a know and common error.

the easiest way to workaround is to shut down the database and start it again.

Markus

[Former Member]

DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541

Please check your oracle listener is running.

Login as <SID>adm user go to command prompt & execute command lsnrctl start to start the listener.

Also see notes

609332 Composite note: ORA-12541/ORA-12224

Tnx

Shambo

[Former Member]

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 E:\usr\sap\DEV\SYS\exe\uc\NTI386\R3load.exe: job finished with 1 error(s) E:\usr\sap\DEV\SYS\exe\uc\NTI386\R3load.exe: END OF LOG

It looks like you have insufficient memory allocated to shared pool.

Refer to following link on how to increase size and related commands. Based on amount of memory you have you can tune these parameters accordingly. After tuning give one more try.

[http://www.oracle.com/technology/pub/articles/10gdba/week17_10gdba.html]

Hope this helps.

Manoj

[former_member204746]

set shared_pool_size to 400M in file init[SID].ora

then, restart your database

finally, ontinue SAP installation.

Good luck.

[Former Member]

Hi

You need to provide the Job log of 'SAPAPPL0_1'

Regards

Uday