cancel
Showing results for 
Search instead for 
Did you mean: 

DbSl Trace: ORA-1403 when accessing table SAPUSER

Former Member
0 Kudos

Hi,

We have an error about ECC 6.0 SR3 installation on Solaris 10 and Oracle 10.2.0.4. We have an error like below in impor ABAP pahase:

/usr/sap/TJT/SYS/exe/run/R3load: START OF LOG: 20091102234123

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

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

Compiled Jan 23 2008 20:34:30

/usr/sap/TJT/SYS/exe/run/R3load -ctf I /u01/sapcd/EXPORT/EXP_51033500_2/EXP7/DATA/SAPAPPL0.STR /tmp/sapinst_instdir/ERP/SYSTEM/ORA/C

ENTRAL/AS/DDLORA.TPL SAPAPPL0.TSK ORA -l SAPAPPL0.log

/usr/sap/TJT/SYS/exe/run/R3load: job completed

/usr/sap/TJT/SYS/exe/run/R3load: END OF LOG: 20091102234130

/usr/sap/TJT/SYS/exe/run/R3load: START OF LOG: 20091102234130

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

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

Compiled Jan 23 2008 20:34:30

/usr/sap/TJT/SYS/exe/run/R3load -i SAPAPPL0.cmd -dbcodepage 4102 -l SAPAPPL0.log -stop_on_error

DbSl Trace: ORA-1403 when accessing table SAPUSER

Our OS is Solaris SPARC 10. I am installing ECC 6.0 SR3. I installed Oracle 10.2.0.4. But I didn't install any oracle interim patch for Oracle 10.2.0.4 . Can it be about for this reason?

How can I solve the proble and continue to installation? Could you please help us about this issue?

Best regards,

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Also additional log file:

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 STORAG

E (INITIAL 263586099 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARAL

LEL )

DbSlExecute: rc = 99

(SQL error 12801)

error message returned by DbSl:

ORA-12801: error signaled in parallel query server P009

ORA-00604: error occurred at recursive SQL level 2

ORA-00018: maximum number of sessions exceeded

(DB) INFO: disconnected from DB

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

/usr/sap/TJD/SYS/exe/run/R3load: END OF LOG: 20091103184757

How can I solve this problem?

markus_doehr2
Active Contributor
0 Kudos

> (DB) ERROR: DDL statement failed

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

> E (INITIAL 263586099 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARAL

> LEL )

> DbSlExecute: rc = 99

> (SQL error 12801)

> error message returned by DbSl:

> ORA-12801: error signaled in parallel query server P009

> ORA-00604: error occurred at recursive SQL level 2

> ORA-00018: maximum number of sessions exceeded

> (DB) INFO: disconnected from DB

>

You ran too many parallel R3load processes and your database sessions are exceeded. Just repeat after the other R3loads are finished.

Markus

former_member204746
Active Contributor
0 Kudos

increase values for "sessions" and "processes" in file init[SID].ora, restart Oracle database and try again.

Former Member
0 Kudos

Hi Eric,

Will I increase sessions and processes value from init<SID>.ora using VI editor? How can I increase this value. If I change them with vi editor do I have any problem about database?

Best regards,

former_member204746
Active Contributor
0 Kudos

yes, you edit that file such as initPRD.ora with a text editor. VI will do the work.

after tihs, you need to restart Oracle and continue installing SAP.

Former Member
0 Kudos

Hi,

Please let us know how many parallel R3load jobs yo have scheduled? If you have [Note 1094599 - Inst.NW 7.0 SR3/Business Suite 2005 SR3-UNIX/Oracle|https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=1094599]

Maximum of 2-3 parallel R3load processes per CPU

We recommend that you configure only a maximum of 2-3 parallel R3load processes per CPU. The default for the installation is 3 parallel R3load processes. Do not enter a value greater than '3' in the field "Number of Parallel Jobs" on the screen "SAP System Database Import".

Otherwise SAPinst may abort and you may find an error message like the following in SAPAPPL1.log:

(DB) ERROR: DDL statement failed

