Import Abap Stage Problem

[Former Member]

Iam installing ECC 6 SR 2 on windows 2003 server with service pack 2 with Oracle 10.2 on Single Computer , Iam facing problem in Import Abap Stage .. Iam pasting Import_Monitor.Log file file and also iam pasting Sapuser.log , Sapuer1.log file , because Import_Monitor.log file is suggesting to check these files , Please help me . So Iam pasting 3 file 1) Import_Monitor.Log , 2) Sapuser.Log 3 ) Sapuser1.Log

Import_Monitor.Log

====================

ERROR: 2011-08-11 00:28:44 com.sap.inst.migmon.LoadTask run

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

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

For mode details see 'SAPUSER.log' file.

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: 2011-08-11 00:28:44 com.sap.inst.migmon.LoadTask run

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

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

For mode details see 'SAPUSER1.log' file.

Standard error output:

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

sapparam(1c): No Profile used.

sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

Sapuser.Log File

================

(DB) ERROR: DDL statement failed

(CREATE TABLE "ZCR550_00" ( "MANDT" VARCHAR2(9) DEFAULT '000' NOT NULL , "COUNTRY" VARCHAR2(90) DEFAULT ' ' NOT NULL , "CONTINENT" VARCHAR2(90) DEFAULT ' ' NOT NULL ) TABLESPACE PSAPSR3USR 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 2

ORA-04031: unable to allocate 208 bytes of shared memory ("shared pool","select con#,obj#,rcon#,enabl...","sql area","kafco : qkacol")

(DB) INFO: disconnected from DB

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

C:\usr\sap\DEV\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20110811002843

Sapuser1.Log file

=================

C:\usr\sap\DEV\SYS\exe\uc\NTI386\R3load.exe: START OF LOG: 20110810234316

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

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

Compiled Jul 17 2007 01:28:45

C:\usr\sap\DEV\SYS\exe\uc\NTI386\R3load.exe -ctf I C:\ECB\EXPORT\51032413_5\EXP5\DATA\SAPUSER1.STR C:\Program Files\sapinst_instdir\ERP\SYSTEM\ORA\CENTRAL\AS\DDLORA.TPL SAPUSER1.TSK ORA -l SAPUSER1.log

C:\usr\sap\DEV\SYS\exe\uc\NTI386\R3load.exe: job completed

C:\usr\sap\DEV\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20110810234316

C:\usr\sap\DEV\SYS\exe\uc\NTI386\R3load.exe: START OF LOG: 20110810234316

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

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

Compiled Jul 17 2007 01:28:45

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

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

DbSl Trace: ORA-604 when accessing table SAPUSER

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

DbSl Trace: CONNECT failed with sql error '604'

(DB) ERROR: db_connect rc = 256

DbSl Trace: ORA-1403 when accessing table SAPUSER

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=4031

DbSl Trace: CONNECT failed with sql error '4031'

(DB) ERROR: DbSlErrorMsg rc = 99

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

C:\usr\sap\DEV\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20110810234318

C:\usr\sap\DEV\SYS\exe\uc\NTI386\R3load.exe: START OF LOG: 20110811002843

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

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

Compiled Jul 17 2007 01:28:45

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

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

DbSl Trace: ORA-1403 when accessing table SAPUSER

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

DbSl Trace: Couldn't read NLS parameters from V$NLS_PARAMETERS: sqlcode=604

(DB) ERROR: db_connect rc = 256

DbSl Trace: Default conn.: already connected to DEV

(DB) ERROR: DbSlErrorMsg rc = 29

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

C:\usr\sap\DEV\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20110811002844

Edited by: zulu123 on Aug 11, 2011 7:23 AM

[Former Member]

Import is terminated with very low shared pool value, either increase SHARED_POOL_SIZE or

Set SGA_TARGET = DB MEMORY DESIRED VALUE

Restart the DB

restart the SAPINST.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/memory.htm

Thanks

SM

[former_member204746]

refer to SAP note 830576 to get the value for shared_pool_size, adapt this value then restart ORacle.