ORA-604 and ORA-4031 during installation of SAP

[Former Member]

Hi,

I tried to install Oracle 10.2.0.2 on Windows 2003 with SAP R3E 47X2.

However, during the installation on the Database Load phases it pops up a ORA-604 and ORA-4031 error log. It was unable to completed the Database Load phase showed as R3 load jobs: running 1, waiting 0.

I tried to set the share pool in init.ora as shared_pool_size = 40000000. It still show up as shared memory issue.

The log shows as,

E:\usr\sap\IDE\SYS\exe\run/R3load.exe: START OF LOG: 20081201110818

E:\usr\sap\IDE\SYS\exe\run/R3load.exe: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#12 $ SAP

E:\usr\sap\IDE\SYS\exe\run/R3load.exe: version R6.40/V1.4 [UNICODE]

Compiled Dec 15 2005 22:22:21

E:\usr\sap\IDE\SYS\exe\run/R3load.exe -dbcodepage 4103 -i C:\Program Files\sapinst_instdir\R3E47X2\SYSTEM\ABAP\ORA\UC\DB/SAPSSEXC.cmd -l C:\Program Files\sapinst_instdir\R3E47X2\SYSTEM\ABAP\ORA\UC\DB/SAPSSEXC.log -stop_on_error

DbSl Trace: ORA-1403 when accessing table SAPUSER

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

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8

DbSl Trace: Error in exec_immediate()

DbSl Trace: ORA-604 occurred when executing SQL statement (parse error offset=15)

(DB) ERROR: DDL statement failed

(TRUNCATE TABLE "DYNPSOURCE")

DbSlExecute: rc = 99

(SQL error 604)

error message returned by DbSl:

ORA-00604: error occurred at recursive SQL level 1

ORA-04031: unable to allocate 4120 bytes of shared memory ("shared pool","select user#,type# from user...","Typecheck","kgghteInit")

(DB) INFO: disconnected from DB

E:\usr\sap\IDE\SYS\exe\run/R3load.exe: job finished with 1 error(s)

E:\usr\sap\IDE\SYS\exe\run/R3load.exe: END OF LOG: 20081201110858

Could anyone help me about it?

Thanks.

[Former Member]

Hi,

have you already tried to incresed shared pool as suggested by nikhuj.

Let us know the result.

This problem seems to be because of the shared pool size.

Regards, Atil

[Former Member]

I setted the shared_pool_size=40000000 in initsmpl.ora and restart the DB as

shutdown immediate

startup

The installation is still running. I will see ... what error message will come up.

Edited by: Shingwo Chan on Dec 1, 2008 8:26 AM

[Former Member]

From SQL prompt try alter system set shared_pool=40000000;

Regards,

Nikunj Thaker.

[Former Member]

hi Nikhuj,

I reset the installation and however endup the installation still have an error. Please help me to check with the following:

SQL> connect system

Enter password:

ERROR:

ORA-00604: error occurred at recursive SQL level 2

