Installation Error

[Former Member]

Dears,

I am installing ECC6 on my AIX sever and database is Oracle 10.4

I am getting below error in installation in Import ABAP step:

D:\usr\sap\DMS\SYS\exe\uc\NTAMD64\R3load.exe -i DD03L.cmd -dbcodepage 4103 -l DD03L.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) ERROR: DDL statement failed

(DROP INDEX "DD03L~3")

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

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 INDEX "DD03L~3" ON "DD03L" ( "CHECKTABLE" , "AS4LOCAL" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 373901867 NEXT 0000002560K 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 P060

ORA-00018: maximum number of sessions exceeded

(DB) INFO: disconnected from DB

D:\usr\sap\DMS\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)

D:\usr\sap\DMS\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20091201122420

Please suggest to resolve the issue,I also increaed processes in pfile but issue did not get resolved.

Shivam

[Former Member · Accepted solution]

ORA-12801: error signaled in parallel query server P060
ORA-00018: maximum number of sessions exceeded
(DB) INFO: disconnected from DB

The error says that you have reached the maximum sessions.

Please see OSS Note 1120872

aslo see the below links

[http://oracle.ittoolbox.com/groups/technical-functional/oracle-db-l/maximum-session-exceeded-1952330]

[;

You can set the parameter SESSIONS in init<SID>.ora file.

Hope this will solve your problem.

Thanks,

Sachin

Edited by: Sachin M. Sable on Dec 1, 2009 1:06 PM

[Former Member]

Hi,

This can also be due to too many parallel R3load processes activated as per Note 972263.

Best regards,

Warren