Skip to Content
0
Former Member
Dec 01, 2008 at 04:00 AM

ORA-604 and ORA-4031 during installation of SAP

189 Views

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.