(CREATE UNIQUE INDEX "BBP_PDHCF~0" ON "BBP_PDHCF" ( "CLIENT", "GUID" )

DbSlExecute: rc = 99

(SQL error 12801) error message returned by DbSl:

ORA-12801: error signaled in parallel query server P038

ORA-00018: maximum number of sessions exceeded

Refer OSS Note to increase the parameters.

[Note 398927 - ORA errors because dimensions of parameters are too small|https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=398927]

Hope this helps.

Thanks,

Shambo

Answers (12)

Answers (12)

Former Member
0 Kudos

Hello all, </br>

</br>

Just to provide the next reader with a template value, let me suggent that you set the value for processes to 1200 and sessions to 2400. This works for us when we are performing migrations for other customers.</br>

</br>

These values simply tell Oracle what the "maximum allowed" values for processes/sessions are. It will only use what it actually required from the calling application(s).</br>

</br>

I hope this helps.</br>

</br>

Best Regards,</br>

Warren Chirhart</br>

</br>

Former Member
0 Kudos

Dear All,

Thank you very much for everything. The problem was solved. I solved problem with 2 different way for test and development systems. For development system, when I had Abap import error I repeated R3load again til finis ABAP import successfully. For test system I edited init<SID>.ora file with text editor and I increased sessions and processes value to 600. After that I restarted database and repeated ABAP import phase. Then I didn't have any problem and I finished installation successfully.

Best regards

Former Member
0 Kudos

Hi Markus,

I didn't change any default installation options. I am using 3 R3load paralel job. It is default value of SAP installation.

Also will I change processes and sessions parameters with vi editor from init<SID>.ora file?

Is value 300 normal for processes and sessions?

Best regards,

Former Member
0 Kudos

Also I increased sessions and processes with fallowing command. After that I checked init<SID>.ora file. But there is no

differences. Do I have to change these parameters from init<SID>.ora with vi editor? How can I change these parameters in

file init<SID>.ora ?

Command:

alter system set processes=300 scope=spfile;

After that I restarted databse.

Best regards,

markus_doehr2
Active Contributor
0 Kudos

> Also I increased sessions and processes with fallowing command. After that I checked init<SID>.ora file. But there is no

> differences. Do I have to change these parameters from init<SID>.ora with vi editor? How can I change these parameters in

> file init<SID>.ora ?

Did you restart the database after the change?

> alter system set processes=300 scope=spfile;

>

> After that I restarted databse.

at this time of installation there is not yet and spfile... you have to edit init<SID>.ora and restart the database. Check then the alert log to see if the changes have taken place.

It's also possible that there are still not enough processes and sessions. Since you did not yet tell us how many parallel R3load you use it's hard to give a suggestion.

Markus

Former Member
0 Kudos

Hi Markus,

Also I created an /etc/project file and add users to /etc/user_attr. I made them before installation. I made everything about preinstallation. But I have this error.

Now completed jobs are increasing when I repead R3Load. Now 25 jobs completed and 3 jobs failed.

Why I have this problem? I think it is not normal. Do you have any idea about it?

Best regards

markus_doehr2
Active Contributor
0 Kudos

> Also I created an /etc/project file and add users to /etc/user_attr. I made them before installation. I made everything about preinstallation.

good!

> But I have this error.

> Now completed jobs are increasing when I repead R3Load. Now 25 jobs completed and 3 jobs failed.

> Why I have this problem? I think it is not normal. Do you have any idea about it?

Please read my previous post and the post before, I explained already. You have a limited number of sessions by default after a default installation. Depending on the number of parallel index creations those sessions are exceeded and you get that specific error. So either

- decrease the number of parallel R3loads

- increase the session parameter in init<SID>.ora, restart the database and repeat

SAPINST can't guess how many parallel R3load you will run and how many parallel index creations will run so yes, that problem is normal if the number of parallel loads is too high.

Markus

Former Member
0 Kudos

Hi

We have the same problem and resolved by increasing the sessions to 300 in initSID.ora.

Regards,

SriniM

Former Member
0 Kudos

Also import_monitor.log file is:

TRACE: 2009-11-03 20:40:35 com.sap.inst.migmon.LoadTask processPackage

Loading of 'TODIR' import package into database:

/usr/sap/TJP/SYS/exe/run/R3load -i TODIR.cmd -dbcodepage 4102 -l TODIR.log -stop_on_error

INFO: 2009-11-03 20:41:43 com.sap.inst.migmon.LoadTask run

Loading of 'FUPARAREF' import package is successfully completed.

TRACE: 2009-11-03 20:42:05 com.sap.inst.migmon.LoadTask run

Loading of 'SCPRVALS' import package is started.

TRACE: 2009-11-03 20:42:05 com.sap.inst.migmon.LoadTask processPackage

Loading of 'SCPRVALS' import package into database:

/usr/sap/TJP/SYS/exe/run/R3load -i SCPRVALS.cmd -dbcodepage 4102 -l SCPRVALS.log -stop_on_error

ERROR: 2009-11-03 20:42:07 com.sap.inst.migmon.LoadTask run

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

Process '/usr/sap/TJP/SYS/exe/run/R3load -i SCPRVALS.cmd -dbcodepage 4102 -l SCPRVALS.log -stop_on_error' exited with return code 2.

For mode details see 'SCPRVALS.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

TRACE: 2009-11-03 20:42:35 com.sap.inst.migmon.LoadTask run

Loading of 'E071K' import package is started.

TRACE: 2009-11-03 20:42:35 com.sap.inst.migmon.LoadTask processPackage

Loading of 'E071K' import package into database:

/usr/sap/TJP/SYS/exe/run/R3load -i E071K.cmd -dbcodepage 4102 -l E071K.log -stop_on_error

INFO: 2009-11-03 20:43:07 com.sap.inst.migmon.LoadTask run

Loading of 'SAPAPPL1' import package is successfully completed.

TRACE: 2009-11-03 20:43:35 com.sap.inst.migmon.LoadTask run

Loading of 'SAPPOOL' import package is started.

TRACE: 2009-11-03 20:43:35 com.sap.inst.migmon.LoadTask processPackage

Loading of 'SAPPOOL' import package into database:

/usr/sap/TJP/SYS/exe/run/R3load -i SAPPOOL.cmd -dbcodepage 4102 -l SAPPOOL.log -stop_on_error

Why I have these errors? How can I finish this installation? Now I am installaing 3 system on Solaris SPARC and I have same error for all 3 servers. I added Solaris kernel parameters olso into the /etc/system. I installed Oracle 10.2.0.4 successfuly. But I didn't install any oracle interim patches.

Could you please help me about this issue?

Best regards,

markus_doehr2
Active Contributor
0 Kudos

> Why I have these errors?

which errors? I don't see any...

> How can I finish this installation? Now I am installaing 3 system on Solaris SPARC and I have same error for all 3 servers. I added Solaris kernel parameters olso into the /etc/system.

On Solaris 10 /etc/system is deprecated, you need to create an /etc/project file and add users to /etc/user_attr:

Note 724713 - parameter settings for Solaris 10

> installed Oracle 10.2.0.4 successfuly. But I didn't install any oracle interim patches.

That should be done always before loading the databases.

Markus

Former Member
0 Kudos

Hi,

Before, 10 jobs copleted successfully.I increased processes and sessions. And then I ran again and now 14 jobs of 28 copleted successfully. There are 14 jobs failed. Will I restart always like this to finish all jobs successfuly?

Also I have fallowing error now:

/usr/sap/TJP/SYS/exe/run/R3load: START OF LOG: 20091103191031

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

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

Compiled Jan 23 2008 20:34:30

/usr/sap/TJP/SYS/exe/run/R3load -ctf I /u01/sapcd/EXPORT/EXP_51033500_2/EXP7/DATA/SAPAPPL1.STR /tmp/sapinst_instdir/ERP/SYSTEM/ORA/C

ENTRAL/AS/DDLORA.TPL SAPAPPL1.TSK ORA -l SAPAPPL1.log

/usr/sap/TJP/SYS/exe/run/R3load: job completed

/usr/sap/TJP/SYS/exe/run/R3load: END OF LOG: 20091103191032

Best regards,

/usr/sap/TJP/SYS/exe/run/R3load: START OF LOG: 20091103191033

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

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

Compiled Jan 23 2008 20:34:30

/usr/sap/TJP/SYS/exe/run/R3load -i SAPAPPL1.cmd -dbcodepage 4102 -l SAPAPPL1.log -stop_on_error

DbSl Trace: ORA-1403 when accessing table SAPUSER

markus_doehr2
Active Contributor
0 Kudos

> Before, 10 jobs copleted successfully.I increased processes and sessions. And then I ran again and now 14 jobs of 28 copleted successfully. There are 14 jobs failed. Will I restart always like this to finish all jobs successfuly?

Yes - or either increase the session limit as described.

Markus

Former Member
0 Kudos

Hi,

SAPAPPL0.log file like below:

"SAPPOOL.log" 40 lines, 1537 characters

/usr/sap/TJP/SYS/exe/run/R3load: START OF LOG: 20091103193201

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

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

Compiled Jan 23 2008 20:34:30

/usr/sap/TJP/SYS/exe/run/R3load -ctf I /u01/sapcd/EXPORT/EXP_51033500_1/EXP6/DATA/SAPPOOL.STR /tmp/sapinst_instdir/ERP/SYSTEM/ORA/CE

NTRAL/AS/DDLORA.TPL SAPPOOL.TSK ORA -l SAPPOOL.log

/usr/sap/TJP/SYS/exe/run/R3load: job completed

/usr/sap/TJP/SYS/exe/run/R3load: END OF LOG: 20091103193201

/usr/sap/TJP/SYS/exe/run/R3load: START OF LOG: 20091103193201

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

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

Compiled Jan 23 2008 20:34:30

/usr/sap/TJP/SYS/exe/run/R3load -i SAPPOOL.cmd -dbcodepage 4102 -l SAPPOOL.log -stop_on_error

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

DbSl Trace: CONNECT failed with sql error '12537'

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

DbSl Trace: CONNECT failed with sql error '12537'

(DB) ERROR: db_connect rc = 256

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

DbSl Trace: CONNECT failed with sql error '12537'

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

DbSl Trace: CONNECT failed with sql error '12537'

(DB) ERROR: DbSlErrorMsg rc = 99

Also DOKCLU.log file is:

/usr/sap/TJD/SYS/exe/run/R3load: START OF LOG: 20091103175446

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

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

Compiled Jan 23 2008 20:34:30

/usr/sap/TJD/SYS/exe/run/R3load -ctf I /u01/sapcd/EXPORT/EXP_51033500_2/EXP11/DATA/DOKCLU.STR /tmp/sapinst_instdir/ERP/SYSTEM/ORA/CE

NTRAL/AS/DDLORA_LRG.TPL DOKCLU.TSK ORA -l DOKCLU.log

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

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

/usr/sap/TJD/SYS/exe/run/R3load: job completed

/usr/sap/TJD/SYS/exe/run/R3load: END OF LOG: 20091103175446

/usr/sap/TJD/SYS/exe/run/R3load: START OF LOG: 20091103175446

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

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

Compiled Jan 23 2008 20:34:30

/usr/sap/TJD/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 #20091103175447

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

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 STORAG

E (INITIAL 263586099 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARAL

LEL )

DbSlExecute: rc = 99

Now I am installain 3 system on 3 different Solaris SPARC servers and I have same error in ABAP import phase.

Can EXPORT DVD be corrupted? How can I solve the problem?

Best regards,

Former Member
0 Kudos

Hi Arif,

Can you send me SAPAPPL0.log file. If it contains the access error with SAPUSER table.

Then manually enter the SAPSR3 user details and master password.

Thanks and Regards

Sridhar

Former Member
0 Kudos

Hi Arif,

You can ignore these errors. These are commonly seen it will not have any harm. Only check wheather your ABAP LOAD Phase is running.

Our OS is Solaris SPARC 10. I am installing ECC 6.0 SR3. I installed Oracle 10.2.0.4. But I didn't install any oracle interim patch for Oracle 10.2.0.4 . Can it be about for this reason

?

After completing the installation you must have to apply the interim patches.

Thanks,

Shambo

Former Member
0 Kudos

You can ignore this mesg. Its not an error.

sunny_pahuja2
Active Contributor
0 Kudos

Hi Arif,

Check SAP Note 400241 - Problems with ops$ or sapr3 connect to Oracle

Thanks

Sunny