ORA-04031: unable to allocate 4120 bytes of shared memory ("shared

pool","select ts#,file#,block#,nvl(...","Typecheck","kgghtInit")

SQL> show parameters shared_pool;

NAME TYPE VALUE

-

---

shared_pool_reserved_size big integer 12881756

shared_pool_size big integer 124M

SQL> alter system set shared_pool_size=40000000;

alter system set shared_pool_size=40000000

*

ERROR at line 1:

ORA-02097: parameter cannot be modified because specified value is invalid

ORA-04034: unable to shrink pool to specified size

As I had changed the parameter in initsmpl.ora shared pool from 10000000 to 40000000. The log as below was showing that:

SAPAPPL1.log:

Error accessing package DBMS_APPLICATION_INFO

Connected.

(IMP) INFO: import of LXE_PPX__1 completed (1 rows) #20081201200124

(DB) INFO: LXE_PPX__1~0 created #20081201200124

DbSl Trace: Error in exec_immediate()

DbSl Trace: ORA-604 occurred when executing SQL statement (parse error offset=34)

(DB) ERROR: DDL statement failed

(CREATE INDEX "LXE_PPX__1~CNT" ON "LXE_PPX__1" ( "T_LANG" , "S_LANG" ,

"DOMATYP" , "DOMANAM" , "USAGECNT" ) TABLESPACE PSAPIDE STORAGE (INITIAL 0 NEXT

0000010240K 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 1

ORA-04031: unable to allocate 4120 bytes of shared memory ("shared pool","CREATE

UNIQUE INDEX "PA0399~...","Typecheck","kgghteInit")

(DB) INFO: disconnected from DB

E:\usr\sap\IDE\SYS\exe\run/R3load.exe: job finished with 1 error(s)

E:\usr\sap\IDE\SYS\exe\run/R3load.exe: END OF LOG: 20081201200129

SAPAPPL2.log:

(DB) INFO: TCN2T~0 created #20081201200843

DbSl Trace: Error in exec_immediate()

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

(DB) ERROR: DDL statement failed

(CREATE TABLE "TCN41" ( "MANDT" VARCHAR2(9) DEFAULT '000' NOT NULL , "PLNAW"

VARCHAR2(3) DEFAULT ' ' NOT NULL , "PROFIDNETZ" VARCHAR2(21) DEFAULT ' ' NOT NULL

, "FLG_ERF_H" VARCHAR2(3) DEFAULT ' ' NOT NULL , "ESOKZ" VARCHAR2(3) DEFAULT ' '

NOT NULL , "EKORG" VARCHAR2(12) DEFAULT ' ' NOT NULL , "KSTAR_FRMD" VARCHAR2(30)

DEFAULT ' ' NOT NULL , "STEUS_WORK" VARCHAR2(12) DEFAULT ' ' NOT NULL ,

"STEUS_FRMD" VARCHAR2(12) DEFAULT ' ' NOT NULL , "STEUS_PRIM" VARCHAR2(12)

DEFAULT ' ' NOT NULL , "KSTAR_COST" VARCHAR2(30) DEFAULT ' ' NOT NULL ,

"KSTAR_SERV" VARCHAR2(30) DEFAULT ' ' NOT NULL , "STEUS_SERV" VARCHAR2(12)

DEFAULT ' ' NOT NULL , "DAUNE" VARCHAR2(9) DEFAULT ' ' NOT NULL , "ARBEH"

VARCHAR2(9) DEFAULT ' ' NOT NULL , "WAERS" VARCHAR2(15) DEFAULT ' ' NOT NULL ,

"SLWID" VARCHAR2(21) DEFAULT ' ' NOT NULL , "LVARI" VARCHAR2(6) DEFAULT ' ' NOT

NULL , "INDET" VARCHAR2(3) DEFAULT ' ' NOT NULL , "BUKRS" VARCHAR2(12) DEFAULT '

' NOT NULL , "AOB_KEY" VARCHAR2(3) DEFAULT ' ' NOT NULL , "VORNR_DEL" VARCHAR2

(12) DEFAULT ' ' NOT NULL , "TERKZ" VARCHAR2(3) DEFAULT ' ' NOT NULL , "AUART"

VARCHAR2(12) DEFAULT ' ' NOT NULL , "WERKS" VARCHAR2(12) DEFAULT ' ' NOT NULL ,

"DISPO" VARCHAR2(9) DEFAULT ' ' NOT NULL , "RSCHL_OFER" VARCHAR2(18) DEFAULT ' '

NOT NULL , "RSCHL_OFRD" VARCHAR2(18) DEFAULT ' ' NOT NULL , "RSCHL_UFER"

VARCHAR2(18) DEFAULT ' ' NOT NULL , "RSCHL_UFRD" VARCHAR2(18) DEFAULT ' ' NOT

NULL , "RSCHL_OCST" VARCHAR2(18) DEFAULT ' ' NOT NULL , "RSCHL_UCST" VARCHAR2(18)

DEFAULT ' ' NOT NULL , "GR_PRF_GR" VARCHAR2(12) DEFAULT ' ' NOT NULL ,

"GR_PRF_NAM" VARCHAR2(36) DEFAULT ' ' NOT NULL , "FHORI" VARCHAR2(9) DEFAULT ' '

NOT NULL , "NETSTUFE" VARCHAR2(6) DEFAULT '00' NOT NULL , "VAGRP" VARCHAR2(9)

DEFAULT ' ' NOT NULL , "MSGTY" VARCHAR2(3) DEFAULT ' ' NOT NULL , "AOB_DARST"

VARCHAR2(3) DEFAULT ' ' NOT NULL , "VRG_DARST" VARCHAR2(3) DEFAULT ' ' NOT NULL ,

"NO_DISP" VARCHAR2(3) DEFAULT ' ' NOT NULL , "COLKZ_ELEM" VARCHAR2(33) DEFAULT '

' NOT NULL , "COLKZ_TEIL" VARCHAR2(33) DEFAULT ' ' NOT NULL , "COLKZ_MLST"

VARCHAR2(33) DEFAULT ' ' NOT NULL , "COLKZ_DOKU" VARCHAR2(33) DEFAULT ' ' NOT

NULL , "COLKZ_MAT" VARCHAR2(33) DEFAULT ' ' NOT NULL , "VSPRF" VARCHAR2(21)

DEFAULT ' ' NOT NULL , "CLASF" VARCHAR2(3) DEFAULT ' ' NOT NULL , "PROFILE_ID"

VARCHAR2(30) DEFAULT ' ' NOT NULL , "BALK_PROF" VARCHAR2(36) DEFAULT ' ' NOT NULL

, "KBED" VARCHAR2(3) DEFAULT ' ' NOT NULL , "KKALKR" VARCHAR2(3) DEFAULT ' ' NOT

NULL , "LSTVAR" VARCHAR2(36) DEFAULT ' ' NOT NULL , "MATKL" VARCHAR2(27) DEFAULT

' ' NOT NULL , "MATEXIT" VARCHAR2(3) DEFAULT ' ' NOT NULL , "EKGRP" VARCHAR2(9)

DEFAULT ' ' NOT NULL , "MATKL_FRMD" VARCHAR2(27) DEFAULT ' ' NOT NULL ,

"EKGRP_FRMD" VARCHAR2(9) DEFAULT ' ' NOT NULL , "POSNR_MAT" VARCHAR2(12) DEFAULT

'0000' NOT NULL , "SCHED_END" VARCHAR2(3) DEFAULT ' ' NOT NULL , "SCEND_ACT"

VARCHAR2(3) DEFAULT ' ' NOT NULL , "NT_SEARCH1" VARCHAR2(6) DEFAULT ' ' NOT NULL

, "NT_SEARCH2" VARCHAR2(6) DEFAULT ' ' NOT NULL , "NT_SEARCH3" VARCHAR2(6)

DEFAULT ' ' NOT NULL , "MFLIC" VARCHAR2(9) DEFAULT ' ' NOT NULL , "MEINH_FRMD"

VARCHAR2(9) DEFAULT ' ' NOT NULL , "MEINH_SERV" VARCHAR2(9) DEFAULT ' ' NOT NULL

, "KSTAR_MATVORPL" VARCHAR2(30) DEFAULT ' ' NOT NULL , "KZERB" VARCHAR2(3)

DEFAULT ' ' NOT NULL , "VALID" VARCHAR2(21) DEFAULT ' ' NOT NULL , "VALID_VG"

VARCHAR2(21) DEFAULT ' ' NOT NULL , "SUBST" VARCHAR2(21) DEFAULT ' ' NOT NULL ,

"SUBST_VG" VARCHAR2(21) DEFAULT ' ' NOT NULL , "FPART" VARCHAR2(6) DEFAULT ' '

NOT NULL ) TABLESPACE PSAPIDE STORAGE (INITIAL 65536 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 4040 bytes of shared memory ("shared pool","select

i.obj#,i.ts#,i.file#,...","Typecheck","seg:kggfaAllocSeg")

(DB) INFO: disconnected from DB

E:\usr\sap\IDE\SYS\exe\run/R3load.exe: job finished with 1 error(s)

E:\usr\sap\IDE\SYS\exe\run/R3load.exe: END OF LOG: 20081201200843

SAPAPPL0.log:

(DB) INFO: PA0398~0 created #20081201200124

(DB) INFO: PA0399 created #20081201200124

(IMP) INFO: import of PA0399 completed (12 rows) #20081201200124

DbSl Trace: Error in exec_immediate()

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

(DB) ERROR: DDL statement failed

(CREATE UNIQUE INDEX "PA0399~0" ON "PA0399" ( "MANDT", "PERNR", "SUBTY",

"OBJPS", "SPRPS", "ENDDA", "BEGDA", "SEQNR" ) TABLESPACE PSAPIDE STORAGE (INITIAL

0 NEXT 0000000080K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) )

DbSlExecute: rc = 99

(SQL error 4031)

error message returned by DbSl:

ORA-04031: unable to allocate 4120 bytes of shared memory ("shared pool","CREATE

UNIQUE INDEX "PA0399~...","Typecheck","kgghteInit")

(DB) INFO: disconnected from DB

E:\usr\sap\IDE\SYS\exe\run/R3load.exe: job finished with 1 error(s)

E:\usr\sap\IDE\SYS\exe\run/R3load.exe: END OF LOG: 20081201200129

[Former Member]

Hi, sorry I should emphasize that. I am installing R3E 4.70 E2 on Windows x86 64bit

[former_member204746]

you must set shared_pool_size to 400000000 in file initIDE.ora

that's 400,000,000 (400 millions, not 40 millions like you typed earlier.

and not in file initsmpl.ora, but in file initIDE.ora

[Former Member]

Hi,

I changed shared pool to 40000000 in initIDE.ora and reset installation. However, it still got error with ora-1403.

[Former Member]

SAPCLUST.log

DbSl Trace: ORA-1403 when accessing table SAPUSER

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8

(DB) INFO: RFBLG deleted/truncated #20081203093613

myCluster (55.3.Imp): 1467: inconsistent field count detected.

myCluster (55.3.Imp): 1470: nametab says field count (TDESCR) is 305.

myCluster (55.3.Imp): 1473: alternate nametab says field count (TDESCR) is 311.

myCluster (55.3.Imp): 1181: unable to retrieve nametab info for logic table BSEG .

myCluster (55.3.Imp): 7680: unable to retrieve nametab info for logic table BSEG .

myCluster (55.3.Imp): 2449: failed to convert cluster data of cluster item.

myCluster: RFBLG *800**0001**0100000000**1995*

myCluster (55.3.Imp): 319: error during conversion of cluster item.

myCluster (55.3.Imp): 322: affected physical table is RFBLG.

(CNV) ERROR: code page conversion failed

rc = 2

.--

---

============--

---

.

RSCP - Error

Error from: Codepage handling (RSCP)

code: 128 RSCPENOOBJ No such object

Dummy module without real rscpmc[34]

module: rscpmm no: 2 line: 74 T100: TS008

TSL01: CPV p3: Dummy-IPC p4: rscpmc4_init

`----

---

'

(DB) INFO: disconnected from DB

E:\usr\sap\IDE\SYS\exe\run/R3load.exe: job finished with 1 error(s)

E:\usr\sap\IDE\SYS\exe\run/R3load.exe: END OF LOG: 20081203093627

SAPAPPLO.log

E:\usr\sap\IDE\SYS\exe\run/R3load.exe -dbcodepage 4103 -i C:\Program Files\sapinst_instdir\R3E47X2\SYSTEM\ABAP\ORA\UC\DB/SAPAPPL0.cmd -l C:\Program Files\sapinst_instdir\R3E47X2\SYSTEM\ABAP\ORA\UC\DB/SAPAPPL0.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

(DB) INFO: disconnected from DB

E:\usr\sap\IDE\SYS\exe\run/R3load.exe: job completed

E:\usr\sap\IDE\SYS\exe\run/R3load.exe: END OF LOG: 20081203093644