Installation Error - SAP ERP 6.0 SR3 - Error importa ABAP

[Former Member]

hello,

we are installing SAP ERP 6.0 SR3 Oracle 10.2 on solaris 10 container (zone), in step import abap the installation failed with the followin error:

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

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

Compiled Jan 23 2008 20:34:30

/usr/sap/CMD/SYS/exe/run/R3load -i DOKCLU.cmd -dbcodepage 4102 -l DOKCLU.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

(RTF) ########## WARNING ###########

Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases

(DB) INFO: DOKCLU created #20090831181827

(IMP) INFO: import of DOKCLU completed (1816708 rows) #20090831191240

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

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

(DB) ERROR: DDL statement failed

(CREATE UNIQUE INDEX "DOKCLU~0" ON "DOKCLU" ( "ID", "OBJECT", "LANGU", "TYP", "DOKVERSION", "PAGENO" ) TABLESPACE PSAPSR3700

STORAGE (INITIAL 263586099 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE ST

ATISTICS PARALLEL )

DbSlExecute: rc = 99

(SQL error 12801)

error message returned by DbSl:

ORA-12801: error signaled in parallel query server P050

ORA-00018: maximum number of sessions exceeded

(DB) INFO: disconnected from DB

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

/usr/sap/CMD/SYS/exe/run/R3load: END OF LOG: 20090831191343

Accordin to SAP Note 1094599, we set one or two R3load process but the error persist, how we can fix this error and finish the installation? We set too the Oracle parameters Sessions and Processes to a greater value but it still didn't work.

Thanks

Hernando

[nils_buerckel]

Hi,

please check whether the proposal in SAP note 1120872 (search for ORA-00018) solves your problem.

Best regards,

Nils Buerckel

SAP AG

[Former Member]

Hello Nils

we applied the recommendation in note 1120872 (PROCESSES=1000 and SESSIONS=1105) but the error persists:

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

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

(DB) ERROR: DDL statement failed

(CREATE UNIQUE INDEX "DD03L~0" ON "DD03L" ( "TABNAME", "FIELDNAME", "AS4LOCAL",

"AS4VERS", "POSITION" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 712194033 NEXT 0

000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING

COMPUTE STATISTICS PARALLEL )

DbSlExecute: rc = 99

(SQL error 12801)

error message returned by DbSl:

ORA-12801: error signaled in parallel query server P030

ORA-12853: insufficient memory for PX buffers: current 418256K, max needed 11666

304K

ORA-04031: unable to allocate 32816 bytes of shared memory ("shared pool","unkno

wn object","sga heap(2,0)","PX msg pool")

(DB) INFO: disconnected from DB

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

/usr/sap/CMD/SYS/exe/run/R3load: END OF LOG: 20090901154717

we increase the parameter shared_pool_size = 2952790016, and restart the import but 1 import process fail, waiting 20, completed 5, running 2.

Can we restart the import abap without reinstall the system? we can restat the import in the same phase?

thanks

Hernando

Edited by: Hernando Polania Cadena on Sep 1, 2009 11:34 PM

[Former Member]

hello All,

we applied the recommendation in note 1120872 (PROCESSES=1000 and SESSIONS=1105) and increased the shared_pool_size to 2,5 GB, but before the import Abap phase the installation stoped by error:

ORA-12801: error signaled in parallel query server P030

ORA-12853: insufficient memory for PX buffers: current 418256K, max needed 11666

we set the original shared_pool_size and continue the installation, it finished OK.

thanks

Hernando