Skip to Content
avatar image
Former Member

Installation Error

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Dec 01, 2009 at 07:33 AM
    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]

    [dbsl-trace-ora1403-when-accessing-table-sapuser;

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 01, 2009 at 07:58 AM

    Hi,

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

    Best regards,

    Warren

    Add comment
    10|10000 characters needed characters exceeded